PREVIEW / etf_30min / 2017-04-25

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-04-25.parquet
  size:    444 KB
  rows:    15,238

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-04-25 04:00:00	SPY	ETF	237.26	237.26	237.21	237.21	1830.0
2017-04-25 04:30:00	SPY	ETF	237.33	237.36	237.31	237.33	1350.0
2017-04-25 05:00:00	SPY	ETF	237.33	237.35	237.28	237.28	1800.0
2017-04-25 05:30:00	SPY	ETF	237.33	237.33	237.26	237.28	2836.0
2017-04-25 06:00:00	SPY	ETF	237.3	237.39	237.28	237.39	4438.0
2017-04-25 06:30:00	SPY	ETF	237.36	237.43	237.35	237.4	80304.0
2017-04-25 07:00:00	SPY	ETF	237.41	237.5	237.41	237.41	58112.0
2017-04-25 07:30:00	SPY	ETF	237.42	237.49	237.42	237.46	90231.0
2017-04-25 08:00:00	SPY	ETF	237.45	237.83	237.43	237.82	424569.0
2017-04-25 08:30:00	SPY	ETF	237.84	237.88	237.71	237.84	387644.0
2017-04-25 09:00:00	SPY	ETF	237.84	238.02	237.83	237.91	443372.0
2017-04-25 09:30:00	SPY	ETF	237.91	238.43	237.81	238.39	8940615.0
2017-04-25 10:00:00	SPY	ETF	238.39	238.75	238.3201	238.52	7053557.0
2017-04-25 10:30:00	SPY	ETF	238.53	238.57	238.37	238.38	3490019.0
2017-04-25 11:00:00	SPY	ETF	238.38	238.62	238.335	238.44	4185489.0
2017-04-25 11:30:00	SPY	ETF	238.44	238.57	238.36	238.565	4025648.0
2017-04-25 12:00:00	SPY	ETF	238.57	238.66	238.51	238.5601	2739760.0
2017-04-25 12:30:00	SPY	ETF	238.56	238.58	238.29	238.39	3069434.0
2017-04-25 13:00:00	SPY	ETF	238.4	238.71	238.36	238.59	3341387.0
2017-04-25 13:30:00	SPY	ETF	238.59	238.68	238.52	238.64	4345392.0
2017-04-25 14:00:00	SPY	ETF	238.64	238.82	238.58	238.69	4413465.0
2017-04-25 14:30:00	SPY	ETF	238.69	238.79	238.57	238.6247	2633877.0
2017-04-25 15:00:00	SPY	ETF	238.625	238.95	238.59	238.84	6451450.0
2017-04-25 15:30:00	SPY	ETF	238.83	238.83	238.53	238.53	10549854.0
2017-04-25 16:00:00	SPY	ETF	238.53	238.61	238.37	238.55	6236363.0
2017-04-25 16:30:00	SPY	ETF	238.54	238.55	238.38	238.42	401299.0
2017-04-25 17:00:00	SPY	ETF	238.4	238.44	238.36	238.43	278024.0
2017-04-25 17:30:00	SPY	ETF	238.44	238.577	238.36	238.36	516123.0
2017-04-25 18:00:00	SPY	ETF	238.36	238.38	238.3	238.34	199864.0
2017-04-25 18:30:00	SPY	ETF	238.33	238.547	238.31	238.34	438949.0
2017-04-25 19:00:00	SPY	ETF	238.35	238.39	238.34	238.37	14288.0
2017-04-25 19:30:00	SPY	ETF	238.38	238.38	238.34	238.36	33769.0
2017-04-25 20:00:00	SPY	ETF	238.55	238.55	238.5461	238.5461	233000.0
2017-04-25 04:00:00	QQQ	ETF	134.27	134.27	134.21	134.21	949.0
2017-04-25 05:00:00	QQQ	ETF	134.23	134.27	134.23	134.27	600.0
2017-04-25 06:30:00	QQQ	ETF	134.3	134.31	134.28	134.3	900.0
2017-04-25 07:00:00	QQQ	ETF	134.32	134.37	134.32	134.33	12014.0
2017-04-25 07:30:00	QQQ	ETF	134.36	134.38	134.34	134.38	24910.0
2017-04-25 08:00:00	QQQ	ETF	134.34	134.55	134.31	134.55	45911.0
2017-04-25 08:30:00	QQQ	ETF	134.55	134.55	134.48	134.55	32577.0
2017-04-25 09:00:00	QQQ	ETF	134.53	134.66	134.53	134.58	94797.0
2017-04-25 09:30:00	QQQ	ETF	134.58	134.69	134.48	134.63	3323202.0
2017-04-25 10:00:00	QQQ	ETF	134.62	134.91	134.61	134.84	2617317.0
2017-04-25 10:30:00	QQQ	ETF	134.85	134.88	134.74	134.79	821049.0
2017-04-25 11:00:00	QQQ	ETF	134.785	134.98	134.75	134.92	747787.0
2017-04-25 11:30:00	QQQ	ETF	134.93	135.04	134.89	135.03	454156.0
2017-04-25 12:00:00	QQQ	ETF	135.025	135.13	135.01	135.08	751762.0
2017-04-25 12:30:00	QQQ	ETF	135.08	135.09	134.96	135.0	607842.0
2017-04-25 13:00:00	QQQ	ETF	135.0056	135.2	134.99	135.13	636891.0
2017-04-25 13:30:00	QQQ	ETF	135.13	135.16	135.091	135.12	391865.0

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

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