PREVIEW / etf_30min / 2013-07-30

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-30.parquet
  size:    307 KB
  rows:    10,547

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-07-30 04:00:00	SPY	ETF	169.1	169.1	169.05	169.1	24200.0
2013-07-30 04:30:00	SPY	ETF	169.06	169.06	168.73	168.84	21800.0
2013-07-30 05:00:00	SPY	ETF	168.81	168.92	168.78	168.9	2500.0
2013-07-30 05:30:00	SPY	ETF	168.87	168.91	168.7	168.7	11900.0
2013-07-30 06:00:00	SPY	ETF	168.75	168.84	168.75	168.84	9300.0
2013-07-30 06:30:00	SPY	ETF	168.83	169.11	168.83	169.11	89579.0
2013-07-30 07:00:00	SPY	ETF	169.1	169.15	169.08	169.13	115800.0
2013-07-30 07:30:00	SPY	ETF	169.09	169.15	168.97	169.09	71577.0
2013-07-30 08:00:00	SPY	ETF	169.08	169.12	169.01	169.08	86317.0
2013-07-30 08:30:00	SPY	ETF	169.09	169.23	169.09	169.2	467047.0
2013-07-30 09:00:00	SPY	ETF	169.21	169.23	169.09	169.09	370309.0
2013-07-30 09:30:00	SPY	ETF	169.1	169.28	168.84	169.0	8747083.0
2013-07-30 10:00:00	SPY	ETF	168.98	169.19	168.95	169.1	7825251.0
2013-07-30 10:30:00	SPY	ETF	169.1	169.19	168.78	168.83	5468402.0
2013-07-30 11:00:00	SPY	ETF	168.83	168.98	168.75	168.92	4743980.0
2013-07-30 11:30:00	SPY	ETF	168.92	169.07	168.89	168.9572	3885887.0
2013-07-30 12:00:00	SPY	ETF	168.96	168.98	168.72	168.8	3800446.0
2013-07-30 12:30:00	SPY	ETF	168.8	168.93	168.73	168.83	2901528.0
2013-07-30 13:00:00	SPY	ETF	168.8349	168.855	168.34	168.38	4437884.0
2013-07-30 13:30:00	SPY	ETF	168.381	168.425	168.19	168.38	6890465.0
2013-07-30 14:00:00	SPY	ETF	168.38	168.48	168.28	168.44	4229822.0
2013-07-30 14:30:00	SPY	ETF	168.431	168.59	168.43	168.49	4399522.0
2013-07-30 15:00:00	SPY	ETF	168.48	168.81	168.4	168.785	6400223.0
2013-07-30 15:30:00	SPY	ETF	168.78	168.89	168.58	168.58	12695801.0
2013-07-30 16:00:00	SPY	ETF	168.58	168.92	168.24	168.83	3797805.0
2013-07-30 16:30:00	SPY	ETF	168.84	168.89	168.4992	168.88	2903377.0
2013-07-30 17:00:00	SPY	ETF	168.88	168.89	168.8	168.82	71894.0
2013-07-30 17:30:00	SPY	ETF	168.83	168.84	168.81	168.83	25912.0
2013-07-30 18:00:00	SPY	ETF	168.83	168.89	168.78	168.89	43431.0
2013-07-30 18:30:00	SPY	ETF	168.86	168.89	168.86	168.88	13339.0
2013-07-30 19:00:00	SPY	ETF	168.86	168.88	168.86	168.86	4586.0
2013-07-30 19:30:00	SPY	ETF	168.86	168.89	168.85	168.87	31030.0
2013-07-30 04:00:00	QQQ	ETF	75.51	75.52	75.48	75.5	11400.0
2013-07-30 04:30:00	QQQ	ETF	75.48	75.48	75.36	75.38	8000.0
2013-07-30 05:00:00	QQQ	ETF	75.38	75.4	75.36	75.4	3100.0
2013-07-30 05:30:00	QQQ	ETF	75.38	75.38	75.34	75.35	3600.0
2013-07-30 06:00:00	QQQ	ETF	75.36	75.44	75.36	75.44	4800.0
2013-07-30 06:30:00	QQQ	ETF	75.44	75.52	75.44	75.51	4980.0
2013-07-30 07:00:00	QQQ	ETF	75.51	75.51	75.5	75.5	2100.0
2013-07-30 07:30:00	QQQ	ETF	75.51	75.51	75.46	75.48	3600.0
2013-07-30 08:00:00	QQQ	ETF	75.48	75.51	75.48	75.51	44865.0
2013-07-30 08:30:00	QQQ	ETF	75.51	75.56	75.5	75.56	49537.0
2013-07-30 09:00:00	QQQ	ETF	75.55	75.57	75.51	75.51	124216.0
2013-07-30 09:30:00	QQQ	ETF	75.5	75.53	75.41	75.43	1891264.0
2013-07-30 10:00:00	QQQ	ETF	75.4299	75.69	75.415	75.67	2344696.0
2013-07-30 10:30:00	QQQ	ETF	75.67	75.72	75.59	75.61	1366855.0
2013-07-30 11:00:00	QQQ	ETF	75.61	75.77	75.56	75.7499	1264855.0
2013-07-30 11:30:00	QQQ	ETF	75.74	75.95	75.74	75.899	2702477.0
2013-07-30 12:00:00	QQQ	ETF	75.9	75.91	75.73	75.779	1453827.0
2013-07-30 12:30:00	QQQ	ETF	75.78	75.87	75.75	75.7993	1049107.0

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

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