PREVIEW / etf_30min / 2013-01-02

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-02.parquet
  size:    340 KB
  rows:    11,452

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
2013-01-02 04:00:00	SPY	ETF	142.83	143.41	142.83	143.4	1283.0
2013-01-02 04:30:00	SPY	ETF	143.37	143.69	143.37	143.69	32622.0
2013-01-02 05:00:00	SPY	ETF	143.65	143.86	143.51	143.85	10275.0
2013-01-02 05:30:00	SPY	ETF	143.93	144.1	143.89	144.1	19686.0
2013-01-02 06:00:00	SPY	ETF	144.22	144.95	143.97	144.38	232540.0
2013-01-02 06:30:00	SPY	ETF	144.38	144.6	144.24	144.32	345491.0
2013-01-02 07:00:00	SPY	ETF	144.32	144.59	144.32	144.59	372158.0
2013-01-02 07:30:00	SPY	ETF	144.59	144.94	144.54	144.73	584869.0
2013-01-02 08:00:00	SPY	ETF	144.72	144.94	144.4	144.88	1186888.0
2013-01-02 08:30:00	SPY	ETF	144.9	145.09	144.88	144.9	1347588.0
2013-01-02 09:00:00	SPY	ETF	144.91	145.14	144.73	145.11	2784509.0
2013-01-02 09:30:00	SPY	ETF	145.11	145.58	144.935	145.45	34008737.0
2013-01-02 10:00:00	SPY	ETF	145.46	145.59	145.17	145.3	15078077.0
2013-01-02 10:30:00	SPY	ETF	145.29	145.32	144.97	145.08	12740396.0
2013-01-02 11:00:00	SPY	ETF	145.08	145.17	144.83	144.999	9179368.0
2013-01-02 11:30:00	SPY	ETF	144.99	145.03	144.74	144.785	6829583.0
2013-01-02 12:00:00	SPY	ETF	144.799	145.05	144.73	144.9101	7248713.0
2013-01-02 12:30:00	SPY	ETF	144.91	144.96	144.77	144.835	5909641.0
2013-01-02 13:00:00	SPY	ETF	144.835	144.99	144.81	144.96	5317174.0
2013-01-02 13:30:00	SPY	ETF	144.95	145.02	144.81	144.905	5562730.0
2013-01-02 14:00:00	SPY	ETF	144.91	145.14	144.85	145.07	7740763.0
2013-01-02 14:30:00	SPY	ETF	145.07	145.08	144.88	145.06	5427812.0
2013-01-02 15:00:00	SPY	ETF	145.07	145.38	145.06	145.3	11539680.0
2013-01-02 15:30:00	SPY	ETF	145.295	146.11	145.28	146.09	30339944.0
2013-01-02 16:00:00	SPY	ETF	146.08	146.15	142.4251	146.03	11081718.0
2013-01-02 16:30:00	SPY	ETF	146.01	146.11	145.387	146.05	4215997.0
2013-01-02 17:00:00	SPY	ETF	146.05	146.08	145.93	145.94	5756314.0
2013-01-02 17:30:00	SPY	ETF	145.95	145.96	145.91	145.92	50788.0
2013-01-02 18:00:00	SPY	ETF	145.91	145.92	145.77	145.78	167898.0
2013-01-02 18:30:00	SPY	ETF	145.77	145.82	145.75	145.76	110777.0
2013-01-02 19:00:00	SPY	ETF	145.8	145.8	145.72	145.76	23560.0
2013-01-02 19:30:00	SPY	ETF	145.76	145.8	145.72	145.73	56832.0
2013-01-02 04:00:00	QQQ	ETF	65.5	65.5	65.5	65.5	913.0
2013-01-02 05:00:00	QQQ	ETF	65.8	65.99	65.8	65.99	2112.0
2013-01-02 06:00:00	QQQ	ETF	66.1	66.28	66.1	66.14	3375.0
2013-01-02 06:30:00	QQQ	ETF	66.11	66.25	66.11	66.11	800.0
2013-01-02 07:00:00	QQQ	ETF	66.11	66.17	66.1	66.16	18575.0
2013-01-02 07:30:00	QQQ	ETF	66.2	66.47	66.2	66.4	484853.0
2013-01-02 08:00:00	QQQ	ETF	66.39	66.46	66.12	66.43	1477941.0
2013-01-02 08:30:00	QQQ	ETF	66.44	66.6	66.44	66.54	1481943.0
2013-01-02 09:00:00	QQQ	ETF	66.55	66.71	66.51	66.7	3345899.0
2013-01-02 09:30:00	QQQ	ETF	66.7	67.0985	66.69	66.9781	16815591.0
2013-01-02 10:00:00	QQQ	ETF	66.98	66.99	66.75	66.87	3881467.0
2013-01-02 10:30:00	QQQ	ETF	66.86	66.88	66.63	66.69	3153980.0
2013-01-02 11:00:00	QQQ	ETF	66.69	66.73	66.5	66.64	2496708.0
2013-01-02 11:30:00	QQQ	ETF	66.64	66.66	66.5	66.54	3027361.0
2013-01-02 12:00:00	QQQ	ETF	66.535	66.67	66.48	66.6	2468553.0
2013-01-02 12:30:00	QQQ	ETF	66.6	66.64	66.51	66.61	1331744.0
2013-01-02 13:00:00	QQQ	ETF	66.61	66.74	66.59	66.7	1343847.0
2013-01-02 13:30:00	QQQ	ETF	66.7	66.74	66.57	66.62	1112856.0

> showing 50 of 11,452 rows — these rows as CSV

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