PREVIEW / etf_1hour / 2021-02-01

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-02-01.parquet
  size:    429 KB
  rows:    14,978

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
2021-02-01 04:00:00	SPY	ETF	373.19	374.06	372.9	373.46	238779.0
2021-02-01 05:00:00	SPY	ETF	373.49	373.86	372.95	373.13	129791.0
2021-02-01 06:00:00	SPY	ETF	373.03	374.71	372.98	373.78	225615.0
2021-02-01 07:00:00	SPY	ETF	373.58	374.5	373.54	373.59	378366.0
2021-02-01 08:00:00	SPY	ETF	373.6999	374.4996	371.49	373.42	468057.0
2021-02-01 09:00:00	SPY	ETF	373.42	374.39	371.42	372.61	7931055.0
2021-02-01 10:00:00	SPY	ETF	372.615	373.99	371.7	372.84	7724211.0
2021-02-01 11:00:00	SPY	ETF	372.84	375.8	372.26	375.13	7479676.0
2021-02-01 12:00:00	SPY	ETF	375.1289	376.49	375.125	376.46	4422326.0
2021-02-01 13:00:00	SPY	ETF	376.455	376.71	375.81	376.43	3228226.0
2021-02-01 14:00:00	SPY	ETF	376.4499	377.34	376.06	376.89	4215627.0
2021-02-01 15:00:00	SPY	ETF	376.9	377.29	376.07	376.18	13056722.0
2021-02-01 16:00:00	SPY	ETF	376.18	376.3147	370.376	376.06	6154738.0
2021-02-01 17:00:00	SPY	ETF	376.06	376.17	375.9	376.12	107409.0
2021-02-01 18:00:00	SPY	ETF	376.15	376.96	376.1	376.63	229548.0
2021-02-01 19:00:00	SPY	ETF	376.57	376.57	375.71	376.39	158539.0
2021-02-01 04:00:00	QQQ	ETF	317.62	318.33	317.26	317.94	273198.0
2021-02-01 05:00:00	QQQ	ETF	317.98	318.23	317.48	317.57	112512.0
2021-02-01 06:00:00	QQQ	ETF	317.66	318.77	317.56	317.88	121041.0
2021-02-01 07:00:00	QQQ	ETF	317.88	318.62	317.63	317.98	226199.0
2021-02-01 08:00:00	QQQ	ETF	318.1704	318.7796	315.33	318.0	258854.0
2021-02-01 09:00:00	QQQ	ETF	318.02	319.39	316.02	317.415	4530230.0
2021-02-01 10:00:00	QQQ	ETF	317.34	320.07	316.6	318.61	4749852.0
2021-02-01 11:00:00	QQQ	ETF	318.63	321.65	317.9	321.12	3608728.0
2021-02-01 12:00:00	QQQ	ETF	321.13	323.08	321.13	323.05	2974374.0
2021-02-01 13:00:00	QQQ	ETF	323.055	323.54	322.3817	323.19	2898327.0
2021-02-01 14:00:00	QQQ	ETF	323.23	323.39	322.565	322.915	2535678.0
2021-02-01 15:00:00	QQQ	ETF	322.92	323.42	322.42	322.47	4370370.0
2021-02-01 16:00:00	QQQ	ETF	322.46	322.6643	321.95	322.58	990830.0
2021-02-01 17:00:00	QQQ	ETF	322.7	322.7	322.51	322.62	52371.0
2021-02-01 18:00:00	QQQ	ETF	322.62	323.55	322.62	323.25	61017.0
2021-02-01 19:00:00	QQQ	ETF	323.24	323.26	322.52	323.05	80163.0
2021-02-01 04:00:00	IWM	ETF	207.0	207.63	206.99	207.19	14851.0
2021-02-01 05:00:00	IWM	ETF	207.45	207.62	207.01	207.06	22346.0
2021-02-01 06:00:00	IWM	ETF	207.49	208.48	207.49	207.84	90621.0
2021-02-01 07:00:00	IWM	ETF	207.75	208.16	207.66	207.75	97993.0
2021-02-01 08:00:00	IWM	ETF	207.79	208.0398	206.28	207.61	157423.0
2021-02-01 09:00:00	IWM	ETF	207.64	208.57	206.0	206.81	2282896.0
2021-02-01 10:00:00	IWM	ETF	206.81	207.84	205.77	206.45	3810438.0
2021-02-01 11:00:00	IWM	ETF	206.46	208.65	205.76	208.11	3023248.0
2021-02-01 12:00:00	IWM	ETF	208.115	208.92	207.95	208.89	1441692.0
2021-02-01 13:00:00	IWM	ETF	208.9	209.47	208.46	209.44	1744581.0
2021-02-01 14:00:00	IWM	ETF	209.45	210.75	209.38	210.463	1348720.0
2021-02-01 15:00:00	IWM	ETF	210.48	211.57	210.345	210.65	3669733.0
2021-02-01 16:00:00	IWM	ETF	210.66	211.073	210.31	210.6704	2564539.0
2021-02-01 17:00:00	IWM	ETF	210.63	210.87	210.61	210.62	8219.0
2021-02-01 18:00:00	IWM	ETF	210.75	211.18	210.64	210.99	395072.0
2021-02-01 19:00:00	IWM	ETF	210.7	210.85	210.32	210.85	34319.0
2021-02-01 04:00:00	DIA	ETF	301.74	302.16	301.6	301.6	36932.0
2021-02-01 05:00:00	DIA	ETF	301.81	301.97	301.47	301.68	2600.0

> showing 50 of 14,978 rows — these rows as CSV

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