PREVIEW / etf_30min / 2012-05-03

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-03.parquet
  size:    281 KB
  rows:    9,474

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-05-03 04:00:00	SPY	ETF	140.73	140.73	140.45	140.45	500.0
2012-05-03 04:30:00	SPY	ETF	140.36	140.36	140.15	140.15	8000.0
2012-05-03 05:00:00	SPY	ETF	140.3	140.32	140.3	140.32	500.0
2012-05-03 05:30:00	SPY	ETF	140.31	140.32	140.31	140.32	40000.0
2012-05-03 06:00:00	SPY	ETF	140.51	140.51	140.44	140.48	13522.0
2012-05-03 06:30:00	SPY	ETF	140.53	140.57	140.49	140.54	21600.0
2012-05-03 07:00:00	SPY	ETF	140.56	140.65	140.56	140.63	149065.0
2012-05-03 07:30:00	SPY	ETF	140.58	140.69	140.57	140.67	93195.0
2012-05-03 08:00:00	SPY	ETF	140.6	140.64	140.4	140.49	334080.0
2012-05-03 08:30:00	SPY	ETF	140.51	140.81	140.32	140.46	2402878.0
2012-05-03 09:00:00	SPY	ETF	140.44	140.5	140.3	140.34	845201.0
2012-05-03 09:30:00	SPY	ETF	140.34	140.45	140.1	140.29	12695411.0
2012-05-03 10:00:00	SPY	ETF	140.28	140.28	139.64	139.86	16841033.0
2012-05-03 10:30:00	SPY	ETF	139.86	140.4	139.77	140.18	8885590.0
2012-05-03 11:00:00	SPY	ETF	140.18	140.27	140.08	140.18	6319815.0
2012-05-03 11:30:00	SPY	ETF	140.18	140.24	139.65	139.7499	8247105.0
2012-05-03 12:00:00	SPY	ETF	139.7412	139.8	139.61	139.7574	5973600.0
2012-05-03 12:30:00	SPY	ETF	139.759	139.86	139.67	139.67	4011535.0
2012-05-03 13:00:00	SPY	ETF	139.67	139.72	139.5	139.679	6182026.0
2012-05-03 13:30:00	SPY	ETF	139.68	139.68	139.05	139.2	14756097.0
2012-05-03 14:00:00	SPY	ETF	139.2	139.29	139.08	139.18	5536732.0
2012-05-03 14:30:00	SPY	ETF	139.17	139.24	138.99	139.15	6379873.0
2012-05-03 15:00:00	SPY	ETF	139.15	139.48	139.09	139.36	9387785.0
2012-05-03 15:30:00	SPY	ETF	139.355	139.47	139.2	139.29	18918724.0
2012-05-03 16:00:00	SPY	ETF	139.29	139.2982	139.05	139.16	7532505.0
2012-05-03 16:30:00	SPY	ETF	139.18	139.27	139.0629	139.21	2178730.0
2012-05-03 17:00:00	SPY	ETF	139.25	139.25	139.13	139.15	60793.0
2012-05-03 17:30:00	SPY	ETF	139.18	139.24	139.18	139.22	146616.0
2012-05-03 18:00:00	SPY	ETF	139.22	139.28	139.1	139.17	174943.0
2012-05-03 18:30:00	SPY	ETF	139.16	139.2	139.16	139.18	5350.0
2012-05-03 19:00:00	SPY	ETF	139.19	139.28	139.19	139.28	35932.0
2012-05-03 19:30:00	SPY	ETF	139.27	139.28	139.17	139.19	28760.0
2012-05-03 06:30:00	QQQ	ETF	67.25	67.25	67.25	67.25	100.0
2012-05-03 07:00:00	QQQ	ETF	67.19	67.19	67.16	67.16	500.0
2012-05-03 07:30:00	QQQ	ETF	67.16	67.2	67.15	67.19	11400.0
2012-05-03 08:00:00	QQQ	ETF	67.18	67.19	67.08	67.12	93880.0
2012-05-03 08:30:00	QQQ	ETF	67.11	67.27	67.09	67.12	306899.0
2012-05-03 09:00:00	QQQ	ETF	67.14	67.16	67.06	67.09	280596.0
2012-05-03 09:30:00	QQQ	ETF	67.1	67.15	66.92	67.011	3963848.0
2012-05-03 10:00:00	QQQ	ETF	67.01	67.015	66.78	66.89	4200554.0
2012-05-03 10:30:00	QQQ	ETF	66.89	67.01	66.83	67.0	1932698.0
2012-05-03 11:00:00	QQQ	ETF	67.0	67.01	66.89	66.92	1748768.0
2012-05-03 11:30:00	QQQ	ETF	66.91	66.945	66.58	66.6023	3951923.0
2012-05-03 12:00:00	QQQ	ETF	66.61	66.62	66.45	66.54	2321044.0
2012-05-03 12:30:00	QQQ	ETF	66.54	66.6603	66.5	66.552	1975789.0
2012-05-03 13:00:00	QQQ	ETF	66.5501	66.59	66.45	66.5699	1554897.0
2012-05-03 13:30:00	QQQ	ETF	66.57	66.57	66.22	66.265	3692089.0
2012-05-03 14:00:00	QQQ	ETF	66.26	66.36	66.23	66.31	1603015.0
2012-05-03 14:30:00	QQQ	ETF	66.31	66.53	66.175	66.26	1665559.0
2012-05-03 15:00:00	QQQ	ETF	66.27	66.491	66.21	66.42	3562154.0

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

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