PREVIEW / etf_30min / 2016-09-14

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-09-14.parquet
  size:    394 KB
  rows:    13,324

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-09-14 04:00:00	SPY	ETF	213.67	214.0	213.55	214.0	29833.0
2016-09-14 04:30:00	SPY	ETF	213.95	214.19	213.95	214.03	18811.0
2016-09-14 05:00:00	SPY	ETF	213.95	213.95	213.5	213.65	30980.0
2016-09-14 05:30:00	SPY	ETF	213.62	213.78	213.62	213.76	13128.0
2016-09-14 06:00:00	SPY	ETF	213.73	213.78	213.65	213.78	49950.0
2016-09-14 06:30:00	SPY	ETF	213.77	213.78	213.6	213.6	19951.0
2016-09-14 07:00:00	SPY	ETF	213.62	214.07	213.62	214.0	188159.0
2016-09-14 07:30:00	SPY	ETF	214.01	214.01	213.84	213.87	82219.0
2016-09-14 08:00:00	SPY	ETF	213.89	214.03	213.66	213.88	220644.0
2016-09-14 08:30:00	SPY	ETF	213.91	213.98	213.82	213.85	160707.0
2016-09-14 09:00:00	SPY	ETF	213.87	213.87	213.08	213.3	1076007.0
2016-09-14 09:30:00	SPY	ETF	213.29	213.8	213.0	213.54	13303128.0
2016-09-14 10:00:00	SPY	ETF	213.54	214.46	213.445	214.37	9257764.0
2016-09-14 10:30:00	SPY	ETF	214.38	214.7	213.5821	213.77	12467240.0
2016-09-14 11:00:00	SPY	ETF	213.76	214.2	213.4801	213.975	8359161.0
2016-09-14 11:30:00	SPY	ETF	213.97	214.1	213.6	214.025	5262799.0
2016-09-14 12:00:00	SPY	ETF	214.03	214.24	213.81	214.1	5584285.0
2016-09-14 12:30:00	SPY	ETF	214.1	214.16	213.63	213.79	5472432.0
2016-09-14 13:00:00	SPY	ETF	213.79	213.95	213.65	213.83	2976300.0
2016-09-14 13:30:00	SPY	ETF	213.8399	213.99	213.28	213.402	6314287.0
2016-09-14 14:00:00	SPY	ETF	213.4	213.54	212.79	213.22	9099409.0
2016-09-14 14:30:00	SPY	ETF	213.21	213.47	213.05	213.35	8894843.0
2016-09-14 15:00:00	SPY	ETF	213.35	213.43	212.5	212.52	11829054.0
2016-09-14 15:30:00	SPY	ETF	212.53	213.23	212.52	213.14	22848700.0
2016-09-14 16:00:00	SPY	ETF	213.14	213.44	212.4	212.69	7734377.0
2016-09-14 16:30:00	SPY	ETF	212.69	213.15	212.66	212.86	726676.0
2016-09-14 17:00:00	SPY	ETF	212.86	212.9	212.81	212.82	93108.0
2016-09-14 17:30:00	SPY	ETF	212.82	213.15	212.8	212.81	997977.0
2016-09-14 18:00:00	SPY	ETF	212.81	212.89	212.8	212.89	111324.0
2016-09-14 18:30:00	SPY	ETF	212.91	212.96	212.87	212.92	17549.0
2016-09-14 19:00:00	SPY	ETF	212.92	212.98	212.9	212.95	6470.0
2016-09-14 19:30:00	SPY	ETF	212.94	213.08	212.94	213.07	20757.0
2016-09-14 04:00:00	QQQ	ETF	115.6	115.8	115.6	115.8	5450.0
2016-09-14 04:30:00	QQQ	ETF	115.8	115.8	115.8	115.8	4550.0
2016-09-14 05:00:00	QQQ	ETF	115.65	115.65	115.52	115.59	4800.0
2016-09-14 06:00:00	QQQ	ETF	115.63	115.63	115.63	115.63	2100.0
2016-09-14 07:00:00	QQQ	ETF	115.63	115.85	115.62	115.85	1898.0
2016-09-14 07:30:00	QQQ	ETF	115.82	115.82	115.74	115.74	75543.0
2016-09-14 08:00:00	QQQ	ETF	115.59	115.78	115.59	115.76	33423.0
2016-09-14 08:30:00	QQQ	ETF	115.76	115.83	115.74	115.79	24314.0
2016-09-14 09:00:00	QQQ	ETF	115.76	115.76	115.33	115.41	176346.0
2016-09-14 09:30:00	QQQ	ETF	115.43	115.89	115.38	115.841	3850094.0
2016-09-14 10:00:00	QQQ	ETF	115.84	116.36	115.75	116.29	2601293.0
2016-09-14 10:30:00	QQQ	ETF	116.29	116.47	116.0	116.1107	2292162.0
2016-09-14 11:00:00	QQQ	ETF	116.11	116.4368	115.94	116.36	1651734.0
2016-09-14 11:30:00	QQQ	ETF	116.34	116.395	116.128	116.32	917112.0
2016-09-14 12:00:00	QQQ	ETF	116.32	116.47	116.2	116.3707	816656.0
2016-09-14 12:30:00	QQQ	ETF	116.38	116.42	116.13	116.18	1024977.0
2016-09-14 13:00:00	QQQ	ETF	116.18	116.268	116.11	116.23	735014.0
2016-09-14 13:30:00	QQQ	ETF	116.24	116.33	115.82	115.93	1908574.0

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

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