PREVIEW / etf_30min / 2016-02-01

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-02-01.parquet
  size:    403 KB
  rows:    13,678

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
2016-02-01 04:00:00	SPY	ETF	193.32	193.33	192.64	192.8	23195.0
2016-02-01 04:30:00	SPY	ETF	192.89	192.96	192.37	192.39	31434.0
2016-02-01 05:00:00	SPY	ETF	192.46	192.66	192.39	192.61	31680.0
2016-02-01 05:30:00	SPY	ETF	192.7	192.75	192.6	192.74	20620.0
2016-02-01 06:00:00	SPY	ETF	192.83	193.08	192.69	192.96	29505.0
2016-02-01 06:30:00	SPY	ETF	192.96	192.96	192.65	192.77	44417.0
2016-02-01 07:00:00	SPY	ETF	192.74	192.8	192.27	192.35	284316.0
2016-02-01 07:30:00	SPY	ETF	192.37	192.43	191.99	192.24	554269.0
2016-02-01 08:00:00	SPY	ETF	192.26	192.8	192.07	192.13	993740.0
2016-02-01 08:30:00	SPY	ETF	192.13	193.87	192.04	192.37	1011382.0
2016-02-01 09:00:00	SPY	ETF	192.36	193.87	192.27	192.53	1097903.0
2016-02-01 09:30:00	SPY	ETF	192.53	192.84	192.135	192.4	14280179.0
2016-02-01 10:00:00	SPY	ETF	192.4	192.88	191.84	192.45	12196472.0
2016-02-01 10:30:00	SPY	ETF	192.45	193.21	192.33	193.07	6397719.0
2016-02-01 11:00:00	SPY	ETF	193.07	193.2	192.67	193.1	8070739.0
2016-02-01 11:30:00	SPY	ETF	193.11	193.46	192.97	193.2	6773413.0
2016-02-01 12:00:00	SPY	ETF	193.205	193.32	192.6	192.655	7422124.0
2016-02-01 12:30:00	SPY	ETF	192.68	192.85	192.46	192.55	5836016.0
2016-02-01 13:00:00	SPY	ETF	192.56	193.17	192.49	193.12	6483419.0
2016-02-01 13:30:00	SPY	ETF	193.13	193.24	192.85	193.22	4238576.0
2016-02-01 14:00:00	SPY	ETF	193.22	193.445	192.86	193.4334	5376035.0
2016-02-01 14:30:00	SPY	ETF	193.43	193.92	192.9399	193.82	7417004.0
2016-02-01 15:00:00	SPY	ETF	193.82	194.55	193.56	194.5	13681515.0
2016-02-01 15:30:00	SPY	ETF	194.5	194.58	192.7743	193.69	17873108.0
2016-02-01 16:00:00	SPY	ETF	193.71	194.21	193.0482	193.65	11263551.0
2016-02-01 16:30:00	SPY	ETF	193.63	193.78	193.41	193.44	2068199.0
2016-02-01 17:00:00	SPY	ETF	193.44	193.49	193.39	193.48	106630.0
2016-02-01 17:30:00	SPY	ETF	193.5	193.52	193.4	193.42	40442.0
2016-02-01 18:00:00	SPY	ETF	193.43	193.65	193.16	193.25	132976.0
2016-02-01 18:30:00	SPY	ETF	193.21	193.31	192.95	193.01	44255.0
2016-02-01 19:00:00	SPY	ETF	193.01	193.11	192.92	192.99	36857.0
2016-02-01 19:30:00	SPY	ETF	193.06	193.06	192.98	192.98	50494.0
2016-02-01 04:00:00	QQQ	ETF	103.94	103.94	103.61	103.67	1730.0
2016-02-01 04:30:00	QQQ	ETF	103.58	103.58	103.56	103.56	300.0
2016-02-01 05:00:00	QQQ	ETF	103.52	103.55	103.45	103.49	7780.0
2016-02-01 05:30:00	QQQ	ETF	103.62	103.63	103.62	103.63	200.0
2016-02-01 06:00:00	QQQ	ETF	103.62	103.77	103.62	103.77	891.0
2016-02-01 06:30:00	QQQ	ETF	103.74	103.74	103.58	103.6	1600.0
2016-02-01 07:00:00	QQQ	ETF	103.62	103.65	103.4	103.51	23590.0
2016-02-01 07:30:00	QQQ	ETF	103.5	103.5	103.29	103.45	17944.0
2016-02-01 08:00:00	QQQ	ETF	103.45	103.57	103.43	103.44	39445.0
2016-02-01 08:30:00	QQQ	ETF	103.44	103.67	103.4	103.55	125206.0
2016-02-01 09:00:00	QQQ	ETF	103.62	103.68	103.5	103.61	239100.0
2016-02-01 09:30:00	QQQ	ETF	103.62	103.93	103.36	103.59	3709080.0
2016-02-01 10:00:00	QQQ	ETF	103.57	103.8678	103.23	103.59	2906756.0
2016-02-01 10:30:00	QQQ	ETF	103.59	104.19	103.52	104.1	1861696.0
2016-02-01 11:00:00	QQQ	ETF	104.1	104.15	103.815	104.04	1559065.0
2016-02-01 11:30:00	QQQ	ETF	104.05	104.22	103.941	104.03	1469493.0
2016-02-01 12:00:00	QQQ	ETF	104.04	104.1	103.75	103.79	1188804.0
2016-02-01 12:30:00	QQQ	ETF	103.79	103.85	103.61	103.695	664132.0

> showing 50 of 13,678 rows — these rows as CSV

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