PREVIEW / etf_1hour / 2015-12-18

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-12-18.parquet
  size:    253 KB
  rows:    8,072

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
2015-12-18 04:00:00	SPY	ETF	202.96	202.96	201.95	202.45	60010.0
2015-12-18 05:00:00	SPY	ETF	202.4	202.89	202.17	202.85	76535.0
2015-12-18 06:00:00	SPY	ETF	202.73	202.84	202.01	202.06	211641.0
2015-12-18 07:00:00	SPY	ETF	202.16	202.36	201.74	201.99	922822.0
2015-12-18 08:00:00	SPY	ETF	202.0	202.73	201.77	202.67	1805545.0
2015-12-18 09:00:00	SPY	ETF	202.69	203.5	202.17	202.48	28350980.0
2015-12-18 10:00:00	SPY	ETF	202.48	202.61	201.27	201.97	35120172.0
2015-12-18 11:00:00	SPY	ETF	201.96	202.3	201.42	201.54	23665777.0
2015-12-18 12:00:00	SPY	ETF	201.53	201.77	200.79	200.94	26461743.0
2015-12-18 13:00:00	SPY	ETF	200.9626	201.47	200.86	201.29	22382902.0
2015-12-18 14:00:00	SPY	ETF	201.295	201.93	201.06	201.11	25312196.0
2015-12-18 15:00:00	SPY	ETF	201.11	201.406	199.96	199.96	55244992.0
2015-12-18 16:00:00	SPY	ETF	199.96	201.71	199.67	200.02	24653730.0
2015-12-18 17:00:00	SPY	ETF	200.03	200.05	199.63	199.72	950754.0
2015-12-18 18:00:00	SPY	ETF	199.76	199.85	199.67	199.73	178280.0
2015-12-18 19:00:00	SPY	ETF	199.72	199.76	199.66	199.73	108193.0
2015-12-18 04:00:00	QQQ	ETF	111.27	111.31	111.08	111.18	33015.0
2015-12-18 05:00:00	QQQ	ETF	111.11	111.55	111.1	111.55	13000.0
2015-12-18 06:00:00	QQQ	ETF	111.35	111.4	111.13	111.21	7641.0
2015-12-18 07:00:00	QQQ	ETF	111.11	111.37	111.09	111.21	218934.0
2015-12-18 08:00:00	QQQ	ETF	111.23	111.6	111.13	111.57	151142.0
2015-12-18 09:00:00	QQQ	ETF	111.56	111.93	111.2301	111.62	9273264.0
2015-12-18 10:00:00	QQQ	ETF	111.62	111.65	110.71	111.17	8248665.0
2015-12-18 11:00:00	QQQ	ETF	111.17	111.48	110.91	111.0	3802894.0
2015-12-18 12:00:00	QQQ	ETF	110.999	111.11	110.365	110.385	4742415.0
2015-12-18 13:00:00	QQQ	ETF	110.381	110.809	110.375	110.71	3139161.0
2015-12-18 14:00:00	QQQ	ETF	110.72	111.0	110.451	110.4739	3449848.0
2015-12-18 15:00:00	QQQ	ETF	110.48	110.6699	109.9	109.9	9833084.0
2015-12-18 16:00:00	QQQ	ETF	109.88	110.8413	109.83	110.02	2082470.0
2015-12-18 17:00:00	QQQ	ETF	110.0	110.1	109.91	109.91	622555.0
2015-12-18 18:00:00	QQQ	ETF	109.94	109.99	109.92	109.98	8618.0
2015-12-18 19:00:00	QQQ	ETF	109.97	110.0	109.95	109.95	19690.0
2015-12-18 04:00:00	IWM	ETF	112.33	112.33	112.33	112.33	2500.0
2015-12-18 05:00:00	IWM	ETF	112.51	112.6	112.51	112.6	200.0
2015-12-18 06:00:00	IWM	ETF	112.33	112.39	112.28	112.28	600.0
2015-12-18 07:00:00	IWM	ETF	112.15	112.28	112.03	112.25	119832.0
2015-12-18 08:00:00	IWM	ETF	112.29	112.63	112.29	112.61	283895.0
2015-12-18 09:00:00	IWM	ETF	112.64	112.92	112.48	112.71	6315674.0
2015-12-18 10:00:00	IWM	ETF	112.71	112.84	112.13	112.59	7330494.0
2015-12-18 11:00:00	IWM	ETF	112.59	112.7	112.18	112.26	4546398.0
2015-12-18 12:00:00	IWM	ETF	112.26	112.3	111.63	111.7	5124007.0
2015-12-18 13:00:00	IWM	ETF	111.7	111.88	111.51	111.79	4270147.0
2015-12-18 14:00:00	IWM	ETF	111.8	112.17	111.78	111.99	3530381.0
2015-12-18 15:00:00	IWM	ETF	111.995	112.14	111.47	111.49	9285607.0
2015-12-18 16:00:00	IWM	ETF	111.49	111.88	111.1912	111.54	1901015.0
2015-12-18 17:00:00	IWM	ETF	111.54	112.55	111.4	111.4	1038188.0
2015-12-18 18:00:00	IWM	ETF	111.5	111.5	111.5	111.5	100.0
2015-12-18 19:00:00	IWM	ETF	111.4	111.4	111.4	111.4	280.0
2015-12-18 04:00:00	DIA	ETF	173.49	173.49	173.49	173.49	100.0
2015-12-18 05:00:00	DIA	ETF	173.54	173.55	173.54	173.55	1700.0

> showing 50 of 8,072 rows — these rows as CSV

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