PREVIEW / etf_30min / 2012-10-10

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-10.parquet
  size:    284 KB
  rows:    9,492

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
2012-10-10 04:00:00	SPY	ETF	144.23	144.23	144.22	144.22	3400.0
2012-10-10 04:30:00	SPY	ETF	144.2	144.2	144.07	144.2	600.0
2012-10-10 05:00:00	SPY	ETF	144.15	144.15	143.89	143.89	107300.0
2012-10-10 05:30:00	SPY	ETF	143.89	143.89	143.83	143.89	31200.0
2012-10-10 06:00:00	SPY	ETF	143.99	144.04	143.99	144.04	6650.0
2012-10-10 06:30:00	SPY	ETF	144.07	144.11	144.06	144.08	17189.0
2012-10-10 07:00:00	SPY	ETF	144.06	144.17	144.05	144.12	15452.0
2012-10-10 07:30:00	SPY	ETF	144.12	144.29	144.05	144.25	130690.0
2012-10-10 08:00:00	SPY	ETF	144.25	144.32	144.19	144.21	184002.0
2012-10-10 08:30:00	SPY	ETF	144.2	144.22	144.0	144.12	345410.0
2012-10-10 09:00:00	SPY	ETF	144.12	144.25	144.08	144.18	531896.0
2012-10-10 09:30:00	SPY	ETF	144.18	144.27	143.77	143.9	13307167.0
2012-10-10 10:00:00	SPY	ETF	143.92	144.27	143.89	144.26	10039927.0
2012-10-10 10:30:00	SPY	ETF	144.26	144.32	143.95	144.05	6612502.0
2012-10-10 11:00:00	SPY	ETF	144.05	144.12	143.9	143.96	4617804.0
2012-10-10 11:30:00	SPY	ETF	143.955	143.96	143.51	143.635	8933621.0
2012-10-10 12:00:00	SPY	ETF	143.64	143.81	143.535	143.65	6391382.0
2012-10-10 12:30:00	SPY	ETF	143.65	143.655	143.14	143.18	10400729.0
2012-10-10 13:00:00	SPY	ETF	143.18	143.42	143.1	143.35	8927486.0
2012-10-10 13:30:00	SPY	ETF	143.346	143.49	143.17	143.26	8129718.0
2012-10-10 14:00:00	SPY	ETF	143.26	143.57	143.26	143.3875	8254219.0
2012-10-10 14:30:00	SPY	ETF	143.39	143.46	143.18	143.28	4895978.0
2012-10-10 15:00:00	SPY	ETF	143.28	143.5	143.17	143.29	8207744.0
2012-10-10 15:30:00	SPY	ETF	143.29	143.35	143.09	143.33	13971771.0
2012-10-10 16:00:00	SPY	ETF	143.33	144.1946	143.16	143.18	4951318.0
2012-10-10 16:30:00	SPY	ETF	143.18	143.2849	142.74	142.95	1810052.0
2012-10-10 17:00:00	SPY	ETF	142.95	143.01	142.83	142.84	314797.0
2012-10-10 17:30:00	SPY	ETF	142.85	142.97	142.85	142.9	88098.0
2012-10-10 18:00:00	SPY	ETF	142.88	142.88	142.76	142.81	122141.0
2012-10-10 18:30:00	SPY	ETF	142.82	142.85	142.75	142.83	98263.0
2012-10-10 19:00:00	SPY	ETF	142.83	142.94	142.83	142.85	27783.0
2012-10-10 19:30:00	SPY	ETF	142.86	142.91	142.83	142.83	111629.0
2012-10-10 04:00:00	QQQ	ETF	67.21	67.21	67.21	67.21	200.0
2012-10-10 04:30:00	QQQ	ETF	67.15	67.15	67.15	67.15	100.0
2012-10-10 05:30:00	QQQ	ETF	67.01	67.02	67.01	67.02	300.0
2012-10-10 07:00:00	QQQ	ETF	67.1	67.18	67.1	67.18	13000.0
2012-10-10 07:30:00	QQQ	ETF	67.18	67.26	67.15	67.25	62170.0
2012-10-10 08:00:00	QQQ	ETF	67.26	67.32	67.04	67.27	258867.0
2012-10-10 08:30:00	QQQ	ETF	67.26	67.26	67.17	67.25	143185.0
2012-10-10 09:00:00	QQQ	ETF	67.25	67.29	67.2	67.24	272661.0
2012-10-10 09:30:00	QQQ	ETF	67.24	67.36	67.04	67.23	4121339.0
2012-10-10 10:00:00	QQQ	ETF	67.23	67.4	67.19	67.38	3557141.0
2012-10-10 10:30:00	QQQ	ETF	67.38	67.43	67.18	67.2301	2764002.0
2012-10-10 11:00:00	QQQ	ETF	67.235	67.27	67.17	67.23	2648547.0
2012-10-10 11:30:00	QQQ	ETF	67.23	67.251	67.01	67.09	2221030.0
2012-10-10 12:00:00	QQQ	ETF	67.08	67.19	67.03	67.11	2506212.0
2012-10-10 12:30:00	QQQ	ETF	67.11	67.1199	66.865	66.88	2251938.0
2012-10-10 13:00:00	QQQ	ETF	66.88	66.97	66.82	66.89	2163245.0
2012-10-10 13:30:00	QQQ	ETF	66.89	66.95	66.84	66.905	1161863.0
2012-10-10 14:00:00	QQQ	ETF	66.91	67.05	66.905	66.99	1429729.0

> showing 50 of 9,492 rows — these rows as CSV

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