PREVIEW / etf_1hour / 2023-10-25

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-25.parquet
  size:    487 KB
  rows:    18,083

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-10-25 04:00:00	SPY	ETF	422.24	422.43	421.54	422.2	59979.0
2023-10-25 05:00:00	SPY	ETF	422.08	422.36	421.63	421.97	36302.0
2023-10-25 06:00:00	SPY	ETF	421.98	422.34	421.5	422.33	30153.0
2023-10-25 07:00:00	SPY	ETF	422.35	422.7	422.3	422.36	108211.0
2023-10-25 08:00:00	SPY	ETF	422.56	422.95	421.21	421.94	459865.0
2023-10-25 09:00:00	SPY	ETF	421.9	422.25	419.51	420.19	8790564.0
2023-10-25 10:00:00	SPY	ETF	420.18	421.12	419.02	420.1488	11200901.0
2023-10-25 11:00:00	SPY	ETF	420.13	421.43	419.48	419.53	9951945.0
2023-10-25 12:00:00	SPY	ETF	419.531	419.78	418.34	418.585	7778112.0
2023-10-25 13:00:00	SPY	ETF	418.59	418.86	417.015	417.72	10009289.0
2023-10-25 14:00:00	SPY	ETF	417.72	418.32	417.12	417.675	7442538.0
2023-10-25 15:00:00	SPY	ETF	417.695	418.455	417.22	417.61	16672775.0
2023-10-25 16:00:00	SPY	ETF	417.61	420.7766	417.53	417.7	4942370.0
2023-10-25 17:00:00	SPY	ETF	417.74	417.78	417.16	417.18	175701.0
2023-10-25 18:00:00	SPY	ETF	417.15	417.15	415.7	416.05	291876.0
2023-10-25 19:00:00	SPY	ETF	416.05	416.14	415.27	415.72	117271.0
2023-10-25 04:00:00	QQQ	ETF	356.8	357.35	356.54	357.06	78168.0
2023-10-25 05:00:00	QQQ	ETF	357.0	357.31	356.6	356.94	64493.0
2023-10-25 06:00:00	QQQ	ETF	356.91	357.39	356.5	357.36	24508.0
2023-10-25 07:00:00	QQQ	ETF	357.39	357.69	357.19	357.29	177019.0
2023-10-25 08:00:00	QQQ	ETF	357.52	359.399	356.1	356.85	439092.0
2023-10-25 09:00:00	QQQ	ETF	356.82	357.08	353.42	354.53	8246872.0
2023-10-25 10:00:00	QQQ	ETF	354.53	355.2	353.23	353.85	8843111.0
2023-10-25 11:00:00	QQQ	ETF	353.85	355.36	352.72	352.79	6257232.0
2023-10-25 12:00:00	QQQ	ETF	352.79	353.175	351.8312	352.16	3607666.0
2023-10-25 13:00:00	QQQ	ETF	352.15	352.36	349.78	350.5	6600787.0
2023-10-25 14:00:00	QQQ	ETF	350.505	351.098	349.75	350.34	5343396.0
2023-10-25 15:00:00	QQQ	ETF	350.36	351.0	349.76	350.3	9738641.0
2023-10-25 16:00:00	QQQ	ETF	350.34	351.7	349.54	350.021	3396437.0
2023-10-25 17:00:00	QQQ	ETF	350.02	350.18	349.0	349.1	219222.0
2023-10-25 18:00:00	QQQ	ETF	349.1	349.14	347.3	347.71	694107.0
2023-10-25 19:00:00	QQQ	ETF	347.7	347.72	346.78	347.17	239903.0
2023-10-25 04:00:00	IWM	ETF	165.37	165.81	165.27	165.68	95536.0
2023-10-25 05:00:00	IWM	ETF	165.63	165.67	165.3	165.3	6885.0
2023-10-25 06:00:00	IWM	ETF	165.43	165.59	165.25	165.46	24307.0
2023-10-25 07:00:00	IWM	ETF	165.58	165.68	165.5	165.52	31255.0
2023-10-25 08:00:00	IWM	ETF	165.57	166.0	165.11	165.27	241258.0
2023-10-25 09:00:00	IWM	ETF	165.25	165.655	164.29	164.37	4290448.0
2023-10-25 10:00:00	IWM	ETF	164.38	164.63	163.77	164.42	4273103.0
2023-10-25 11:00:00	IWM	ETF	164.41	165.015	164.38	164.39	4389026.0
2023-10-25 12:00:00	IWM	ETF	164.39	164.515	163.86	163.93	3040114.0
2023-10-25 13:00:00	IWM	ETF	163.92	164.045	163.4	163.88	4112114.0
2023-10-25 14:00:00	IWM	ETF	163.88	164.215	163.77	163.97	2724121.0
2023-10-25 15:00:00	IWM	ETF	163.97	164.27	163.66	163.71	5277185.0
2023-10-25 16:00:00	IWM	ETF	163.71	164.14	163.71	163.86	902811.0
2023-10-25 17:00:00	IWM	ETF	163.81	163.92	163.5	163.51	41838.0
2023-10-25 18:00:00	IWM	ETF	163.61	163.67	163.37	163.5	53409.0
2023-10-25 19:00:00	IWM	ETF	163.5	163.53	163.18	163.33	17397.0
2023-10-25 04:00:00	DIA	ETF	331.8	331.8	331.79	331.79	400.0
2023-10-25 05:00:00	DIA	ETF	331.75	331.97	331.4	331.4	2976.0

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

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