PREVIEW / etf_30min / 2013-01-11

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-11.parquet
  size:    296 KB
  rows:    10,274

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-11 04:00:00	SPY	ETF	147.1	147.1	147.05	147.05	5700.0
2013-01-11 04:30:00	SPY	ETF	147.03	147.03	147.01	147.01	900.0
2013-01-11 05:00:00	SPY	ETF	146.9	146.93	146.85	146.9	31011.0
2013-01-11 05:30:00	SPY	ETF	146.97	147.09	146.95	147.09	16750.0
2013-01-11 06:00:00	SPY	ETF	146.95	146.95	146.95	146.95	150.0
2013-01-11 06:30:00	SPY	ETF	146.95	147.08	146.95	147.03	35700.0
2013-01-11 07:00:00	SPY	ETF	147.0	147.06	146.95	147.0	75020.0
2013-01-11 07:30:00	SPY	ETF	147.01	147.15	147.01	147.05	123312.0
2013-01-11 08:00:00	SPY	ETF	147.06	147.21	146.94	147.14	365386.0
2013-01-11 08:30:00	SPY	ETF	147.14	147.17	147.02	147.03	263015.0
2013-01-11 09:00:00	SPY	ETF	147.04	147.11	146.9	147.02	560442.0
2013-01-11 09:30:00	SPY	ETF	147.04	147.11	146.69	146.72	11090912.0
2013-01-11 10:00:00	SPY	ETF	146.71	146.78	146.61	146.65	7118670.0
2013-01-11 10:30:00	SPY	ETF	146.64	146.86	146.61	146.805	5813584.0
2013-01-11 11:00:00	SPY	ETF	146.81	146.95	146.7	146.719	5112423.0
2013-01-11 11:30:00	SPY	ETF	146.71	146.98	146.67	146.94	3627664.0
2013-01-11 12:00:00	SPY	ETF	146.94	146.96	146.87	146.89	2956078.0
2013-01-11 12:30:00	SPY	ETF	146.89	146.92	146.76	146.845	2875765.0
2013-01-11 13:00:00	SPY	ETF	146.845	146.87	146.73	146.7501	2555151.0
2013-01-11 13:30:00	SPY	ETF	146.75	146.93	146.695	146.755	4322457.0
2013-01-11 14:00:00	SPY	ETF	146.75	146.96	146.74	146.941	6428284.0
2013-01-11 14:30:00	SPY	ETF	146.945	146.98	146.86	146.91	3310388.0
2013-01-11 15:00:00	SPY	ETF	146.91	147.08	146.79	147.05	6084143.0
2013-01-11 15:30:00	SPY	ETF	147.045	147.15	146.97	147.11	17671551.0
2013-01-11 16:00:00	SPY	ETF	147.12	147.12	146.8016	147.07	23388638.0
2013-01-11 16:30:00	SPY	ETF	147.08	147.1	146.8201	147.05	735210.0
2013-01-11 17:00:00	SPY	ETF	147.05	147.1	147.04	147.08	44440.0
2013-01-11 17:30:00	SPY	ETF	147.09	147.14	147.08	147.11	20590.0
2013-01-11 18:00:00	SPY	ETF	147.11	147.15	147.08	147.08	13772.0
2013-01-11 18:30:00	SPY	ETF	147.1	147.13	147.1	147.12	1313.0
2013-01-11 19:00:00	SPY	ETF	147.13	147.15	147.12	147.15	5897.0
2013-01-11 19:30:00	SPY	ETF	147.11	147.14	147.08	147.1	5032.0
2013-01-11 04:30:00	QQQ	ETF	67.07	67.07	67.07	67.07	100.0
2013-01-11 06:00:00	QQQ	ETF	67.11	67.11	67.11	67.11	100.0
2013-01-11 07:00:00	QQQ	ETF	67.14	67.14	67.12	67.12	500.0
2013-01-11 07:30:00	QQQ	ETF	67.15	67.15	67.15	67.15	2500.0
2013-01-11 08:00:00	QQQ	ETF	67.13	67.16	67.09	67.15	20650.0
2013-01-11 08:30:00	QQQ	ETF	67.13	67.16	67.09	67.1	21650.0
2013-01-11 09:00:00	QQQ	ETF	67.08	67.16	67.07	67.13	48479.0
2013-01-11 09:30:00	QQQ	ETF	67.14	67.29	67.07	67.08	3057791.0
2013-01-11 10:00:00	QQQ	ETF	67.07	67.13	67.01	67.0475	1989200.0
2013-01-11 10:30:00	QQQ	ETF	67.0488	67.14	67.03	67.09	1682647.0
2013-01-11 11:00:00	QQQ	ETF	67.09	67.14	67.02	67.03	1065496.0
2013-01-11 11:30:00	QQQ	ETF	67.03	67.18	67.0	67.17	1051369.0
2013-01-11 12:00:00	QQQ	ETF	67.17	67.18	67.12	67.13	519384.0
2013-01-11 12:30:00	QQQ	ETF	67.1391	67.16	67.0897	67.13	1258615.0
2013-01-11 13:00:00	QQQ	ETF	67.13	67.14	67.0999	67.11	331348.0
2013-01-11 13:30:00	QQQ	ETF	67.12	67.24	67.11	67.14	967782.0
2013-01-11 14:00:00	QQQ	ETF	67.15	67.25	67.12	67.25	645949.0
2013-01-11 14:30:00	QQQ	ETF	67.25	67.27	67.19	67.229	844422.0

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

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