PREVIEW / etf_1hour / 2023-11-01

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-11-01.parquet
  size:    496 KB
  rows:    18,219

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
2023-11-01 04:00:00	SPY	ETF	417.5	417.8	416.65	416.88	18485.0
2023-11-01 05:00:00	SPY	ETF	416.89	417.2	416.51	416.66	11336.0
2023-11-01 06:00:00	SPY	ETF	416.71	417.08	416.39	416.86	91457.0
2023-11-01 07:00:00	SPY	ETF	416.86	417.0	416.24	416.5	232277.0
2023-11-01 08:00:00	SPY	ETF	416.68	418.78	416.28	418.44	886083.0
2023-11-01 09:00:00	SPY	ETF	418.42	419.88	417.82	419.475	6413557.0
2023-11-01 10:00:00	SPY	ETF	419.49	421.9	419.17	421.25	12364887.0
2023-11-01 11:00:00	SPY	ETF	421.26	421.615	420.2282	420.7209	7072863.0
2023-11-01 12:00:00	SPY	ETF	420.735	420.735	419.3	419.75	5551038.0
2023-11-01 13:00:00	SPY	ETF	419.755	420.41	419.375	420.14	5090497.0
2023-11-01 14:00:00	SPY	ETF	420.1	421.76	419.08	421.3543	16420312.0
2023-11-01 15:00:00	SPY	ETF	421.36	423.5	421.34	422.7	22944625.0
2023-11-01 16:00:00	SPY	ETF	422.7	422.88	420.4233	422.84	2919474.0
2023-11-01 17:00:00	SPY	ETF	422.87	423.1	422.7	422.98	66574.0
2023-11-01 18:00:00	SPY	ETF	422.97	423.15	422.85	423.05	39936.0
2023-11-01 19:00:00	SPY	ETF	423.06	423.63	423.01	423.63	127989.0
2023-11-01 04:00:00	QQQ	ETF	350.41	350.5	349.53	349.77	69321.0
2023-11-01 05:00:00	QQQ	ETF	349.75	350.0	349.35	349.49	25439.0
2023-11-01 06:00:00	QQQ	ETF	349.51	349.88	349.27	349.65	39565.0
2023-11-01 07:00:00	QQQ	ETF	349.71	349.87	349.1	349.28	143956.0
2023-11-01 08:00:00	QQQ	ETF	349.7	351.56	349.1499	351.16	724091.0
2023-11-01 09:00:00	QQQ	ETF	351.16	353.2	350.48	352.38	4998841.0
2023-11-01 10:00:00	QQQ	ETF	352.41	354.83	351.94	354.195	7941846.0
2023-11-01 11:00:00	QQQ	ETF	354.19	354.66	353.08	353.89	3639773.0
2023-11-01 12:00:00	QQQ	ETF	353.9	354.0187	352.73	353.3099	3062074.0
2023-11-01 13:00:00	QQQ	ETF	353.305	354.035	353.01	353.74	3045725.0
2023-11-01 14:00:00	QQQ	ETF	353.77	355.45	352.63	355.08	11054102.0
2023-11-01 15:00:00	QQQ	ETF	355.07	357.5298	355.04	357.09	12934410.0
2023-11-01 16:00:00	QQQ	ETF	357.06	357.51	356.82	357.51	1477545.0
2023-11-01 17:00:00	QQQ	ETF	357.48	357.65	357.36	357.55	73601.0
2023-11-01 18:00:00	QQQ	ETF	357.53	357.83	357.5	357.73	127887.0
2023-11-01 19:00:00	QQQ	ETF	357.7499	358.36	357.7499	358.27	97305.0
2023-11-01 04:00:00	IWM	ETF	164.07	164.16	163.58	163.58	3894.0
2023-11-01 05:00:00	IWM	ETF	163.62	163.86	163.56	163.64	2596.0
2023-11-01 06:00:00	IWM	ETF	163.65	163.86	163.5	163.75	40003.0
2023-11-01 07:00:00	IWM	ETF	163.74	163.78	163.4	163.51	68676.0
2023-11-01 08:00:00	IWM	ETF	163.7487	164.56	163.46	164.21	249556.0
2023-11-01 09:00:00	IWM	ETF	164.05	164.73	163.1	163.96	5086980.0
2023-11-01 10:00:00	IWM	ETF	163.96	165.27	163.52	164.74	6220120.0
2023-11-01 11:00:00	IWM	ETF	164.735	164.92	164.12	164.545	3467434.0
2023-11-01 12:00:00	IWM	ETF	164.55	164.645	163.67	163.74	2989840.0
2023-11-01 13:00:00	IWM	ETF	163.735	164.06	163.55	164.03	2479594.0
2023-11-01 14:00:00	IWM	ETF	164.02	164.56	163.12	164.21	6806988.0
2023-11-01 15:00:00	IWM	ETF	164.2	165.6	164.19	165.43	9846860.0
2023-11-01 16:00:00	IWM	ETF	165.46	165.49	165.12	165.35	789287.0
2023-11-01 17:00:00	IWM	ETF	165.36	165.55	165.3	165.5	51220.0
2023-11-01 18:00:00	IWM	ETF	165.46	165.6	165.4	165.56	47719.0
2023-11-01 19:00:00	IWM	ETF	165.6	165.92	165.6	165.92	71861.0
2023-11-01 04:00:00	DIA	ETF	329.34	329.34	329.16	329.16	682.0
2023-11-01 06:00:00	DIA	ETF	329.24	329.5	329.24	329.5	371.0

> showing 50 of 18,219 rows — these rows as CSV

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