PREVIEW / etf_30min / 2014-10-08

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-10-08.parquet
  size:    370 KB
  rows:    12,288

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
2014-10-08 04:00:00	SPY	ETF	193.5	193.69	193.5	193.5	1003.0
2014-10-08 04:30:00	SPY	ETF	193.51	193.51	193.26	193.26	3460.0
2014-10-08 05:00:00	SPY	ETF	193.21	193.35	193.15	193.35	2667.0
2014-10-08 05:30:00	SPY	ETF	193.33	193.35	193.23	193.23	11225.0
2014-10-08 06:00:00	SPY	ETF	193.29	193.4	193.29	193.4	10390.0
2014-10-08 06:30:00	SPY	ETF	193.37	193.66	193.36	193.63	99483.0
2014-10-08 07:00:00	SPY	ETF	193.7	193.87	193.62	193.77	74306.0
2014-10-08 07:30:00	SPY	ETF	193.8	193.93	193.76	193.77	240080.0
2014-10-08 08:00:00	SPY	ETF	193.85	193.88	193.59	193.7	458697.0
2014-10-08 08:30:00	SPY	ETF	193.7	193.74	193.35	193.43	400954.0
2014-10-08 09:00:00	SPY	ETF	193.44	193.53	193.28	193.38	1090004.0
2014-10-08 09:30:00	SPY	ETF	193.37	193.92	193.13	193.22	17907321.0
2014-10-08 10:00:00	SPY	ETF	193.21	193.73	192.96	193.38	15057972.0
2014-10-08 10:30:00	SPY	ETF	193.39	193.56	192.54	192.582	11324884.0
2014-10-08 11:00:00	SPY	ETF	192.58	193.46	192.36	193.38	12007417.0
2014-10-08 11:30:00	SPY	ETF	193.37	193.56	193.07	193.49	9222727.0
2014-10-08 12:00:00	SPY	ETF	193.5	193.77	193.4	193.4199	5670855.0
2014-10-08 12:30:00	SPY	ETF	193.42	193.59	193.24	193.42	4240076.0
2014-10-08 13:00:00	SPY	ETF	193.43	193.79	193.4	193.56	3920880.0
2014-10-08 13:30:00	SPY	ETF	193.565	194.29	193.55	194.2123	7098443.0
2014-10-08 14:00:00	SPY	ETF	194.22	195.75	194.18	195.6	23433895.0
2014-10-08 14:30:00	SPY	ETF	195.6	196.07	195.37	195.62	18924378.0
2014-10-08 15:00:00	SPY	ETF	195.62	196.53	195.61	196.42	13607730.0
2014-10-08 15:30:00	SPY	ETF	196.43	196.92	196.295	196.64	26394411.0
2014-10-08 16:00:00	SPY	ETF	196.65	196.88	196.56	196.7	8897955.0
2014-10-08 16:30:00	SPY	ETF	196.7	196.82	196.6	196.82	3525252.0
2014-10-08 17:00:00	SPY	ETF	196.8	196.8	196.65	196.67	162420.0
2014-10-08 17:30:00	SPY	ETF	196.67	196.71	196.65	196.65	47428.0
2014-10-08 18:00:00	SPY	ETF	196.69	196.69	196.54	196.6	155449.0
2014-10-08 18:30:00	SPY	ETF	196.59	196.65	196.57	196.65	75783.0
2014-10-08 19:00:00	SPY	ETF	196.63	196.67	196.6	196.67	49086.0
2014-10-08 19:30:00	SPY	ETF	196.64	196.65	196.51	196.51	104768.0
2014-10-08 04:00:00	QQQ	ETF	96.61	96.61	96.61	96.61	200.0
2014-10-08 05:30:00	QQQ	ETF	96.63	96.63	96.54	96.54	1700.0
2014-10-08 06:00:00	QQQ	ETF	96.61	96.66	96.61	96.66	3100.0
2014-10-08 06:30:00	QQQ	ETF	96.66	96.84	96.63	96.84	33730.0
2014-10-08 07:00:00	QQQ	ETF	96.84	96.9	96.78	96.88	7269.0
2014-10-08 07:30:00	QQQ	ETF	96.85	98.5736	96.85	96.87	65510.0
2014-10-08 08:00:00	QQQ	ETF	96.86	96.9	96.75	96.8	78520.0
2014-10-08 08:30:00	QQQ	ETF	96.82	96.82	96.57	96.69	177810.0
2014-10-08 09:00:00	QQQ	ETF	96.68	96.77	96.61	96.64	313678.0
2014-10-08 09:30:00	QQQ	ETF	96.66	96.91	96.43	96.4625	6007029.0
2014-10-08 10:00:00	QQQ	ETF	96.46	96.809	96.37	96.63	4766581.0
2014-10-08 10:30:00	QQQ	ETF	96.64	96.74	96.16	96.19	3915733.0
2014-10-08 11:00:00	QQQ	ETF	96.19	96.7	96.06	96.665	3939695.0
2014-10-08 11:30:00	QQQ	ETF	96.65	96.83	96.555	96.8	2953677.0
2014-10-08 12:00:00	QQQ	ETF	96.8	96.93	96.721	96.78	1910272.0
2014-10-08 12:30:00	QQQ	ETF	96.775	96.91	96.7	96.82	1818532.0
2014-10-08 13:00:00	QQQ	ETF	96.83	97.0	96.781	96.841	1543429.0
2014-10-08 13:30:00	QQQ	ETF	96.85	97.24	96.83	97.22	2692836.0

> showing 50 of 12,288 rows — these rows as CSV

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