PREVIEW / etf_30min / 2012-10-23

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-23.parquet
  size:    303 KB
  rows:    10,147

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-23 04:00:00	SPY	ETF	142.71	142.71	142.54	142.65	33649.0
2012-10-23 04:30:00	SPY	ETF	142.66	142.66	142.58	142.63	600.0
2012-10-23 05:00:00	SPY	ETF	142.51	142.75	142.49	142.75	31700.0
2012-10-23 05:30:00	SPY	ETF	142.64	142.7	142.47	142.7	53958.0
2012-10-23 06:00:00	SPY	ETF	142.68	142.71	142.44	142.49	51079.0
2012-10-23 06:30:00	SPY	ETF	142.45	142.45	141.35	141.94	406683.0
2012-10-23 07:00:00	SPY	ETF	141.95	142.16	141.94	142.15	431067.0
2012-10-23 07:30:00	SPY	ETF	142.17	142.26	142.01	142.09	492064.0
2012-10-23 08:00:00	SPY	ETF	142.1	142.175	141.86	141.89	1190498.0
2012-10-23 08:30:00	SPY	ETF	141.89	143.41	141.71	141.93	1388224.0
2012-10-23 09:00:00	SPY	ETF	141.93	142.03	141.79	141.86	1239471.0
2012-10-23 09:30:00	SPY	ETF	141.86	141.92	141.37	141.57	22003692.0
2012-10-23 10:00:00	SPY	ETF	141.57	141.82	141.22	141.3	17635433.0
2012-10-23 10:30:00	SPY	ETF	141.3	141.31	140.83	141.18	17788822.0
2012-10-23 11:00:00	SPY	ETF	141.18	141.36	141.11	141.28	10663864.0
2012-10-23 11:30:00	SPY	ETF	141.28	141.28	140.98	141.25	7740905.0
2012-10-23 12:00:00	SPY	ETF	141.25	141.5	141.145	141.41	6951689.0
2012-10-23 12:30:00	SPY	ETF	141.41	141.68	141.4	141.61	8566655.0
2012-10-23 13:00:00	SPY	ETF	141.6	141.87	141.52	141.63	9687211.0
2012-10-23 13:30:00	SPY	ETF	141.63	141.75	141.43	141.68	7927302.0
2012-10-23 14:00:00	SPY	ETF	141.68	141.865	141.27	141.54	10854144.0
2012-10-23 14:30:00	SPY	ETF	141.55	141.98	141.44	141.89	11836196.0
2012-10-23 15:00:00	SPY	ETF	141.8899	142.06	141.63	141.63	14320073.0
2012-10-23 15:30:00	SPY	ETF	141.64	141.74	141.3	141.4	21242873.0
2012-10-23 16:00:00	SPY	ETF	141.39	141.4577	141.2	141.25	13738071.0
2012-10-23 16:30:00	SPY	ETF	141.25	143.483	141.226	141.46	4381147.0
2012-10-23 17:00:00	SPY	ETF	141.45	141.48	141.4	141.46	125228.0
2012-10-23 17:30:00	SPY	ETF	141.44	141.47	141.39	141.47	42880.0
2012-10-23 18:00:00	SPY	ETF	141.49	141.49	141.45	141.45	42651.0
2012-10-23 18:30:00	SPY	ETF	141.47	141.49	141.45	141.45	11565.0
2012-10-23 19:00:00	SPY	ETF	141.47	141.48	141.41	141.45	15140.0
2012-10-23 19:30:00	SPY	ETF	141.45	141.54	141.44	141.53	77449.0
2012-10-23 04:00:00	QQQ	ETF	65.66	65.66	65.66	65.66	100.0
2012-10-23 04:30:00	QQQ	ETF	65.64	65.64	65.62	65.63	900.0
2012-10-23 05:00:00	QQQ	ETF	65.6	65.67	65.55	65.64	3000.0
2012-10-23 06:00:00	QQQ	ETF	65.61	65.61	65.55	65.55	3000.0
2012-10-23 06:30:00	QQQ	ETF	65.5	65.5	65.36	65.39	20629.0
2012-10-23 07:00:00	QQQ	ETF	65.39	65.5	65.38	65.49	28600.0
2012-10-23 07:30:00	QQQ	ETF	65.51	65.54	65.39	65.46	59200.0
2012-10-23 08:00:00	QQQ	ETF	65.46	65.53	65.36	65.39	76868.0
2012-10-23 08:30:00	QQQ	ETF	65.37	65.4	65.31	65.39	310038.0
2012-10-23 09:00:00	QQQ	ETF	65.4	65.5	65.36	65.47	142972.0
2012-10-23 09:30:00	QQQ	ETF	65.48	65.57	65.3	65.45	5250073.0
2012-10-23 10:00:00	QQQ	ETF	65.44	65.68	65.41	65.46	2797394.0
2012-10-23 10:30:00	QQQ	ETF	65.46	65.46	65.19	65.43	4421904.0
2012-10-23 11:00:00	QQQ	ETF	65.43	65.54	65.405	65.51	2951982.0
2012-10-23 11:30:00	QQQ	ETF	65.51	65.52	65.342	65.52	2374590.0
2012-10-23 12:00:00	QQQ	ETF	65.52	65.62	65.445	65.58	1605686.0
2012-10-23 12:30:00	QQQ	ETF	65.58	65.85	65.58	65.77	2591788.0
2012-10-23 13:00:00	QQQ	ETF	65.77	65.95	65.71	65.78	2366188.0

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

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