PREVIEW / etf_30min / 2012-09-25

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-09-25.parquet
  size:    302 KB
  rows:    9,941

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-09-25 04:00:00	SPY	ETF	146.14	146.14	145.86	145.86	500.0
2012-09-25 04:30:00	SPY	ETF	145.86	145.86	145.63	145.63	12700.0
2012-09-25 05:00:00	SPY	ETF	145.66	145.75	145.64	145.75	27950.0
2012-09-25 05:30:00	SPY	ETF	145.69	145.69	145.61	145.61	1200.0
2012-09-25 06:00:00	SPY	ETF	145.56	145.7	145.56	145.69	21250.0
2012-09-25 06:30:00	SPY	ETF	145.73	145.73	145.7	145.7	600.0
2012-09-25 07:00:00	SPY	ETF	145.7	145.88	145.7	145.87	8365.0
2012-09-25 07:30:00	SPY	ETF	145.89	145.9	145.78	145.83	97755.0
2012-09-25 08:00:00	SPY	ETF	145.81	146.0	145.81	146.0	158124.0
2012-09-25 08:30:00	SPY	ETF	146.0	146.12	145.645	146.06	929511.0
2012-09-25 09:00:00	SPY	ETF	146.06	146.09	145.59	145.96	507420.0
2012-09-25 09:30:00	SPY	ETF	145.96	146.01	145.77	145.86	9207148.0
2012-09-25 10:00:00	SPY	ETF	145.86	146.19	145.83	145.961	11037107.0
2012-09-25 10:30:00	SPY	ETF	145.961	146.17	145.9	146.1	6029101.0
2012-09-25 11:00:00	SPY	ETF	146.11	146.24	146.05	146.06	3572252.0
2012-09-25 11:30:00	SPY	ETF	146.06	146.11	145.92	145.94	2754311.0
2012-09-25 12:00:00	SPY	ETF	145.945	145.98	145.65	145.72	5413224.0
2012-09-25 12:30:00	SPY	ETF	145.7204	145.78	145.26	145.475	12774722.0
2012-09-25 13:00:00	SPY	ETF	145.48	145.48	145.32	145.35	5673708.0
2012-09-25 13:30:00	SPY	ETF	145.36	145.58	145.24	145.38	6971400.0
2012-09-25 14:00:00	SPY	ETF	145.37	145.583	145.0	145.07	8708891.0
2012-09-25 14:30:00	SPY	ETF	145.08	145.19	144.76	144.77	7030007.0
2012-09-25 15:00:00	SPY	ETF	144.77	144.865	144.18	144.57	16798904.0
2012-09-25 15:30:00	SPY	ETF	144.56	144.72	144.06	144.14	20875047.0
2012-09-25 16:00:00	SPY	ETF	144.16	145.9	144.0597	144.17	6488923.0
2012-09-25 16:30:00	SPY	ETF	144.19	145.1292	144.19	144.35	1645836.0
2012-09-25 17:00:00	SPY	ETF	144.35	145.5833	144.3	144.39	632035.0
2012-09-25 17:30:00	SPY	ETF	144.39	144.42	144.37	144.42	46357.0
2012-09-25 18:00:00	SPY	ETF	144.4	144.4	144.34	144.34	25662.0
2012-09-25 18:30:00	SPY	ETF	144.33	144.37	144.3	144.37	35440.0
2012-09-25 19:00:00	SPY	ETF	144.35	144.35	144.26	144.28	29535.0
2012-09-25 19:30:00	SPY	ETF	144.3	144.33	144.24	144.33	14231.0
2012-09-25 05:30:00	QQQ	ETF	69.74	69.74	69.74	69.74	285.0
2012-09-25 07:00:00	QQQ	ETF	69.78	69.84	69.78	69.84	46800.0
2012-09-25 07:30:00	QQQ	ETF	69.85	69.87	69.82	69.84	16100.0
2012-09-25 08:00:00	QQQ	ETF	69.85	69.94	69.85	69.94	43782.0
2012-09-25 08:30:00	QQQ	ETF	69.95	70.01	69.95	69.99	164241.0
2012-09-25 09:00:00	QQQ	ETF	70.0	70.0	69.92	69.92	35716.0
2012-09-25 09:30:00	QQQ	ETF	69.92	69.95	69.72	69.8	3214866.0
2012-09-25 10:00:00	QQQ	ETF	69.77	69.99	69.75	69.88	2952665.0
2012-09-25 10:30:00	QQQ	ETF	69.8701	69.97	69.87	69.94	1063167.0
2012-09-25 11:00:00	QQQ	ETF	69.95	70.08	69.94	70.0	1839140.0
2012-09-25 11:30:00	QQQ	ETF	70.01	70.03	69.92	69.94	980072.0
2012-09-25 12:00:00	QQQ	ETF	69.93	69.95	69.78	69.793	1792280.0
2012-09-25 12:30:00	QQQ	ETF	69.8	69.83	69.56	69.64	2771447.0
2012-09-25 13:00:00	QQQ	ETF	69.64	69.645	69.53	69.57	1126684.0
2012-09-25 13:30:00	QQQ	ETF	69.565	69.715	69.55	69.62	1396161.0
2012-09-25 14:00:00	QQQ	ETF	69.63	69.65	69.41	69.46	2037830.0
2012-09-25 14:30:00	QQQ	ETF	69.4501	69.5	69.12	69.12	3401837.0
2012-09-25 15:00:00	QQQ	ETF	69.13	69.19	68.83	69.0516	6692258.0

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

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