PREVIEW / etf_30min / 2017-06-26

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-26.parquet
  size:    428 KB
  rows:    14,813

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-06-26 04:00:00	SPY	ETF	243.45	243.65	243.45	243.65	3428.0
2017-06-26 04:30:00	SPY	ETF	243.62	243.73	243.62	243.62	57222.0
2017-06-26 05:30:00	SPY	ETF	243.54	243.57	243.54	243.57	200.0
2017-06-26 06:00:00	SPY	ETF	243.71	243.73	243.71	243.73	3487.0
2017-06-26 06:30:00	SPY	ETF	243.73	243.81	243.66	243.81	51400.0
2017-06-26 07:00:00	SPY	ETF	243.68	243.84	243.68	243.75	65279.0
2017-06-26 07:30:00	SPY	ETF	243.72	243.84	243.72	243.84	36865.0
2017-06-26 08:00:00	SPY	ETF	243.81	243.91	243.12	243.85	400968.0
2017-06-26 08:30:00	SPY	ETF	243.86	243.87	243.78	243.82	193624.0
2017-06-26 09:00:00	SPY	ETF	243.81	243.93	243.13	243.89	844733.0
2017-06-26 09:30:00	SPY	ETF	243.9	244.38	243.87	244.36	5794519.0
2017-06-26 10:00:00	SPY	ETF	244.35	244.37	243.995	244.175	2889070.0
2017-06-26 10:30:00	SPY	ETF	244.17	244.185	243.23	243.44	6156110.0
2017-06-26 11:00:00	SPY	ETF	243.45	243.48	243.045	243.39	5631791.0
2017-06-26 11:30:00	SPY	ETF	243.4	243.68	243.18	243.6675	3579039.0
2017-06-26 12:00:00	SPY	ETF	243.66	243.72	243.46	243.49	2296434.0
2017-06-26 12:30:00	SPY	ETF	243.49	243.79	243.47	243.71	2179290.0
2017-06-26 13:00:00	SPY	ETF	243.71	243.74	243.5	243.6	1688198.0
2017-06-26 13:30:00	SPY	ETF	243.6	243.65	243.49	243.575	1138149.0
2017-06-26 14:00:00	SPY	ETF	243.57	243.62	243.38	243.52	1550078.0
2017-06-26 14:30:00	SPY	ETF	243.52	243.635	243.435	243.62	1771369.0
2017-06-26 15:00:00	SPY	ETF	243.62	243.7099	243.42	243.52	2225310.0
2017-06-26 15:30:00	SPY	ETF	243.51	243.59	243.17	243.27	10537510.0
2017-06-26 16:00:00	SPY	ETF	243.26	243.3	243.16	243.2	4919483.0
2017-06-26 16:30:00	SPY	ETF	243.21	243.6372	243.21	243.22	1105356.0
2017-06-26 17:00:00	SPY	ETF	243.22	243.28	243.22	243.26	13430.0
2017-06-26 17:30:00	SPY	ETF	243.25	243.3	243.24	243.24	32327.0
2017-06-26 18:00:00	SPY	ETF	243.24	243.24	243.11	243.21	72557.0
2017-06-26 18:30:00	SPY	ETF	243.22	243.34	243.22	243.3	25383.0
2017-06-26 19:00:00	SPY	ETF	243.32	243.34	243.31	243.33	12169.0
2017-06-26 19:30:00	SPY	ETF	243.34	243.35	243.28	243.32	5707.0
2017-06-26 04:00:00	QQQ	ETF	141.49	141.78	141.49	141.78	728.0
2017-06-26 04:30:00	QQQ	ETF	141.72	141.75	141.72	141.72	3331.0
2017-06-26 05:00:00	QQQ	ETF	141.73	141.73	141.73	141.73	5000.0
2017-06-26 05:30:00	QQQ	ETF	141.76	141.8	141.76	141.8	15000.0
2017-06-26 06:00:00	QQQ	ETF	141.78	141.81	141.74	141.74	4300.0
2017-06-26 06:30:00	QQQ	ETF	141.83	141.86	141.78	141.86	5896.0
2017-06-26 07:00:00	QQQ	ETF	141.8	141.97	141.8	141.92	34173.0
2017-06-26 07:30:00	QQQ	ETF	141.94	142.08	141.94	142.02	10192.0
2017-06-26 08:00:00	QQQ	ETF	142.0	142.08	142.0	142.05	97449.0
2017-06-26 08:30:00	QQQ	ETF	142.05	142.06	141.97	141.99	183493.0
2017-06-26 09:00:00	QQQ	ETF	141.98	142.09	141.95	142.01	86455.0
2017-06-26 09:30:00	QQQ	ETF	142.01	142.29	141.93	142.0685	3483637.0
2017-06-26 10:00:00	QQQ	ETF	142.08	142.09	141.42	141.68	2736967.0
2017-06-26 10:30:00	QQQ	ETF	141.66	141.7	140.73	140.92	4161639.0
2017-06-26 11:00:00	QQQ	ETF	140.93	140.99	140.39	140.6359	3386196.0
2017-06-26 11:30:00	QQQ	ETF	140.64	140.87	140.27	140.86	2112488.0
2017-06-26 12:00:00	QQQ	ETF	140.86	140.95	140.75	140.82	1407284.0
2017-06-26 12:30:00	QQQ	ETF	140.82	141.21	140.82	141.11	1541848.0
2017-06-26 13:00:00	QQQ	ETF	141.12	141.125	140.84	140.96	900496.0

> showing 50 of 14,813 rows — these rows as CSV

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