PREVIEW / etf_30min / 2013-12-19

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-12-19.parquet
  size:    334 KB
  rows:    11,434

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-19 04:00:00	SPY	ETF	181.54	181.54	181.42	181.44	101210.0
2013-12-19 04:30:00	SPY	ETF	181.44	181.52	181.44	181.47	35923.0
2013-12-19 05:00:00	SPY	ETF	181.48	181.48	181.33	181.34	39617.0
2013-12-19 05:30:00	SPY	ETF	181.34	181.49	181.34	181.46	51672.0
2013-12-19 06:00:00	SPY	ETF	181.44	181.52	181.4	181.51	32296.0
2013-12-19 06:30:00	SPY	ETF	181.52	181.65	181.48	181.5	110438.0
2013-12-19 07:00:00	SPY	ETF	181.52	181.62	181.47	181.61	118001.0
2013-12-19 07:30:00	SPY	ETF	181.62	181.68	181.42	181.43	259927.0
2013-12-19 08:00:00	SPY	ETF	181.45	181.5607	181.39	181.48	836501.0
2013-12-19 08:30:00	SPY	ETF	181.42	181.52	180.75	180.77	2377664.0
2013-12-19 09:00:00	SPY	ETF	180.77	181.21	180.72	181.2	1777479.0
2013-12-19 09:30:00	SPY	ETF	181.19	181.42	181.01	181.16	18486399.0
2013-12-19 10:00:00	SPY	ETF	181.16	181.28	180.71	181.05	14742738.0
2013-12-19 10:30:00	SPY	ETF	181.06	181.34	181.01	181.22	8214031.0
2013-12-19 11:00:00	SPY	ETF	181.22	181.26	181.065	181.24	5442111.0
2013-12-19 11:30:00	SPY	ETF	181.24	181.44	181.22	181.37	10771045.0
2013-12-19 12:00:00	SPY	ETF	181.38	181.51	181.22	181.44	5297224.0
2013-12-19 12:30:00	SPY	ETF	181.44	181.48	181.35	181.42	5933038.0
2013-12-19 13:00:00	SPY	ETF	181.42	181.62	181.31	181.57	4801410.0
2013-12-19 13:30:00	SPY	ETF	181.57	181.63	181.45	181.54	4058593.0
2013-12-19 14:00:00	SPY	ETF	181.54	181.6	181.32	181.33	5032664.0
2013-12-19 14:30:00	SPY	ETF	181.33	181.55	181.3	181.501	5734485.0
2013-12-19 15:00:00	SPY	ETF	181.5	181.66	181.46	181.47	6525760.0
2013-12-19 15:30:00	SPY	ETF	181.47	181.7	181.36	181.525	18088823.0
2013-12-19 16:00:00	SPY	ETF	181.51	181.7571	181.38	181.41	9904324.0
2013-12-19 16:30:00	SPY	ETF	181.42	181.43	181.36	181.37	4339743.0
2013-12-19 17:00:00	SPY	ETF	181.38	181.6	181.38	181.6	369747.0
2013-12-19 17:30:00	SPY	ETF	181.61	181.75	181.55	181.62	231604.0
2013-12-19 18:00:00	SPY	ETF	181.59	181.67	181.55	181.59	65675.0
2013-12-19 18:30:00	SPY	ETF	181.59	181.61	181.56	181.58	5660.0
2013-12-19 19:00:00	SPY	ETF	181.56	181.57	181.56	181.56	750.0
2013-12-19 19:30:00	SPY	ETF	181.6	181.66	181.54	181.56	8980.0
2013-12-19 04:00:00	QQQ	ETF	86.13	86.15	86.13	86.13	2600.0
2013-12-19 05:00:00	QQQ	ETF	86.11	86.11	86.06	86.07	6700.0
2013-12-19 05:30:00	QQQ	ETF	86.05	86.13	86.05	86.13	2500.0
2013-12-19 06:00:00	QQQ	ETF	86.11	86.11	86.11	86.11	500.0
2013-12-19 06:30:00	QQQ	ETF	86.11	86.13	86.04	86.04	13500.0
2013-12-19 07:00:00	QQQ	ETF	86.07	86.09	86.06	86.08	3700.0
2013-12-19 07:30:00	QQQ	ETF	86.07	86.09	86.04	86.04	26100.0
2013-12-19 08:00:00	QQQ	ETF	86.05	86.08	86.01	86.02	75973.0
2013-12-19 08:30:00	QQQ	ETF	86.05	86.09	85.79	85.8	426670.0
2013-12-19 09:00:00	QQQ	ETF	85.8	86.01	85.78	86.01	360256.0
2013-12-19 09:30:00	QQQ	ETF	85.99	86.01	85.77	85.79	5202792.0
2013-12-19 10:00:00	QQQ	ETF	85.79	85.85	85.52	85.79	5165949.0
2013-12-19 10:30:00	QQQ	ETF	85.79	85.93	85.72	85.84	3787277.0
2013-12-19 11:00:00	QQQ	ETF	85.84	85.8799	85.78	85.86	1868296.0
2013-12-19 11:30:00	QQQ	ETF	85.86	85.94	85.8301	85.8699	2388737.0
2013-12-19 12:00:00	QQQ	ETF	85.87	85.89	85.79	85.85	2982078.0
2013-12-19 12:30:00	QQQ	ETF	85.85	85.89	85.8	85.85	1750372.0
2013-12-19 13:00:00	QQQ	ETF	85.86	85.925	85.8001	85.881	1796675.0

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

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