PREVIEW / etf_30min / 2015-04-24

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-04-24.parquet
  size:    372 KB
  rows:    12,743

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
2015-04-24 04:00:00	SPY	ETF	211.25	211.66	211.25	211.56	76661.0
2015-04-24 04:30:00	SPY	ETF	211.55	211.8	211.55	211.72	17567.0
2015-04-24 05:00:00	SPY	ETF	211.74	211.74	211.64	211.65	25500.0
2015-04-24 05:30:00	SPY	ETF	211.54	211.54	211.34	211.37	17573.0
2015-04-24 06:00:00	SPY	ETF	211.35	211.35	211.04	211.28	22218.0
2015-04-24 06:30:00	SPY	ETF	211.24	211.49	211.24	211.44	9990.0
2015-04-24 07:00:00	SPY	ETF	211.41	211.6	211.38	211.4	32880.0
2015-04-24 07:30:00	SPY	ETF	211.39	211.48	211.29	211.45	93950.0
2015-04-24 08:00:00	SPY	ETF	211.5	211.5	211.3	211.44	360007.0
2015-04-24 08:30:00	SPY	ETF	211.45	211.65	211.24	211.6	561951.0
2015-04-24 09:00:00	SPY	ETF	211.59	211.78	211.42	211.67	863420.0
2015-04-24 09:30:00	SPY	ETF	211.66	211.76	211.12	211.54	8963233.0
2015-04-24 10:00:00	SPY	ETF	211.54	211.59	211.11	211.47	3892062.0
2015-04-24 10:30:00	SPY	ETF	211.47	211.57	211.4	211.5	2805187.0
2015-04-24 11:00:00	SPY	ETF	211.5	211.7	211.42	211.69	3007597.0
2015-04-24 11:30:00	SPY	ETF	211.69	211.79	211.5043	211.635	3066029.0
2015-04-24 12:00:00	SPY	ETF	211.63	211.9199	211.62	211.86	2675378.0
2015-04-24 12:30:00	SPY	ETF	211.865	211.97	211.67	211.73	2200312.0
2015-04-24 13:00:00	SPY	ETF	211.73	211.87	211.59	211.84	1927512.0
2015-04-24 13:30:00	SPY	ETF	211.8468	211.87	211.7	211.74	1665533.0
2015-04-24 14:00:00	SPY	ETF	211.75	211.81	211.64	211.8	2143085.0
2015-04-24 14:30:00	SPY	ETF	211.81	211.82	211.41	211.49	4512873.0
2015-04-24 15:00:00	SPY	ETF	211.49	211.62	211.43	211.59	4023828.0
2015-04-24 15:30:00	SPY	ETF	211.6	211.71	211.53	211.65	8306384.0
2015-04-24 16:00:00	SPY	ETF	211.64	211.72	211.152	211.67	5689734.0
2015-04-24 16:30:00	SPY	ETF	211.66	211.74	211.65	211.72	2378987.0
2015-04-24 17:00:00	SPY	ETF	211.72	211.75	211.6499	211.73	1305827.0
2015-04-24 17:30:00	SPY	ETF	211.74	211.78	211.62	211.67	57994.0
2015-04-24 18:00:00	SPY	ETF	211.67	211.9	211.64	211.68	13920.0
2015-04-24 18:30:00	SPY	ETF	211.68	211.69	211.65	211.65	4575.0
2015-04-24 19:00:00	SPY	ETF	211.62	211.68	211.62	211.66	6200.0
2015-04-24 19:30:00	SPY	ETF	211.66	211.7	211.66	211.69	21507.0
2015-04-24 04:00:00	QQQ	ETF	109.83	110.0	109.83	110.0	1700.0
2015-04-24 04:30:00	QQQ	ETF	110.11	110.11	110.11	110.11	500.0
2015-04-24 05:00:00	QQQ	ETF	110.06	110.19	110.05	110.05	51800.0
2015-04-24 05:30:00	QQQ	ETF	110.02	110.05	110.01	110.01	6700.0
2015-04-24 06:00:00	QQQ	ETF	109.96	110.02	109.91	109.97	18080.0
2015-04-24 06:30:00	QQQ	ETF	109.98	110.08	109.94	110.02	184066.0
2015-04-24 07:00:00	QQQ	ETF	110.02	110.09	109.97	110.0	64848.0
2015-04-24 07:30:00	QQQ	ETF	109.99	110.1	109.91	110.05	89757.0
2015-04-24 08:00:00	QQQ	ETF	110.05	110.1	109.97	110.08	147826.0
2015-04-24 08:30:00	QQQ	ETF	110.07	110.15	110.02	110.12	128264.0
2015-04-24 09:00:00	QQQ	ETF	110.11	110.26	110.07	110.22	658812.0
2015-04-24 09:30:00	QQQ	ETF	110.21	110.4	110.08	110.32	6626253.0
2015-04-24 10:00:00	QQQ	ETF	110.31	110.4	110.03	110.285	2784283.0
2015-04-24 10:30:00	QQQ	ETF	110.29	110.39	110.22	110.36	1333627.0
2015-04-24 11:00:00	QQQ	ETF	110.35	110.47	110.29	110.47	1238261.0
2015-04-24 11:30:00	QQQ	ETF	110.465	110.529	110.41	110.47	1145671.0
2015-04-24 12:00:00	QQQ	ETF	110.47	110.66	110.45	110.615	1169478.0
2015-04-24 12:30:00	QQQ	ETF	110.6199	110.69	110.48	110.52	1351038.0

> showing 50 of 12,743 rows — these rows as CSV

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