PREVIEW / etf_30min / 2013-01-29

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-29.parquet
  size:    310 KB
  rows:    10,504

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-29 05:00:00	SPY	ETF	149.87	149.87	149.87	149.87	479.0
2013-01-29 05:30:00	SPY	ETF	149.85	149.85	149.59	149.6	198006.0
2013-01-29 06:00:00	SPY	ETF	149.59	149.65	149.58	149.59	216302.0
2013-01-29 06:30:00	SPY	ETF	149.56	149.59	149.5	149.56	38877.0
2013-01-29 07:00:00	SPY	ETF	149.57	149.6	149.5	149.58	82178.0
2013-01-29 07:30:00	SPY	ETF	149.62	149.65	149.53	149.58	104813.0
2013-01-29 08:00:00	SPY	ETF	149.58	149.75	149.51	149.63	322179.0
2013-01-29 08:30:00	SPY	ETF	149.65	149.79	149.64	149.72	1067729.0
2013-01-29 09:00:00	SPY	ETF	149.73	149.78	149.65	149.77	610525.0
2013-01-29 09:30:00	SPY	ETF	149.77	150.18	149.7	149.99	11330199.0
2013-01-29 10:00:00	SPY	ETF	149.98	150.15	149.67	149.997	12055776.0
2013-01-29 10:30:00	SPY	ETF	150.0	150.18	149.89	150.09	8070646.0
2013-01-29 11:00:00	SPY	ETF	150.1	150.48	150.02	150.46	7819759.0
2013-01-29 11:30:00	SPY	ETF	150.46	150.48	150.32	150.4	5773671.0
2013-01-29 12:00:00	SPY	ETF	150.3902	150.415	150.31	150.35	5418596.0
2013-01-29 12:30:00	SPY	ETF	150.35	150.58	150.34	150.505	4367003.0
2013-01-29 13:00:00	SPY	ETF	150.5	150.64	150.49	150.54	4970458.0
2013-01-29 13:30:00	SPY	ETF	150.535	150.68	150.51	150.63	5344246.0
2013-01-29 14:00:00	SPY	ETF	150.625	150.71	150.56	150.56	2765132.0
2013-01-29 14:30:00	SPY	ETF	150.56	150.66	150.54	150.58	3804300.0
2013-01-29 15:00:00	SPY	ETF	150.58	150.79	150.52	150.75	6155041.0
2013-01-29 15:30:00	SPY	ETF	150.76	150.85	150.66	150.67	12636638.0
2013-01-29 16:00:00	SPY	ETF	150.67	150.92	150.074	150.81	4741912.0
2013-01-29 16:30:00	SPY	ETF	150.83	150.87	149.919	150.86	2937605.0
2013-01-29 17:00:00	SPY	ETF	150.87	150.94	150.86	150.91	122690.0
2013-01-29 17:30:00	SPY	ETF	150.9	150.91	150.87	150.89	49352.0
2013-01-29 18:00:00	SPY	ETF	150.87	150.87	150.78	150.79	34388.0
2013-01-29 18:30:00	SPY	ETF	150.8	150.81	150.79	150.81	16500.0
2013-01-29 19:00:00	SPY	ETF	150.8	150.84	150.8	150.81	19000.0
2013-01-29 19:30:00	SPY	ETF	150.84	150.89	150.82	150.88	18014.0
2013-01-29 04:00:00	QQQ	ETF	67.05	67.05	67.05	67.05	100.0
2013-01-29 04:30:00	QQQ	ETF	67.05	67.05	67.05	67.05	700.0
2013-01-29 05:30:00	QQQ	ETF	66.95	66.95	66.95	66.95	100.0
2013-01-29 06:00:00	QQQ	ETF	66.9	66.9	66.9	66.9	150.0
2013-01-29 06:30:00	QQQ	ETF	66.87	66.92	66.87	66.92	2100.0
2013-01-29 07:00:00	QQQ	ETF	66.93	66.93	66.87	66.91	48765.0
2013-01-29 07:30:00	QQQ	ETF	66.95	66.95	66.9	66.91	57500.0
2013-01-29 08:00:00	QQQ	ETF	66.91	66.99	66.9	66.98	117750.0
2013-01-29 08:30:00	QQQ	ETF	66.99	67.05	66.97	66.99	70987.0
2013-01-29 09:00:00	QQQ	ETF	67.0	67.06	66.96	67.05	103943.0
2013-01-29 09:30:00	QQQ	ETF	67.06	67.07	66.85	66.95	5668580.0
2013-01-29 10:00:00	QQQ	ETF	66.96	66.98	66.63	66.81	5153795.0
2013-01-29 10:30:00	QQQ	ETF	66.81	67.0	66.74	66.93	3051908.0
2013-01-29 11:00:00	QQQ	ETF	66.93	67.2	66.88	67.19	2201185.0
2013-01-29 11:30:00	QQQ	ETF	67.19	67.215	67.14	67.19	2657069.0
2013-01-29 12:00:00	QQQ	ETF	67.18	67.1801	67.02	67.05	1004928.0
2013-01-29 12:30:00	QQQ	ETF	67.058	67.19	67.02	67.14	624809.0
2013-01-29 13:00:00	QQQ	ETF	67.14	67.19	67.0602	67.11	1069578.0
2013-01-29 13:30:00	QQQ	ETF	67.11	67.19	67.1	67.1521	1179427.0
2013-01-29 14:00:00	QQQ	ETF	67.16	67.2	67.1	67.102	819976.0

> showing 50 of 10,504 rows — these rows as CSV

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