PREVIEW / etf_1hour / 2021-02-02

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-02-02.parquet
  size:    418 KB
  rows:    14,636

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-02 04:00:00	SPY	ETF	378.89	379.8	378.83	379.53	279450.0
2021-02-02 05:00:00	SPY	ETF	379.54	380.0	379.29	379.73	73596.0
2021-02-02 06:00:00	SPY	ETF	379.73	379.87	378.97	378.97	42606.0
2021-02-02 07:00:00	SPY	ETF	378.97	379.53	378.92	379.15	214108.0
2021-02-02 08:00:00	SPY	ETF	379.0899	379.72	378.25	379.62	457099.0
2021-02-02 09:00:00	SPY	ETF	379.62	381.21	379.22	380.87	6264515.0
2021-02-02 10:00:00	SPY	ETF	380.89	382.54	380.87	382.08	7973136.0
2021-02-02 11:00:00	SPY	ETF	382.07	383.1	381.93	383.03	4695870.0
2021-02-02 12:00:00	SPY	ETF	383.03	383.22	382.51	382.9889	3115321.0
2021-02-02 13:00:00	SPY	ETF	382.99	383.08	382.21	382.63	2978952.0
2021-02-02 14:00:00	SPY	ETF	382.63	383.14	382.46	383.12	3692926.0
2021-02-02 15:00:00	SPY	ETF	383.11	383.12	381.38	381.54	14344200.0
2021-02-02 16:00:00	SPY	ETF	381.54	382.5	381.07	382.43	4624392.0
2021-02-02 17:00:00	SPY	ETF	382.48	382.73	382.48	382.54	129915.0
2021-02-02 18:00:00	SPY	ETF	382.65	382.97	381.55	382.47	177344.0
2021-02-02 19:00:00	SPY	ETF	382.5	383.5	382.24	383.34	432051.0
2021-02-02 04:00:00	QQQ	ETF	324.97	326.0	324.86	325.75	34190.0
2021-02-02 05:00:00	QQQ	ETF	325.73	325.88	325.49	325.7	30302.0
2021-02-02 06:00:00	QQQ	ETF	325.68	325.7	324.98	324.99	49796.0
2021-02-02 07:00:00	QQQ	ETF	324.92	325.49	324.83	325.11	179594.0
2021-02-02 08:00:00	QQQ	ETF	325.1	325.69	322.42	325.48	330446.0
2021-02-02 09:00:00	QQQ	ETF	325.45	327.21	324.94	326.175	3992823.0
2021-02-02 10:00:00	QQQ	ETF	326.18	327.52	325.855	327.0	4419177.0
2021-02-02 11:00:00	QQQ	ETF	326.99	328.03	326.53	327.99	2316253.0
2021-02-02 12:00:00	QQQ	ETF	327.99	328.32	327.8	328.08	1633434.0
2021-02-02 13:00:00	QQQ	ETF	328.09	328.66	327.2418	328.34	2133793.0
2021-02-02 14:00:00	QQQ	ETF	328.34	328.87	328.08	328.76	2759531.0
2021-02-02 15:00:00	QQQ	ETF	328.75	328.75	327.6	327.74	6023549.0
2021-02-02 16:00:00	QQQ	ETF	327.74	329.22	326.8	328.95	2043474.0
2021-02-02 17:00:00	QQQ	ETF	329.0	329.28	327.68	329.1	127063.0
2021-02-02 18:00:00	QQQ	ETF	329.2	329.21	328.56	328.69	107421.0
2021-02-02 19:00:00	QQQ	ETF	328.8	329.81	328.48	329.7	108194.0
2021-02-02 04:00:00	IWM	ETF	212.58	212.82	212.51	212.79	20699.0
2021-02-02 05:00:00	IWM	ETF	212.94	213.26	212.72	213.26	5800.0
2021-02-02 06:00:00	IWM	ETF	213.25	213.39	212.6	212.79	6888.0
2021-02-02 07:00:00	IWM	ETF	212.67	213.08	212.57	212.79	80937.0
2021-02-02 08:00:00	IWM	ETF	212.97	213.06	212.11	212.96	177507.0
2021-02-02 09:00:00	IWM	ETF	212.98	213.31	210.97	211.43	3007973.0
2021-02-02 10:00:00	IWM	ETF	211.43	212.115	210.89	211.7	3856899.0
2021-02-02 11:00:00	IWM	ETF	211.7	213.9	211.52	213.52	2449961.0
2021-02-02 12:00:00	IWM	ETF	213.54	213.93	213.23	213.68	1192248.0
2021-02-02 13:00:00	IWM	ETF	213.68	213.98	213.07	213.46	1061927.0
2021-02-02 14:00:00	IWM	ETF	213.46	213.89	213.22	213.89	801202.0
2021-02-02 15:00:00	IWM	ETF	213.87	214.05	213.46	213.61	2451450.0
2021-02-02 16:00:00	IWM	ETF	213.61	213.85	212.93	213.4	1064982.0
2021-02-02 17:00:00	IWM	ETF	213.31	213.61	213.31	213.31	66454.0
2021-02-02 18:00:00	IWM	ETF	213.56	213.79	213.11	213.42	50355.0
2021-02-02 19:00:00	IWM	ETF	213.41	214.06	213.3	214.0	38788.0
2021-02-02 04:00:00	DIA	ETF	304.48	304.83	304.48	304.75	1900.0
2021-02-02 05:00:00	DIA	ETF	304.65	304.66	304.65	304.66	510.0

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

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