PREVIEW / etf_30min / 2017-03-01

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-01.parquet
  size:    459 KB
  rows:    15,670

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
2017-03-01 04:00:00	SPY	ETF	237.42	237.69	237.42	237.66	78704.0
2017-03-01 04:30:00	SPY	ETF	237.64	237.69	237.56	237.6	8157.0
2017-03-01 05:00:00	SPY	ETF	237.61	237.64	237.51	237.63	6851.0
2017-03-01 05:30:00	SPY	ETF	237.66	237.74	237.63	237.73	44523.0
2017-03-01 06:00:00	SPY	ETF	237.73	237.77	237.62	237.62	10245.0
2017-03-01 06:30:00	SPY	ETF	237.63	237.71	237.53	237.63	52853.0
2017-03-01 07:00:00	SPY	ETF	237.68	237.75	237.64	237.69	137715.0
2017-03-01 07:30:00	SPY	ETF	237.68	237.89	237.66	237.88	217344.0
2017-03-01 08:00:00	SPY	ETF	237.88	238.31	237.58	238.26	728576.0
2017-03-01 08:30:00	SPY	ETF	238.26	238.26	238.08	238.24	384908.0
2017-03-01 09:00:00	SPY	ETF	238.25	238.5	238.2	238.39	1046218.0
2017-03-01 09:30:00	SPY	ETF	238.39	238.83	238.37	238.8	14159060.0
2017-03-01 10:00:00	SPY	ETF	238.81	239.19	238.78	239.0858	7866031.0
2017-03-01 10:30:00	SPY	ETF	239.085	239.13	238.84	239.11	5512784.0
2017-03-01 11:00:00	SPY	ETF	239.115	239.483	239.04	239.47	9549589.0
2017-03-01 11:30:00	SPY	ETF	239.47	239.65	239.41	239.56	7139226.0
2017-03-01 12:00:00	SPY	ETF	239.56	240.11	239.555	239.985	8528588.0
2017-03-01 12:30:00	SPY	ETF	239.99	239.99	239.76	239.8	5089425.0
2017-03-01 13:00:00	SPY	ETF	239.81	239.95	239.76	239.82	5634435.0
2017-03-01 13:30:00	SPY	ETF	239.8257	239.94	239.75	239.895	5443754.0
2017-03-01 14:00:00	SPY	ETF	239.9	240.32	239.79	240.24	11432848.0
2017-03-01 14:30:00	SPY	ETF	240.24	240.31	240.08	240.27	4575493.0
2017-03-01 15:00:00	SPY	ETF	240.27	240.27	239.98	240.0498	9051941.0
2017-03-01 15:30:00	SPY	ETF	240.04	240.18	239.68	239.75	18503083.0
2017-03-01 16:00:00	SPY	ETF	239.74	239.7962	239.52	239.6	16232904.0
2017-03-01 16:30:00	SPY	ETF	239.6	239.78	239.52	239.54	8540350.0
2017-03-01 17:00:00	SPY	ETF	239.53	239.78	239.51	239.56	6551606.0
2017-03-01 17:30:00	SPY	ETF	239.54	239.78	239.52	239.58	127781.0
2017-03-01 18:00:00	SPY	ETF	239.58	239.67	239.49	239.59	101587.0
2017-03-01 18:30:00	SPY	ETF	239.59	239.62	239.59	239.61	13901.0
2017-03-01 19:00:00	SPY	ETF	239.62	239.7	239.56	239.56	29905.0
2017-03-01 19:30:00	SPY	ETF	239.6	239.66	239.58	239.61	10088.0
2017-03-01 04:00:00	QQQ	ETF	130.6	130.64	130.26	130.63	3361.0
2017-03-01 05:00:00	QQQ	ETF	130.58	130.58	130.58	130.58	1392.0
2017-03-01 05:30:00	QQQ	ETF	130.63	130.79	130.63	130.75	5807.0
2017-03-01 06:00:00	QQQ	ETF	130.82	130.82	130.79	130.81	2113.0
2017-03-01 06:30:00	QQQ	ETF	130.69	130.69	130.65	130.65	5200.0
2017-03-01 07:00:00	QQQ	ETF	130.7	130.7	130.64	130.64	10910.0
2017-03-01 07:30:00	QQQ	ETF	130.6	130.75	130.59	130.75	19842.0
2017-03-01 08:00:00	QQQ	ETF	130.7	130.9	130.67	130.9	75848.0
2017-03-01 08:30:00	QQQ	ETF	130.89	130.89	130.72	130.8	82149.0
2017-03-01 09:00:00	QQQ	ETF	130.79	130.93	130.76	130.82	179627.0
2017-03-01 09:30:00	QQQ	ETF	130.81	130.92	130.6	130.77	3128548.0
2017-03-01 10:00:00	QQQ	ETF	130.78	131.07	130.78	130.965	1564085.0
2017-03-01 10:30:00	QQQ	ETF	130.97	131.01	130.835	131.005	841840.0
2017-03-01 11:00:00	QQQ	ETF	131.0047	131.2	130.98	131.18	1416978.0
2017-03-01 11:30:00	QQQ	ETF	131.18	131.32	131.15	131.275	1048168.0
2017-03-01 12:00:00	QQQ	ETF	131.28	131.56	131.275	131.4599	1161863.0
2017-03-01 12:30:00	QQQ	ETF	131.45	131.47	131.35	131.37	684293.0
2017-03-01 13:00:00	QQQ	ETF	131.3734	131.425	131.31	131.3601	826228.0

> showing 50 of 15,670 rows — these rows as CSV

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