PREVIEW / etf_1hour / 2022-09-30

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-09-30.parquet
  size:    458 KB
  rows:    16,898

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-09-30 04:00:00	SPY	ETF	366.02	366.75	365.48	366.66	76677.0
2022-09-30 05:00:00	SPY	ETF	366.5	366.5	364.9	365.18	81209.0
2022-09-30 06:00:00	SPY	ETF	365.2	366.36	364.34	364.5	268267.0
2022-09-30 07:00:00	SPY	ETF	364.6	364.76	363.0	363.7	627116.0
2022-09-30 08:00:00	SPY	ETF	363.68	366.5604	361.6	363.54	2503332.0
2022-09-30 09:00:00	SPY	ETF	363.52	364.5	360.1623	363.1	10084992.0
2022-09-30 10:00:00	SPY	ETF	363.08	364.61	361.59	364.1599	10404727.0
2022-09-30 11:00:00	SPY	ETF	364.2	365.91	362.71	362.95	8829644.0
2022-09-30 12:00:00	SPY	ETF	362.96	363.385	361.8021	362.6574	6987120.0
2022-09-30 13:00:00	SPY	ETF	362.63	362.98	360.67	360.99	6222796.0
2022-09-30 14:00:00	SPY	ETF	360.98	361.77	359.13	359.32	10594481.0
2022-09-30 15:00:00	SPY	ETF	359.33	360.77	357.11	357.19	34102019.0
2022-09-30 16:00:00	SPY	ETF	357.19	358.74	357.02	357.94	8947109.0
2022-09-30 17:00:00	SPY	ETF	357.95	358.08	357.18	358.08	456136.0
2022-09-30 18:00:00	SPY	ETF	358.08	358.15	357.18	357.86	214192.0
2022-09-30 19:00:00	SPY	ETF	357.86	358.08	357.62	357.88	28925.0
2022-09-30 04:00:00	QQQ	ETF	274.0	274.97	273.96	274.9	136679.0
2022-09-30 05:00:00	QQQ	ETF	274.76	274.76	273.39	273.39	129833.0
2022-09-30 06:00:00	QQQ	ETF	273.6	274.5	273.05	273.06	169669.0
2022-09-30 07:00:00	QQQ	ETF	273.24	273.36	272.0	272.54	527969.0
2022-09-30 08:00:00	QQQ	ETF	272.53	274.7	270.56	272.29	2229246.0
2022-09-30 09:00:00	QQQ	ETF	272.3	273.15	270.0	272.15	8294337.0
2022-09-30 10:00:00	QQQ	ETF	272.14	274.2	271.26	273.78	7442670.0
2022-09-30 11:00:00	QQQ	ETF	273.8	275.19	272.26	272.492	6833073.0
2022-09-30 12:00:00	QQQ	ETF	272.5	272.89	271.38	272.03	4162878.0
2022-09-30 13:00:00	QQQ	ETF	272.02	272.28	270.17	270.4305	3884135.0
2022-09-30 14:00:00	QQQ	ETF	270.4	271.18	269.11	269.25	5810093.0
2022-09-30 15:00:00	QQQ	ETF	269.23	270.46	267.1	267.18	14675190.0
2022-09-30 16:00:00	QQQ	ETF	267.21	271.1666	267.1	267.87	2729517.0
2022-09-30 17:00:00	QQQ	ETF	267.9	268.04	267.26	267.72	571612.0
2022-09-30 18:00:00	QQQ	ETF	267.74	267.99	267.26	267.75	359138.0
2022-09-30 19:00:00	QQQ	ETF	267.66	268.89	267.59	267.7	39201.0
2022-09-30 04:00:00	IWM	ETF	167.93	168.44	167.76	168.37	34133.0
2022-09-30 05:00:00	IWM	ETF	168.4	168.4	167.64	167.78	17164.0
2022-09-30 06:00:00	IWM	ETF	167.74	168.3	167.2	167.2	80510.0
2022-09-30 07:00:00	IWM	ETF	167.4	167.4	166.47	166.85	71380.0
2022-09-30 08:00:00	IWM	ETF	167.03	168.2896	165.89	166.66	187482.0
2022-09-30 09:00:00	IWM	ETF	166.73	167.8	165.11	167.48	3099583.0
2022-09-30 10:00:00	IWM	ETF	167.47	168.64	166.98	168.58	2980041.0
2022-09-30 11:00:00	IWM	ETF	168.59	169.515	168.18	168.39	6756237.0
2022-09-30 12:00:00	IWM	ETF	168.39	168.62	167.42	168.185	2068785.0
2022-09-30 13:00:00	IWM	ETF	168.17	168.45	166.97	166.98	2133589.0
2022-09-30 14:00:00	IWM	ETF	166.99	167.43	165.86	165.94	2343054.0
2022-09-30 15:00:00	IWM	ETF	165.92	166.65	164.87	164.99	7491435.0
2022-09-30 16:00:00	IWM	ETF	164.92	165.54	164.81	165.08	3422252.0
2022-09-30 17:00:00	IWM	ETF	165.05	165.09	164.94	165.07	15950.0
2022-09-30 18:00:00	IWM	ETF	165.09	165.29	164.92	165.19	498291.0
2022-09-30 19:00:00	IWM	ETF	165.18	165.87	165.04	165.16	28488.0
2022-09-30 04:00:00	DIA	ETF	294.27	294.84	294.04	294.84	12577.0
2022-09-30 05:00:00	DIA	ETF	294.57	294.57	293.79	293.82	5586.0

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

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