PREVIEW / etf_1hour / 2015-12-31

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-12-31.parquet
  size:    252 KB
  rows:    8,026

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-31 04:00:00	SPY	ETF	205.94	206.01	205.9	205.92	26900.0
2015-12-31 05:00:00	SPY	ETF	205.92	206.0	205.92	205.92	14300.0
2015-12-31 06:00:00	SPY	ETF	205.94	206.01	205.9	205.9	2400.0
2015-12-31 07:00:00	SPY	ETF	205.9	205.93	205.43	205.52	91527.0
2015-12-31 08:00:00	SPY	ETF	205.48	205.51	204.95	205.22	584193.0
2015-12-31 09:00:00	SPY	ETF	205.21	205.35	204.62	204.935	10001445.0
2015-12-31 10:00:00	SPY	ETF	204.91	205.0	204.17	204.559	12627235.0
2015-12-31 11:00:00	SPY	ETF	204.55	205.37	204.49	205.36	11280643.0
2015-12-31 12:00:00	SPY	ETF	205.3601	205.89	205.26	205.485	9504610.0
2015-12-31 13:00:00	SPY	ETF	205.4801	205.57	205.02	205.49	6071756.0
2015-12-31 14:00:00	SPY	ETF	205.4899	205.54	204.48	204.71	11498362.0
2015-12-31 15:00:00	SPY	ETF	204.71	204.91	203.87	203.93	27878844.0
2015-12-31 16:00:00	SPY	ETF	203.92	204.4353	203.54	204.0	23191473.0
2015-12-31 17:00:00	SPY	ETF	204.0	204.04	203.87	203.98	396331.0
2015-12-31 18:00:00	SPY	ETF	203.98	204.21	203.96	204.05	50468.0
2015-12-31 19:00:00	SPY	ETF	204.05	204.09	204.01	204.07	5657.0
2015-12-31 05:00:00	QQQ	ETF	113.4	113.4	113.39	113.4	400.0
2015-12-31 06:00:00	QQQ	ETF	113.45	113.45	113.33	113.33	1900.0
2015-12-31 07:00:00	QQQ	ETF	113.35	113.38	113.1	113.1	25868.0
2015-12-31 08:00:00	QQQ	ETF	113.14	113.15	112.83	112.9	80430.0
2015-12-31 09:00:00	QQQ	ETF	112.91	112.97	112.46	112.63	3378598.0
2015-12-31 10:00:00	QQQ	ETF	112.62	112.6975	112.18	112.44	3712115.0
2015-12-31 11:00:00	QQQ	ETF	112.43	112.81	112.4	112.8	3888122.0
2015-12-31 12:00:00	QQQ	ETF	112.7941	113.08	112.74	112.83	2856239.0
2015-12-31 13:00:00	QQQ	ETF	112.82	112.87	112.49	112.71	1572975.0
2015-12-31 14:00:00	QQQ	ETF	112.71	112.7433	112.14	112.31	2060334.0
2015-12-31 15:00:00	QQQ	ETF	112.3	112.3	111.84	111.87	7272584.0
2015-12-31 16:00:00	QQQ	ETF	111.88	112.04	111.72	112.02	1680423.0
2015-12-31 17:00:00	QQQ	ETF	112.02	112.02	111.86	111.98	302006.0
2015-12-31 18:00:00	QQQ	ETF	111.98	112.0	111.93	111.93	3835.0
2015-12-31 19:00:00	QQQ	ETF	112.0	112.0	111.98	111.98	1300.0
2015-12-31 06:00:00	IWM	ETF	113.82	113.82	113.82	113.82	4000.0
2015-12-31 07:00:00	IWM	ETF	113.83	113.85	113.66	113.66	18198.0
2015-12-31 08:00:00	IWM	ETF	113.59	113.6	113.37	113.55	67695.0
2015-12-31 09:00:00	IWM	ETF	113.58	113.78	113.05	113.25	3160474.0
2015-12-31 10:00:00	IWM	ETF	113.24	113.37	112.96	113.25	4255783.0
2015-12-31 11:00:00	IWM	ETF	113.24	113.72	113.09	113.72	3896747.0
2015-12-31 12:00:00	IWM	ETF	113.73	113.96	113.63	113.63	2791324.0
2015-12-31 13:00:00	IWM	ETF	113.64	113.88	113.37	113.88	2758205.0
2015-12-31 14:00:00	IWM	ETF	113.89	113.97	113.64	113.72	2902233.0
2015-12-31 15:00:00	IWM	ETF	113.7202	113.78	112.59	112.61	9336169.0
2015-12-31 16:00:00	IWM	ETF	112.59	112.7596	112.41	112.63	3720609.0
2015-12-31 17:00:00	IWM	ETF	112.62	113.07	112.61	112.9	137155.0
2015-12-31 18:00:00	IWM	ETF	112.92	113.0	112.91	112.91	800.0
2015-12-31 19:00:00	IWM	ETF	112.91	113.0	112.9	113.0	1120.0
2015-12-31 07:00:00	DIA	ETF	175.6	175.6	175.5	175.5	200.0
2015-12-31 08:00:00	DIA	ETF	175.45	175.45	174.98	175.18	3600.0
2015-12-31 09:00:00	DIA	ETF	175.14	175.1566	174.59	174.9	611130.0
2015-12-31 10:00:00	DIA	ETF	174.89	174.97	174.24	174.4499	942055.0
2015-12-31 11:00:00	DIA	ETF	174.46	175.19	174.39	175.18	978569.0

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

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