PREVIEW / etf_30min / 2014-12-19

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-19.parquet
  size:    379 KB
  rows:    12,802

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-12-19 04:00:00	SPY	ETF	206.69	206.87	206.49	206.87	21944.0
2014-12-19 04:30:00	SPY	ETF	206.91	206.91	206.74	206.85	18202.0
2014-12-19 05:00:00	SPY	ETF	206.9	206.9	206.67	206.67	25050.0
2014-12-19 05:30:00	SPY	ETF	206.77	206.77	206.42	206.56	114135.0
2014-12-19 06:00:00	SPY	ETF	206.58	206.72	206.51	206.55	42650.0
2014-12-19 06:30:00	SPY	ETF	206.56	206.6	206.25	206.52	61274.0
2014-12-19 07:00:00	SPY	ETF	206.48	206.74	206.41	206.57	194415.0
2014-12-19 07:30:00	SPY	ETF	206.6	206.79	206.55	206.69	192628.0
2014-12-19 08:00:00	SPY	ETF	206.91	206.91	206.52	206.68	531616.0
2014-12-19 08:30:00	SPY	ETF	206.65	206.65	205.91	206.13	3162215.0
2014-12-19 09:00:00	SPY	ETF	206.12	206.65	206.05	206.43	5822100.0
2014-12-19 09:30:00	SPY	ETF	206.43	206.58	205.62	206.23	31520213.0
2014-12-19 10:00:00	SPY	ETF	206.23	206.65	206.02	206.49	17922074.0
2014-12-19 10:30:00	SPY	ETF	206.475	206.5	205.95	206.31	11148722.0
2014-12-19 11:00:00	SPY	ETF	206.3	206.4346	206.05	206.31	17584570.0
2014-12-19 11:30:00	SPY	ETF	206.31	206.3458	206.1	206.11	11957161.0
2014-12-19 12:00:00	SPY	ETF	206.11	206.11	205.7	205.82	10152038.0
2014-12-19 12:30:00	SPY	ETF	205.82	206.18	205.73	205.96	8638455.0
2014-12-19 13:00:00	SPY	ETF	205.95	206.18	205.86	206.13	7524826.0
2014-12-19 13:30:00	SPY	ETF	206.135	206.26	206.07	206.23	4551478.0
2014-12-19 14:00:00	SPY	ETF	206.225	206.56	206.17	206.42	6319080.0
2014-12-19 14:30:00	SPY	ETF	206.415	207.16	206.38	207.13	16040295.0
2014-12-19 15:00:00	SPY	ETF	207.13	207.15	206.66	207.15	16847336.0
2014-12-19 15:30:00	SPY	ETF	207.15	207.33	206.52	206.53	33724459.0
2014-12-19 16:00:00	SPY	ETF	206.54	206.59	205.6327	206.45	15991180.0
2014-12-19 16:30:00	SPY	ETF	206.46	206.576	206.29	206.39	2110507.0
2014-12-19 17:00:00	SPY	ETF	206.576	206.576	206.3	206.44	9931095.0
2014-12-19 17:30:00	SPY	ETF	206.43	206.43	206.31	206.31	1842349.0
2014-12-19 18:00:00	SPY	ETF	206.32	206.36	206.2	206.3	70250.0
2014-12-19 18:30:00	SPY	ETF	206.31	206.43	206.3	206.38	36146.0
2014-12-19 19:00:00	SPY	ETF	206.39	206.4	206.37	206.38	6133.0
2014-12-19 19:30:00	SPY	ETF	206.4	206.43	206.35	206.42	21142.0
2014-12-19 04:00:00	QQQ	ETF	104.33	104.55	104.33	104.55	802.0
2014-12-19 04:30:00	QQQ	ETF	104.5	104.55	104.5	104.55	6600.0
2014-12-19 05:00:00	QQQ	ETF	104.45	104.45	104.45	104.45	300.0
2014-12-19 05:30:00	QQQ	ETF	104.45	104.45	104.29	104.29	3800.0
2014-12-19 06:00:00	QQQ	ETF	104.37	104.37	104.32	104.36	114250.0
2014-12-19 06:30:00	QQQ	ETF	104.32	104.36	104.2	104.33	35200.0
2014-12-19 07:00:00	QQQ	ETF	104.28	104.36	104.27	104.33	35400.0
2014-12-19 07:30:00	QQQ	ETF	104.32	104.35	104.31	104.34	8700.0
2014-12-19 08:00:00	QQQ	ETF	104.36	104.38	104.26	104.35	59587.0
2014-12-19 08:30:00	QQQ	ETF	104.34	104.36	104.07	104.13	154402.0
2014-12-19 09:00:00	QQQ	ETF	104.1	104.23	103.86	103.97	1402418.0
2014-12-19 09:30:00	QQQ	ETF	103.97	104.11	103.71	104.1099	8507675.0
2014-12-19 10:00:00	QQQ	ETF	104.11	104.415	103.99	104.35	4366221.0
2014-12-19 10:30:00	QQQ	ETF	104.345	104.37	104.011	104.33	2593011.0
2014-12-19 11:00:00	QQQ	ETF	104.32	104.48	104.22	104.42	2087748.0
2014-12-19 11:30:00	QQQ	ETF	104.42	104.44	104.24	104.25	2304879.0
2014-12-19 12:00:00	QQQ	ETF	104.25	104.26	104.01	104.12	2096237.0
2014-12-19 12:30:00	QQQ	ETF	104.1	104.33	104.06	104.21	2076451.0

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

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