PREVIEW / etf_30min / 2016-10-12

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-10-12.parquet
  size:    393 KB
  rows:    13,473

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-10-12 04:00:00	SPY	ETF	213.67	213.69	213.43	213.69	47292.0
2016-10-12 04:30:00	SPY	ETF	213.71	213.71	213.53	213.64	5074.0
2016-10-12 05:00:00	SPY	ETF	213.71	213.71	213.66	213.69	1724.0
2016-10-12 05:30:00	SPY	ETF	213.66	213.66	213.51	213.54	5540.0
2016-10-12 06:00:00	SPY	ETF	213.52	213.59	213.49	213.52	28385.0
2016-10-12 06:30:00	SPY	ETF	213.54	213.7	213.52	213.63	23622.0
2016-10-12 07:00:00	SPY	ETF	213.7	213.8	213.66	213.76	37328.0
2016-10-12 07:30:00	SPY	ETF	213.79	213.79	213.48	213.5	45722.0
2016-10-12 08:00:00	SPY	ETF	213.57	213.79	213.23	213.27	394445.0
2016-10-12 08:30:00	SPY	ETF	213.26	213.5	213.13	213.5	536970.0
2016-10-12 09:00:00	SPY	ETF	213.48	213.61	213.27	213.58	395263.0
2016-10-12 09:30:00	SPY	ETF	213.59	213.71	213.01	213.65	10267009.0
2016-10-12 10:00:00	SPY	ETF	213.645	214.06	213.51	213.9	8497710.0
2016-10-12 10:30:00	SPY	ETF	213.89	213.94	213.32	213.41	4659379.0
2016-10-12 11:00:00	SPY	ETF	213.41	213.61	213.33	213.5249	3402362.0
2016-10-12 11:30:00	SPY	ETF	213.51	213.81	213.49	213.63	2531282.0
2016-10-12 12:00:00	SPY	ETF	213.64	214.0	213.63	213.915	2823721.0
2016-10-12 12:30:00	SPY	ETF	213.915	214.1	213.85	213.95	2605830.0
2016-10-12 13:00:00	SPY	ETF	213.955	213.98	213.76	213.95	2453357.0
2016-10-12 13:30:00	SPY	ETF	213.955	214.03	213.77	214.015	1906846.0
2016-10-12 14:00:00	SPY	ETF	214.005	214.32	213.67	213.93	8326422.0
2016-10-12 14:30:00	SPY	ETF	213.92	214.07	213.8	213.805	2904644.0
2016-10-12 15:00:00	SPY	ETF	213.8	214.0	213.67	213.74	3881579.0
2016-10-12 15:30:00	SPY	ETF	213.745	213.93	213.5	213.72	10922869.0
2016-10-12 16:00:00	SPY	ETF	213.71	213.8998	213.46	213.5	4633295.0
2016-10-12 16:30:00	SPY	ETF	213.5	213.7176	213.16	213.17	663024.0
2016-10-12 17:00:00	SPY	ETF	213.2	213.26	213.18	213.26	118812.0
2016-10-12 17:30:00	SPY	ETF	213.25	213.71	213.11	213.15	133704.0
2016-10-12 18:00:00	SPY	ETF	213.17	213.22	213.11	213.12	226206.0
2016-10-12 18:30:00	SPY	ETF	213.11	213.28	213.11	213.27	139640.0
2016-10-12 19:00:00	SPY	ETF	213.26	213.3	213.26	213.28	14906.0
2016-10-12 19:30:00	SPY	ETF	213.28	213.41	213.28	213.32	52890.0
2016-10-12 04:00:00	QQQ	ETF	117.43	117.52	117.43	117.52	9653.0
2016-10-12 05:30:00	QQQ	ETF	117.47	117.47	117.47	117.47	7000.0
2016-10-12 06:00:00	QQQ	ETF	117.45	117.46	117.45	117.46	5100.0
2016-10-12 06:30:00	QQQ	ETF	117.5	117.52	117.5	117.52	5100.0
2016-10-12 07:00:00	QQQ	ETF	117.58	117.6	117.57	117.6	7897.0
2016-10-12 07:30:00	QQQ	ETF	117.59	117.59	117.52	117.52	6772.0
2016-10-12 08:00:00	QQQ	ETF	117.49	117.52	117.32	117.32	47119.0
2016-10-12 08:30:00	QQQ	ETF	117.32	117.51	117.25	117.49	82348.0
2016-10-12 09:00:00	QQQ	ETF	117.48	117.58	117.38	117.57	61145.0
2016-10-12 09:30:00	QQQ	ETF	117.575	117.63	117.06	117.44	2669986.0
2016-10-12 10:00:00	QQQ	ETF	117.444	117.59	117.31	117.54	1638620.0
2016-10-12 10:30:00	QQQ	ETF	117.54	117.5654	117.21	117.245	745203.0
2016-10-12 11:00:00	QQQ	ETF	117.25	117.41	117.23	117.4	645897.0
2016-10-12 11:30:00	QQQ	ETF	117.4	117.59	117.39	117.49	416069.0
2016-10-12 12:00:00	QQQ	ETF	117.5	117.59	117.44	117.55	509445.0
2016-10-12 12:30:00	QQQ	ETF	117.5407	117.65	117.5	117.57	456094.0
2016-10-12 13:00:00	QQQ	ETF	117.57	117.62	117.47	117.62	312074.0
2016-10-12 13:30:00	QQQ	ETF	117.63	117.68	117.5364	117.65	280534.0

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

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