PREVIEW / etf_30min / 2013-12-11

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-12-11.parquet
  size:    337 KB
  rows:    11,226

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-12-11 04:00:00	SPY	ETF	180.8	181.37	180.48	180.6	8332.0
2013-12-11 04:30:00	SPY	ETF	180.63	180.7	180.54	180.66	28812.0
2013-12-11 05:00:00	SPY	ETF	180.63	180.81	180.63	180.81	4376.0
2013-12-11 05:30:00	SPY	ETF	180.8	180.8	180.69	180.74	8600.0
2013-12-11 06:00:00	SPY	ETF	180.72	180.85	180.72	180.78	25269.0
2013-12-11 06:30:00	SPY	ETF	180.78	180.78	180.64	180.69	37485.0
2013-12-11 07:00:00	SPY	ETF	180.7	180.84	180.66	180.84	52387.0
2013-12-11 07:30:00	SPY	ETF	180.84	180.96	180.84	180.92	144362.0
2013-12-11 08:00:00	SPY	ETF	180.92	181.0	180.66	180.91	226123.0
2013-12-11 08:30:00	SPY	ETF	180.9	180.92	180.84	180.9	205488.0
2013-12-11 09:00:00	SPY	ETF	180.9	180.93	180.81	180.81	377792.0
2013-12-11 09:30:00	SPY	ETF	180.81	180.85	180.02	180.29	12358448.0
2013-12-11 10:00:00	SPY	ETF	180.29	180.3	179.68	179.7	10407092.0
2013-12-11 10:30:00	SPY	ETF	179.69	179.96	179.67	179.92	8055246.0
2013-12-11 11:00:00	SPY	ETF	179.92	179.98	179.54	179.68	5803999.0
2013-12-11 11:30:00	SPY	ETF	179.68	179.69	179.44	179.65	7153668.0
2013-12-11 12:00:00	SPY	ETF	179.65	179.65	179.15	179.191	7225079.0
2013-12-11 12:30:00	SPY	ETF	179.19	179.43	179.15	179.35	5362662.0
2013-12-11 13:00:00	SPY	ETF	179.36	179.59	179.3	179.315	4119578.0
2013-12-11 13:30:00	SPY	ETF	179.31	179.7	179.28	179.69	5934156.0
2013-12-11 14:00:00	SPY	ETF	179.698	179.7	179.26	179.43	4957831.0
2013-12-11 14:30:00	SPY	ETF	179.43	179.5	179.15	179.22	5383784.0
2013-12-11 15:00:00	SPY	ETF	179.22	179.281	178.85	178.9	10783856.0
2013-12-11 15:30:00	SPY	ETF	178.91	179.01	178.5	178.68	24830445.0
2013-12-11 16:00:00	SPY	ETF	178.68	180.7702	178.59	178.63	8337742.0
2013-12-11 16:30:00	SPY	ETF	178.63	178.76	178.62	178.64	447908.0
2013-12-11 17:00:00	SPY	ETF	178.64	178.64	178.55	178.6	634473.0
2013-12-11 17:30:00	SPY	ETF	178.6	178.64	178.5	178.64	174847.0
2013-12-11 18:00:00	SPY	ETF	178.64	178.8	178.64	178.72	66914.0
2013-12-11 18:30:00	SPY	ETF	178.71	178.72	178.68	178.7	10833.0
2013-12-11 19:00:00	SPY	ETF	178.7	178.8	178.7	178.78	328342.0
2013-12-11 19:30:00	SPY	ETF	178.79	178.8	178.74	178.74	47924.0
2013-12-11 04:00:00	QQQ	ETF	86.13	86.13	86.06	86.06	1520.0
2013-12-11 04:30:00	QQQ	ETF	86.17	86.19	86.16	86.19	6000.0
2013-12-11 05:00:00	QQQ	ETF	86.22	86.25	86.22	86.25	2100.0
2013-12-11 05:30:00	QQQ	ETF	86.22	86.22	86.22	86.22	800.0
2013-12-11 06:00:00	QQQ	ETF	86.25	86.25	86.22	86.22	1600.0
2013-12-11 06:30:00	QQQ	ETF	86.23	86.23	86.19	86.19	1600.0
2013-12-11 07:00:00	QQQ	ETF	86.18	86.26	86.17	86.26	224664.0
2013-12-11 07:30:00	QQQ	ETF	86.27	86.31	86.27	86.3	53630.0
2013-12-11 08:00:00	QQQ	ETF	86.25	86.36	86.25	86.3	59526.0
2013-12-11 08:30:00	QQQ	ETF	86.31	86.31	86.28	86.3	19435.0
2013-12-11 09:00:00	QQQ	ETF	86.3	86.32	86.27	86.27	346991.0
2013-12-11 09:30:00	QQQ	ETF	86.27	86.401	85.9799	86.13	4743254.0
2013-12-11 10:00:00	QQQ	ETF	86.13	86.13	85.82	85.83	3330105.0
2013-12-11 10:30:00	QQQ	ETF	85.83	85.99	85.815	85.95	2498846.0
2013-12-11 11:00:00	QQQ	ETF	85.95	86.0	85.8	85.88	1658368.0
2013-12-11 11:30:00	QQQ	ETF	85.88	85.88	85.75	85.82	1517462.0
2013-12-11 12:00:00	QQQ	ETF	85.811	85.82	85.51	85.52	2369325.0
2013-12-11 12:30:00	QQQ	ETF	85.51	85.6	85.4801	85.53	1655536.0

> showing 50 of 11,226 rows — these rows as CSV

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