PREVIEW / etf_30min / 2013-09-06

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-09-06.parquet
  size:    320 KB
  rows:    10,758

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-09-06 04:00:00	SPY	ETF	165.88	165.9	165.88	165.88	1800.0
2013-09-06 04:30:00	SPY	ETF	165.9	165.96	165.88	165.96	4800.0
2013-09-06 05:00:00	SPY	ETF	165.94	165.96	165.9	165.92	3400.0
2013-09-06 05:30:00	SPY	ETF	165.9	165.9	165.86	165.86	2500.0
2013-09-06 06:00:00	SPY	ETF	165.83	165.85	165.81	165.84	2000.0
2013-09-06 06:30:00	SPY	ETF	165.9	165.92	165.89	165.92	10800.0
2013-09-06 07:00:00	SPY	ETF	165.91	166.11	165.91	166.1	30175.0
2013-09-06 07:30:00	SPY	ETF	166.11	166.23	166.1	166.22	111073.0
2013-09-06 08:00:00	SPY	ETF	166.21	166.53	165.99	166.5	839391.0
2013-09-06 08:30:00	SPY	ETF	166.51	166.94	165.82	166.83	4154860.0
2013-09-06 09:00:00	SPY	ETF	166.83	166.85	166.48	166.5	1392484.0
2013-09-06 09:30:00	SPY	ETF	166.51	166.69	164.84	165.18	30898387.0
2013-09-06 10:00:00	SPY	ETF	165.17	165.55	164.48	165.46	22402482.0
2013-09-06 10:30:00	SPY	ETF	165.47	166.33	165.47	166.27	12574850.0
2013-09-06 11:00:00	SPY	ETF	166.27	166.61	166.259	166.5	9620110.0
2013-09-06 11:30:00	SPY	ETF	166.499	166.64	166.41	166.53	5761344.0
2013-09-06 12:00:00	SPY	ETF	166.53	166.6301	166.45	166.52	3432867.0
2013-09-06 12:30:00	SPY	ETF	166.52	166.54	166.2	166.385	5232287.0
2013-09-06 13:00:00	SPY	ETF	166.38	166.66	166.375	166.53	4408896.0
2013-09-06 13:30:00	SPY	ETF	166.54	166.92	166.49	166.8	5012547.0
2013-09-06 14:00:00	SPY	ETF	166.81	166.98	166.71	166.81	5881169.0
2013-09-06 14:30:00	SPY	ETF	166.82	166.9	166.58	166.66	4347857.0
2013-09-06 15:00:00	SPY	ETF	166.66	166.73	166.22	166.45	10845573.0
2013-09-06 15:30:00	SPY	ETF	166.45	166.46	165.88	165.98	14674240.0
2013-09-06 16:00:00	SPY	ETF	165.97	166.54	165.1651	165.99	11557355.0
2013-09-06 16:30:00	SPY	ETF	165.99	166.41	165.99	166.0	2923712.0
2013-09-06 17:00:00	SPY	ETF	166.0	166.1	166.0	166.1	107810.0
2013-09-06 17:30:00	SPY	ETF	166.09	166.12	165.81	165.94	106516.0
2013-09-06 18:00:00	SPY	ETF	165.9	165.96	165.9	165.96	4046.0
2013-09-06 18:30:00	SPY	ETF	165.95	165.95	165.81	165.84	18090.0
2013-09-06 19:00:00	SPY	ETF	165.84	165.85	165.84	165.84	9695.0
2013-09-06 19:30:00	SPY	ETF	165.85	165.94	165.83	165.84	24382.0
2013-09-06 04:00:00	QQQ	ETF	76.87	76.87	76.84	76.86	2700.0
2013-09-06 04:30:00	QQQ	ETF	76.88	76.92	76.86	76.92	8600.0
2013-09-06 05:00:00	QQQ	ETF	76.9	76.9	76.88	76.9	3600.0
2013-09-06 05:30:00	QQQ	ETF	76.88	76.88	76.84	76.84	3300.0
2013-09-06 06:30:00	QQQ	ETF	76.84	76.92	76.84	76.92	6000.0
2013-09-06 07:00:00	QQQ	ETF	76.91	76.98	76.91	76.96	7700.0
2013-09-06 07:30:00	QQQ	ETF	76.98	77.02	76.97	77.02	23470.0
2013-09-06 08:00:00	QQQ	ETF	76.77	77.15	76.77	77.09	229183.0
2013-09-06 08:30:00	QQQ	ETF	77.08	77.22	77.01	77.18	361578.0
2013-09-06 09:00:00	QQQ	ETF	77.18	77.18	77.04	77.1	183202.0
2013-09-06 09:30:00	QQQ	ETF	77.1	77.17	76.3	76.4	5126342.0
2013-09-06 10:00:00	QQQ	ETF	76.4	76.67	76.05	76.6	4399488.0
2013-09-06 10:30:00	QQQ	ETF	76.6	77.0891	76.6	77.045	2438655.0
2013-09-06 11:00:00	QQQ	ETF	77.05	77.19	77.03	77.08	1706811.0
2013-09-06 11:30:00	QQQ	ETF	77.08	77.16	77.05	77.1	1145966.0
2013-09-06 12:00:00	QQQ	ETF	77.1	77.18	77.07	77.13	666953.0
2013-09-06 12:30:00	QQQ	ETF	77.13	77.15	76.99	77.0801	889616.0
2013-09-06 13:00:00	QQQ	ETF	77.09	77.15	77.08	77.115	1106741.0

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

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