PREVIEW / etf_30min / 2013-08-27

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-08-27.parquet
  size:    345 KB
  rows:    11,408

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-08-27 04:00:00	SPY	ETF	165.56	165.56	164.93	165.14	75520.0
2013-08-27 04:30:00	SPY	ETF	165.11	165.25	165.08	165.1	8665.0
2013-08-27 05:00:00	SPY	ETF	165.1	165.16	165.05	165.07	76425.0
2013-08-27 05:30:00	SPY	ETF	165.05	165.22	165.04	165.2	135400.0
2013-08-27 06:00:00	SPY	ETF	165.22	165.23	165.08	165.08	31850.0
2013-08-27 06:30:00	SPY	ETF	165.06	165.06	164.72	164.8	154448.0
2013-08-27 07:00:00	SPY	ETF	164.81	164.93	164.72	164.93	342792.0
2013-08-27 07:30:00	SPY	ETF	164.93	165.12	164.78	165.02	406170.0
2013-08-27 08:00:00	SPY	ETF	165.02	165.68	164.57	164.57	791397.0
2013-08-27 08:30:00	SPY	ETF	164.57	165.97	164.14	164.37	1742644.0
2013-08-27 09:00:00	SPY	ETF	164.36	164.43	164.2	164.36	1309151.0
2013-08-27 09:30:00	SPY	ETF	164.36	164.98	164.3	164.75	18114364.0
2013-08-27 10:00:00	SPY	ETF	164.759	164.92	164.15	164.23	12851894.0
2013-08-27 10:30:00	SPY	ETF	164.23	164.64	164.11	164.6	9540852.0
2013-08-27 11:00:00	SPY	ETF	164.59	164.745	164.34	164.67	7371461.0
2013-08-27 11:30:00	SPY	ETF	164.67	164.73	164.3101	164.4601	6251948.0
2013-08-27 12:00:00	SPY	ETF	164.461	164.47	164.07	164.19	5890472.0
2013-08-27 12:30:00	SPY	ETF	164.18	164.38	163.98	164.077	6008695.0
2013-08-27 13:00:00	SPY	ETF	164.08	164.1	163.74	163.83	7800150.0
2013-08-27 13:30:00	SPY	ETF	163.82	166.0024	163.8	163.99	7138631.0
2013-08-27 14:00:00	SPY	ETF	163.98	163.9881	163.49	163.65	9467840.0
2013-08-27 14:30:00	SPY	ETF	163.65	163.84	163.44	163.7	9483312.0
2013-08-27 15:00:00	SPY	ETF	163.71	163.9	163.31	163.46	11151539.0
2013-08-27 15:30:00	SPY	ETF	163.455	163.61	163.21	163.32	22352628.0
2013-08-27 16:00:00	SPY	ETF	163.33	163.46	163.26	163.35	10450709.0
2013-08-27 16:30:00	SPY	ETF	163.36	166.0024	163.34	163.41	5932651.0
2013-08-27 17:00:00	SPY	ETF	163.41	163.42	163.35	163.4	69924.0
2013-08-27 17:30:00	SPY	ETF	163.4	163.41	163.4	163.41	80782.0
2013-08-27 18:00:00	SPY	ETF	163.41	163.44	163.36	163.36	95660.0
2013-08-27 18:30:00	SPY	ETF	163.36	163.42	163.3	163.4	73624.0
2013-08-27 19:00:00	SPY	ETF	163.38	163.41	163.38	163.4	10118.0
2013-08-27 19:30:00	SPY	ETF	163.38	163.43	163.25	163.3	82926.0
2013-08-27 04:00:00	QQQ	ETF	76.5	76.5	76.24	76.3	38800.0
2013-08-27 04:30:00	QQQ	ETF	76.28	76.36	76.28	76.32	10200.0
2013-08-27 05:00:00	QQQ	ETF	76.3	76.3	76.24	76.28	19800.0
2013-08-27 05:30:00	QQQ	ETF	76.26	76.3	76.23	76.3	5500.0
2013-08-27 06:00:00	QQQ	ETF	76.28	76.28	76.22	76.22	6000.0
2013-08-27 06:30:00	QQQ	ETF	76.22	76.22	75.94	75.96	37889.0
2013-08-27 07:00:00	QQQ	ETF	75.96	76.08	75.94	76.08	15000.0
2013-08-27 07:30:00	QQQ	ETF	76.06	76.16	76.02	76.11	74780.0
2013-08-27 08:00:00	QQQ	ETF	76.14	76.28	75.93	75.94	180779.0
2013-08-27 08:30:00	QQQ	ETF	75.92	76.67	75.73	75.785	455491.0
2013-08-27 09:00:00	QQQ	ETF	75.79	75.87	75.74	75.82	161997.0
2013-08-27 09:30:00	QQQ	ETF	75.82	76.18	75.74	76.03	4715177.0
2013-08-27 10:00:00	QQQ	ETF	76.03	76.12	75.7	75.74	2821186.0
2013-08-27 10:30:00	QQQ	ETF	75.75	75.921	75.66	75.9	2248507.0
2013-08-27 11:00:00	QQQ	ETF	75.9	76.018	75.76	75.98	2938416.0
2013-08-27 11:30:00	QQQ	ETF	75.98	76.03	75.73	75.8001	2186148.0
2013-08-27 12:00:00	QQQ	ETF	75.809	75.809	75.55	75.5685	2600380.0
2013-08-27 12:30:00	QQQ	ETF	75.56	75.65	75.45	75.51	2538666.0

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

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