PREVIEW / etf_1hour / 2021-04-05

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-04-05.parquet
  size:    440 KB
  rows:    15,359

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-04-05 04:00:00	SPY	ETF	402.12	402.56	402.08	402.39	24175.0
2021-04-05 05:00:00	SPY	ETF	402.39	402.75	402.39	402.67	14173.0
2021-04-05 06:00:00	SPY	ETF	402.54	402.87	402.52	402.72	17655.0
2021-04-05 07:00:00	SPY	ETF	402.74	402.99	402.65	402.85	228569.0
2021-04-05 08:00:00	SPY	ETF	402.7404	403.44	401.73	403.33	274986.0
2021-04-05 09:00:00	SPY	ETF	403.35	404.63	403.25	404.55	8710439.0
2021-04-05 10:00:00	SPY	ETF	404.57	406.03	404.22	405.63	11141180.0
2021-04-05 11:00:00	SPY	ETF	405.63	406.5	405.485	406.22	5868416.0
2021-04-05 12:00:00	SPY	ETF	406.21	406.94	406.16	406.36	5453187.0
2021-04-05 13:00:00	SPY	ETF	406.355	406.61	406.08	406.59	4732110.0
2021-04-05 14:00:00	SPY	ETF	406.58	406.83	406.1001	406.115	5624509.0
2021-04-05 15:00:00	SPY	ETF	406.1101	406.84	405.75	406.31	17448033.0
2021-04-05 16:00:00	SPY	ETF	406.3	406.66	406.1	406.59	3911227.0
2021-04-05 17:00:00	SPY	ETF	406.59	406.65	406.36	406.55	125153.0
2021-04-05 18:00:00	SPY	ETF	406.53	406.98	406.36	406.89	88760.0
2021-04-05 19:00:00	SPY	ETF	406.9	406.99	406.71	406.74	54232.0
2021-04-05 04:00:00	QQQ	ETF	326.23	326.23	324.75	325.63	90005.0
2021-04-05 05:00:00	QQQ	ETF	325.52	326.25	325.49	326.01	32237.0
2021-04-05 06:00:00	QQQ	ETF	326.1	326.26	325.64	325.7	54695.0
2021-04-05 07:00:00	QQQ	ETF	325.73	326.29	325.7	326.25	240188.0
2021-04-05 08:00:00	QQQ	ETF	326.25	327.46	324.49	327.22	330676.0
2021-04-05 09:00:00	QQQ	ETF	327.25	328.74	326.88	328.52	4786371.0
2021-04-05 10:00:00	QQQ	ETF	328.54	330.0	328.06	329.445	5924451.0
2021-04-05 11:00:00	QQQ	ETF	329.485	330.48	329.26	330.05	3047850.0
2021-04-05 12:00:00	QQQ	ETF	330.06	331.02	330.06	330.76	2897197.0
2021-04-05 13:00:00	QQQ	ETF	330.77	331.49	330.715	331.46	2653216.0
2021-04-05 14:00:00	QQQ	ETF	331.46	331.84	331.29	331.44	2518139.0
2021-04-05 15:00:00	QQQ	ETF	331.44	331.6	330.62	331.08	7602182.0
2021-04-05 16:00:00	QQQ	ETF	331.07	331.53	330.88	331.47	1591554.0
2021-04-05 17:00:00	QQQ	ETF	331.4	331.51	331.3	331.39	30089.0
2021-04-05 18:00:00	QQQ	ETF	331.6	331.97	331.36	331.8	85214.0
2021-04-05 19:00:00	QQQ	ETF	331.85	332.02	331.75	331.88	52874.0
2021-04-05 04:00:00	IWM	ETF	226.7	226.88	226.63	226.85	8346.0
2021-04-05 05:00:00	IWM	ETF	226.8	227.04	226.8	227.0	4943.0
2021-04-05 06:00:00	IWM	ETF	227.08	227.45	226.93	227.45	30191.0
2021-04-05 07:00:00	IWM	ETF	227.45	227.47	226.6	226.86	111041.0
2021-04-05 08:00:00	IWM	ETF	227.39	227.42	226.33	226.61	134982.0
2021-04-05 09:00:00	IWM	ETF	226.65	226.67	224.43	224.67	3624756.0
2021-04-05 10:00:00	IWM	ETF	224.68	225.59	223.88	224.37	4409152.0
2021-04-05 11:00:00	IWM	ETF	224.36	224.93	223.68	223.955	2491367.0
2021-04-05 12:00:00	IWM	ETF	223.95	224.3	223.78	223.83	1723013.0
2021-04-05 13:00:00	IWM	ETF	223.83	224.8	223.57	224.63	1933322.0
2021-04-05 14:00:00	IWM	ETF	224.63	224.8	224.11	224.32	1768086.0
2021-04-05 15:00:00	IWM	ETF	224.32	225.13	223.91	224.93	3858984.0
2021-04-05 16:00:00	IWM	ETF	224.97	225.21	224.83	225.12	2674369.0
2021-04-05 17:00:00	IWM	ETF	225.12	225.3	224.97	225.13	90196.0
2021-04-05 18:00:00	IWM	ETF	225.13	225.13	224.59	225.11	133056.0
2021-04-05 19:00:00	IWM	ETF	225.13	225.15	224.36	224.45	199379.0
2021-04-05 04:00:00	DIA	ETF	333.48	333.5	333.4	333.44	16997.0
2021-04-05 05:00:00	DIA	ETF	333.49	333.49	333.42	333.46	1848.0

> showing 50 of 15,359 rows — these rows as CSV

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