PREVIEW / etf_1hour / 2022-08-29

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-29.parquet
  size:    447 KB
  rows:    16,457

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
2022-08-29 04:00:00	SPY	ETF	403.39	403.39	401.31	401.32	49964.0
2022-08-29 05:00:00	SPY	ETF	401.31	401.94	401.07	401.77	47653.0
2022-08-29 06:00:00	SPY	ETF	401.78	402.08	401.32	401.54	71299.0
2022-08-29 07:00:00	SPY	ETF	401.49	401.82	401.02	401.82	403198.0
2022-08-29 08:00:00	SPY	ETF	401.21	403.13	401.02	401.99	686961.0
2022-08-29 09:00:00	SPY	ETF	402.0	404.17	401.5101	402.814	7493743.0
2022-08-29 10:00:00	SPY	ETF	402.84	404.52	401.1999	401.4	9066320.0
2022-08-29 11:00:00	SPY	ETF	401.38	403.53	401.28	403.37	6681765.0
2022-08-29 12:00:00	SPY	ETF	403.39	405.27	403.08	404.62	5539919.0
2022-08-29 13:00:00	SPY	ETF	404.64	405.84	403.86	405.08	4906449.0
2022-08-29 14:00:00	SPY	ETF	405.12	405.1369	403.66	404.6	4147660.0
2022-08-29 15:00:00	SPY	ETF	404.63	405.605	402.4	402.63	9161117.0
2022-08-29 16:00:00	SPY	ETF	402.62	402.99	402.42	402.97	2404137.0
2022-08-29 17:00:00	SPY	ETF	402.94	402.98	402.82	402.85	84483.0
2022-08-29 18:00:00	SPY	ETF	402.91	403.16	402.88	402.89	113312.0
2022-08-29 19:00:00	SPY	ETF	402.94	403.73	402.73	403.62	81428.0
2022-08-29 04:00:00	QQQ	ETF	303.0	305.48	303.0	303.4	125714.0
2022-08-29 05:00:00	QQQ	ETF	303.4	304.18	303.3	304.01	114664.0
2022-08-29 06:00:00	QQQ	ETF	304.06	304.41	303.71	303.94	73582.0
2022-08-29 07:00:00	QQQ	ETF	303.94	304.02	303.36	304.01	304260.0
2022-08-29 08:00:00	QQQ	ETF	303.9306	307.67	303.2804	304.38	528391.0
2022-08-29 09:00:00	QQQ	ETF	304.4	307.14	304.013	305.345	7024143.0
2022-08-29 10:00:00	QQQ	ETF	305.38	307.22	303.53	303.66	6834807.0
2022-08-29 11:00:00	QQQ	ETF	303.64	305.075	303.28	304.845	5886615.0
2022-08-29 12:00:00	QQQ	ETF	304.84	306.64	304.55	306.03	4278854.0
2022-08-29 13:00:00	QQQ	ETF	306.06	307.1099	305.42	306.37	3170303.0
2022-08-29 14:00:00	QQQ	ETF	306.37	306.37	305.08	305.8506	3202015.0
2022-08-29 15:00:00	QQQ	ETF	305.85	306.82	304.2	304.41	5905103.0
2022-08-29 16:00:00	QQQ	ETF	304.41	304.65	304.08	304.65	1504333.0
2022-08-29 17:00:00	QQQ	ETF	304.62	304.75	304.41	304.52	67972.0
2022-08-29 18:00:00	QQQ	ETF	304.54	304.79	304.41	304.57	79590.0
2022-08-29 19:00:00	QQQ	ETF	304.57	305.4	304.27	305.31	109954.0
2022-08-29 04:00:00	IWM	ETF	187.65	187.65	186.77	186.77	40953.0
2022-08-29 05:00:00	IWM	ETF	186.82	187.12	186.62	187.04	21036.0
2022-08-29 06:00:00	IWM	ETF	187.01	187.22	186.86	187.15	14552.0
2022-08-29 07:00:00	IWM	ETF	186.93	187.14	186.59	187.13	31522.0
2022-08-29 08:00:00	IWM	ETF	186.75	187.71	186.59	187.22	72084.0
2022-08-29 09:00:00	IWM	ETF	187.23	188.33	186.52	187.82	2699684.0
2022-08-29 10:00:00	IWM	ETF	187.85	188.78	187.06	187.29	2049670.0
2022-08-29 11:00:00	IWM	ETF	187.29	188.15	187.22	187.89	1943077.0
2022-08-29 12:00:00	IWM	ETF	187.92	188.49	187.56	188.22	1567784.0
2022-08-29 13:00:00	IWM	ETF	188.22	188.99	187.93	188.72	1009529.0
2022-08-29 14:00:00	IWM	ETF	188.72	188.72	187.75	188.24	941461.0
2022-08-29 15:00:00	IWM	ETF	188.27	188.5779	187.16	187.24	3266318.0
2022-08-29 16:00:00	IWM	ETF	187.24	187.36	186.99	187.36	1385909.0
2022-08-29 17:00:00	IWM	ETF	187.34	187.34	187.18	187.28	7848.0
2022-08-29 18:00:00	IWM	ETF	187.29	187.4	187.23	187.24	18676.0
2022-08-29 19:00:00	IWM	ETF	187.3	187.73	187.14	187.6	28964.0
2022-08-29 04:00:00	DIA	ETF	320.97	320.97	320.8	320.8	1200.0
2022-08-29 05:00:00	DIA	ETF	320.26	320.27	319.85	320.02	4000.0

> showing 50 of 16,457 rows — these rows as CSV

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