PREVIEW / etf_30min / 2016-06-23

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-23.parquet
  size:    400 KB
  rows:    13,745

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-06-23 04:00:00	SPY	ETF	209.06	209.23	209.05	209.2	1523.0
2016-06-23 04:30:00	SPY	ETF	209.21	209.37	209.21	209.33	8659.0
2016-06-23 05:00:00	SPY	ETF	209.35	210.55	209.35	210.19	118454.0
2016-06-23 05:30:00	SPY	ETF	210.24	210.36	209.93	210.07	21683.0
2016-06-23 06:00:00	SPY	ETF	210.11	210.28	210.0	210.13	42320.0
2016-06-23 06:30:00	SPY	ETF	210.13	210.36	210.02	210.02	30257.0
2016-06-23 07:00:00	SPY	ETF	210.08	210.17	209.92	209.96	450272.0
2016-06-23 07:30:00	SPY	ETF	209.94	209.97	209.73	209.73	200115.0
2016-06-23 08:00:00	SPY	ETF	209.74	210.13	209.74	210.0	435259.0
2016-06-23 08:30:00	SPY	ETF	210.0	210.05	209.8	210.04	392039.0
2016-06-23 09:00:00	SPY	ETF	210.05	210.06	209.65	209.81	1047150.0
2016-06-23 09:30:00	SPY	ETF	209.81	209.9611	209.27	209.585	9041962.0
2016-06-23 10:00:00	SPY	ETF	209.585	209.93	209.49	209.68	6856992.0
2016-06-23 10:30:00	SPY	ETF	209.675	209.89	209.38	209.75	5148349.0
2016-06-23 11:00:00	SPY	ETF	209.75	210.19	209.74	210.16	7619407.0
2016-06-23 11:30:00	SPY	ETF	210.16	210.28	210.05	210.18	6679507.0
2016-06-23 12:00:00	SPY	ETF	210.19	210.31	210.09	210.11	3820384.0
2016-06-23 12:30:00	SPY	ETF	210.12	210.16	209.87	210.03	3670814.0
2016-06-23 13:00:00	SPY	ETF	210.02	210.16	209.9	210.04	3771206.0
2016-06-23 13:30:00	SPY	ETF	210.04	210.1	209.8	209.935	5774188.0
2016-06-23 14:00:00	SPY	ETF	209.94	210.07	209.8	209.995	3523634.0
2016-06-23 14:30:00	SPY	ETF	209.99	210.26	209.95	210.17	3911602.0
2016-06-23 15:00:00	SPY	ETF	210.17	210.2	209.96	210.015	5351725.0
2016-06-23 15:30:00	SPY	ETF	210.01	210.85	209.98	210.83	18575331.0
2016-06-23 16:00:00	SPY	ETF	210.82	211.07	209.3694	211.04	8364157.0
2016-06-23 16:30:00	SPY	ETF	211.03	211.64	210.87	211.63	1044125.0
2016-06-23 17:00:00	SPY	ETF	211.63	211.85	211.39	211.72	597835.0
2016-06-23 17:30:00	SPY	ETF	211.72	212.0	211.62	212.0	439369.0
2016-06-23 18:00:00	SPY	ETF	211.99	212.25	210.81	212.02	755952.0
2016-06-23 18:30:00	SPY	ETF	212.05	212.22	211.3	211.35	420117.0
2016-06-23 19:00:00	SPY	ETF	211.35	211.35	209.21	210.26	930449.0
2016-06-23 19:30:00	SPY	ETF	210.29	211.04	209.59	210.11	642888.0
2016-06-23 04:00:00	QQQ	ETF	107.71	107.78	107.71	107.78	2400.0
2016-06-23 04:30:00	QQQ	ETF	107.88	107.88	107.88	107.88	200.0
2016-06-23 05:00:00	QQQ	ETF	108.05	108.62	108.05	108.53	3009.0
2016-06-23 05:30:00	QQQ	ETF	108.3	108.3	108.3	108.3	200.0
2016-06-23 06:00:00	QQQ	ETF	108.46	108.51	108.41	108.41	647.0
2016-06-23 06:30:00	QQQ	ETF	108.4	108.4	108.26	108.3	6398.0
2016-06-23 07:00:00	QQQ	ETF	108.28	108.37	108.25	108.27	37861.0
2016-06-23 07:30:00	QQQ	ETF	108.25	108.28	108.12	108.12	120053.0
2016-06-23 08:00:00	QQQ	ETF	108.13	108.25	108.13	108.23	26624.0
2016-06-23 08:30:00	QQQ	ETF	108.19	108.28	108.13	108.28	84263.0
2016-06-23 09:00:00	QQQ	ETF	108.29	108.29	108.05	108.09	388387.0
2016-06-23 09:30:00	QQQ	ETF	108.09	108.12	107.62	107.8799	2372515.0
2016-06-23 10:00:00	QQQ	ETF	107.88	108.12	107.83	108.04	1424667.0
2016-06-23 10:30:00	QQQ	ETF	108.05	108.25	107.85	108.19	1082388.0
2016-06-23 11:00:00	QQQ	ETF	108.19	108.39	108.19	108.325	1126702.0
2016-06-23 11:30:00	QQQ	ETF	108.33	108.4299	108.28	108.37	1104341.0
2016-06-23 12:00:00	QQQ	ETF	108.375	108.47	108.35	108.37	506449.0
2016-06-23 12:30:00	QQQ	ETF	108.37	108.4	108.24	108.33	830269.0

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

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