PREVIEW / etf_30min / 2010-05-06

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-05-06.parquet
  size:    295 KB
  rows:    10,003

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2010-05-06 04:00:00	SPY	ETF	116.86	116.86	116.86	116.86	200.0
2010-05-06 04:30:00	SPY	ETF	117.1	117.2	117.1	117.15	1000.0
2010-05-06 05:00:00	SPY	ETF	117.23	117.23	117.23	117.23	4000.0
2010-05-06 05:30:00	SPY	ETF	117.0	117.1	117.0	117.08	7100.0
2010-05-06 06:00:00	SPY	ETF	117.2	117.3	117.2	117.3	33800.0
2010-05-06 06:30:00	SPY	ETF	117.33	117.35	117.3	117.3	21250.0
2010-05-06 07:00:00	SPY	ETF	117.33	117.33	117.07	117.24	172640.0
2010-05-06 07:30:00	SPY	ETF	117.18	117.26	116.75	116.79	793093.0
2010-05-06 08:00:00	SPY	ETF	116.8	116.99	116.51	116.84	3016324.0
2010-05-06 08:30:00	SPY	ETF	116.8	117.32	116.06	116.12	5982533.0
2010-05-06 09:00:00	SPY	ETF	116.11	116.62	116.02	116.25	3842265.0
2010-05-06 09:30:00	SPY	ETF	116.26	116.94	116.25	116.66	37630338.0
2010-05-06 10:00:00	SPY	ETF	116.66	117.0	116.27	116.28	25779394.0
2010-05-06 10:30:00	SPY	ETF	116.29	116.6	115.82	116.04	30671970.0
2010-05-06 11:00:00	SPY	ETF	116.01	116.15	115.34	115.82	37905648.0
2010-05-06 11:30:00	SPY	ETF	115.81	115.82	115.22	115.68	28591118.0
2010-05-06 12:00:00	SPY	ETF	115.69	116.2	115.5	115.85	21560797.0
2010-05-06 12:30:00	SPY	ETF	115.86	116.0	115.34	115.7	16955160.0
2010-05-06 13:00:00	SPY	ETF	115.7	115.84	114.92	115.23	27603535.0
2010-05-06 13:30:00	SPY	ETF	115.23	115.363	114.58	114.7026	26884116.0
2010-05-06 14:00:00	SPY	ETF	114.7	114.85	112.97	113.52	63960730.0
2010-05-06 14:30:00	SPY	ETF	113.52	114.8	105.0	111.79	114290220.0
2010-05-06 15:00:00	SPY	ETF	111.8	113.74	110.92	112.27	75462239.0
2010-05-06 15:30:00	SPY	ETF	112.27	114.11	111.5	112.88	64048016.0
2010-05-06 16:00:00	SPY	ETF	112.88	116.84	109.65	112.93	21278709.0
2010-05-06 16:30:00	SPY	ETF	112.93	116.8061	112.0	112.13	15790437.0
2010-05-06 17:00:00	SPY	ETF	112.14	116.8061	112.12	112.2	4329156.0
2010-05-06 17:30:00	SPY	ETF	112.2	116.8061	112.11	112.23	2368603.0
2010-05-06 18:00:00	SPY	ETF	112.18	113.0316	112.15	112.28	10781814.0
2010-05-06 18:30:00	SPY	ETF	112.24	112.25	112.04	112.18	114120.0
2010-05-06 19:00:00	SPY	ETF	112.17	112.29	111.87	112.16	171477.0
2010-05-06 19:30:00	SPY	ETF	112.19	112.51	112.12	112.46	143747.0
2010-05-06 20:00:00	SPY	ETF	112.38	112.38	112.38	112.38	100.0
2010-05-06 04:00:00	QQQ	ETF	48.22	48.22	48.22	48.22	200.0
2010-05-06 05:30:00	QQQ	ETF	48.2	48.2	48.2	48.2	200.0
2010-05-06 06:00:00	QQQ	ETF	48.3	48.3	48.3	48.3	30000.0
2010-05-06 06:30:00	QQQ	ETF	48.3	48.33	48.27	48.33	20630.0
2010-05-06 07:00:00	QQQ	ETF	48.32	48.33	48.22	48.3	75645.0
2010-05-06 07:30:00	QQQ	ETF	48.28	48.28	48.11	48.14	72553.0
2010-05-06 08:00:00	QQQ	ETF	48.16	48.308	48.04	48.16	376521.0
2010-05-06 08:30:00	QQQ	ETF	48.16	48.22	47.77	47.78	1551698.0
2010-05-06 09:00:00	QQQ	ETF	47.8	48.0	47.75	47.86	718041.0
2010-05-06 09:30:00	QQQ	ETF	47.85	48.24	47.83	48.18	16181006.0
2010-05-06 10:00:00	QQQ	ETF	48.18	48.3201	48.01	48.02	7883223.0
2010-05-06 10:30:00	QQQ	ETF	48.02	48.1295	47.81	47.89	10005825.0
2010-05-06 11:00:00	QQQ	ETF	47.89	47.89	47.62	47.83	15430740.0
2010-05-06 11:30:00	QQQ	ETF	47.82	47.83	47.58	47.82	14221498.0
2010-05-06 12:00:00	QQQ	ETF	47.82	48.02	47.79	47.88	11031747.0
2010-05-06 12:30:00	QQQ	ETF	47.88	47.9401	47.61	47.77	8131882.0
2010-05-06 13:00:00	QQQ	ETF	47.77	47.82	47.43	47.52	9779117.0

> showing 50 of 10,003 rows — these rows as CSV

> unlock the full archive -- $79 one-time