PREVIEW / etf_1hour / 2015-01-02

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-01-02.parquet
  size:    237 KB
  rows:    7,548

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-01-02 04:00:00	SPY	ETF	206.25	206.38	206.17	206.25	76358.0
2015-01-02 05:00:00	SPY	ETF	206.32	206.39	206.11	206.39	13446.0
2015-01-02 06:00:00	SPY	ETF	206.4	206.4	206.09	206.14	60348.0
2015-01-02 07:00:00	SPY	ETF	206.24	206.43	206.18	206.36	215426.0
2015-01-02 08:00:00	SPY	ETF	206.36	206.45	205.5	206.43	357998.0
2015-01-02 09:00:00	SPY	ETF	206.44	206.88	205.5	206.51	15217539.0
2015-01-02 10:00:00	SPY	ETF	206.5	206.56	204.83	205.23	24125463.0
2015-01-02 11:00:00	SPY	ETF	205.24	205.31	204.47	204.96	15195385.0
2015-01-02 12:00:00	SPY	ETF	204.95	205.4	204.75	204.825	11956742.0
2015-01-02 13:00:00	SPY	ETF	204.83	205.5299	204.18	204.595	9229962.0
2015-01-02 14:00:00	SPY	ETF	204.59	205.33	204.55	205.0561	10916852.0
2015-01-02 15:00:00	SPY	ETF	205.06	205.88	204.63	205.41	19027791.0
2015-01-02 16:00:00	SPY	ETF	205.38	206.9	204.88	205.05	12944540.0
2015-01-02 17:00:00	SPY	ETF	205.04	205.04	204.93	205.04	109393.0
2015-01-02 18:00:00	SPY	ETF	205.03	205.1	204.95	205.05	17265.0
2015-01-02 19:00:00	SPY	ETF	205.02	205.12	205.02	205.11	23837.0
2015-01-02 04:00:00	QQQ	ETF	103.66	103.66	103.61	103.61	1800.0
2015-01-02 06:00:00	QQQ	ETF	103.59	103.59	103.55	103.55	5200.0
2015-01-02 07:00:00	QQQ	ETF	103.63	103.73	103.61	103.71	8032.0
2015-01-02 08:00:00	QQQ	ETF	103.72	103.87	103.6	103.76	125203.0
2015-01-02 09:00:00	QQQ	ETF	103.76	104.2	103.7	103.86	4128360.0
2015-01-02 10:00:00	QQQ	ETF	103.84	103.88	102.67	102.97	6968172.0
2015-01-02 11:00:00	QQQ	ETF	102.97	102.99	102.44	102.85	4594377.0
2015-01-02 12:00:00	QQQ	ETF	102.84	103.05	102.69	102.73	2350260.0
2015-01-02 13:00:00	QQQ	ETF	102.74	102.81	102.454	102.72	2766385.0
2015-01-02 14:00:00	QQQ	ETF	102.7	103.03	102.6901	102.88	2135111.0
2015-01-02 15:00:00	QQQ	ETF	102.88	103.25	102.67	103.0	4979526.0
2015-01-02 16:00:00	QQQ	ETF	102.99	103.373	102.74	102.81	1357652.0
2015-01-02 17:00:00	QQQ	ETF	102.84	102.94	102.75	102.94	14175.0
2015-01-02 18:00:00	QQQ	ETF	102.84	102.84	102.77	102.77	3216.0
2015-01-02 19:00:00	QQQ	ETF	102.84	102.84	102.79	102.84	3256.0
2015-01-02 06:00:00	IWM	ETF	119.81	120.0	119.81	120.0	200.0
2015-01-02 07:00:00	IWM	ETF	120.01	120.16	120.01	120.02	14700.0
2015-01-02 08:00:00	IWM	ETF	120.05	120.13	119.67	120.13	132617.0
2015-01-02 09:00:00	IWM	ETF	120.1	120.56	119.85	119.9972	5180950.0
2015-01-02 10:00:00	IWM	ETF	119.99	120.11	117.94	118.64	7429315.0
2015-01-02 11:00:00	IWM	ETF	118.64	118.68	117.89	118.22	4984376.0
2015-01-02 12:00:00	IWM	ETF	118.21	118.62	118.1	118.16	3222420.0
2015-01-02 13:00:00	IWM	ETF	118.16	118.46	117.925	118.28	2396276.0
2015-01-02 14:00:00	IWM	ETF	118.27	119.17	118.221	118.93	3495250.0
2015-01-02 15:00:00	IWM	ETF	118.93	119.15	118.63	118.94	5817160.0
2015-01-02 16:00:00	IWM	ETF	118.95	120.38	118.71	118.85	8128319.0
2015-01-02 17:00:00	IWM	ETF	118.85	118.9	118.79	118.9	7896.0
2015-01-02 18:00:00	IWM	ETF	118.9	118.9	118.9	118.9	100.0
2015-01-02 19:00:00	IWM	ETF	118.9	118.93	118.9	118.93	1063.0
2015-01-02 04:00:00	DIA	ETF	178.2	178.2	178.2	178.2	799.0
2015-01-02 07:00:00	DIA	ETF	178.79	178.79	178.79	178.79	500.0
2015-01-02 08:00:00	DIA	ETF	178.49	178.51	178.49	178.51	629.0
2015-01-02 09:00:00	DIA	ETF	178.92	179.23	178.5701	179.13	542783.0
2015-01-02 10:00:00	DIA	ETF	179.13	179.15	177.83	178.05	1116402.0

> showing 50 of 7,548 rows — these rows as CSV

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