PREVIEW / etf_1hour / 2023-10-31

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-31.parquet
  size:    491 KB
  rows:    17,955

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-31 04:00:00	SPY	ETF	414.7	416.26	414.47	416.19	56984.0
2023-10-31 05:00:00	SPY	ETF	416.15	416.47	415.49	416.36	46222.0
2023-10-31 06:00:00	SPY	ETF	416.48	416.83	416.34	416.55	48137.0
2023-10-31 07:00:00	SPY	ETF	416.58	416.88	416.36	416.5	104470.0
2023-10-31 08:00:00	SPY	ETF	416.48	416.99	413.83	416.07	570297.0
2023-10-31 09:00:00	SPY	ETF	416.11	416.44	414.28	414.7636	5476974.0
2023-10-31 10:00:00	SPY	ETF	414.76	416.56	414.21	416.31	9431865.0
2023-10-31 11:00:00	SPY	ETF	416.32	416.58	415.4	416.45	6109897.0
2023-10-31 12:00:00	SPY	ETF	416.44	416.85	415.215	416.73	6415080.0
2023-10-31 13:00:00	SPY	ETF	416.74	417.935	416.33	417.8431	6822082.0
2023-10-31 14:00:00	SPY	ETF	417.86	418.23	417.07	418.105	7288708.0
2023-10-31 15:00:00	SPY	ETF	418.11	418.53	417.58	418.23	16396640.0
2023-10-31 16:00:00	SPY	ETF	418.23	418.33	415.69	417.4	4690752.0
2023-10-31 17:00:00	SPY	ETF	418.2	418.2	417.3	417.5	1245019.0
2023-10-31 18:00:00	SPY	ETF	417.6	417.69	417.24	417.52	40687.0
2023-10-31 19:00:00	SPY	ETF	417.53	417.53	417.13	417.28	47175.0
2023-10-31 04:00:00	QQQ	ETF	347.66	349.17	347.43	349.17	84710.0
2023-10-31 05:00:00	QQQ	ETF	349.03	349.21	348.29	349.13	111094.0
2023-10-31 06:00:00	QQQ	ETF	349.05	349.65	349.05	349.34	64768.0
2023-10-31 07:00:00	QQQ	ETF	349.4	349.89	349.27	349.41	164706.0
2023-10-31 08:00:00	QQQ	ETF	349.41	350.05	346.92	349.04	540916.0
2023-10-31 09:00:00	QQQ	ETF	349.1	349.53	346.62	347.335	5591980.0
2023-10-31 10:00:00	QQQ	ETF	347.31	349.54	346.87	349.165	6864999.0
2023-10-31 11:00:00	QQQ	ETF	349.18	349.58	347.96	349.1199	3823207.0
2023-10-31 12:00:00	QQQ	ETF	349.115	349.74	348.03	349.63	4504609.0
2023-10-31 13:00:00	QQQ	ETF	349.64	350.77	349.09	350.63	4548932.0
2023-10-31 14:00:00	QQQ	ETF	350.65	350.92	349.78	350.79	4000620.0
2023-10-31 15:00:00	QQQ	ETF	350.81	351.25	350.42	350.9199	7086227.0
2023-10-31 16:00:00	QQQ	ETF	350.92	350.92	349.83	350.0	814191.0
2023-10-31 17:00:00	QQQ	ETF	350.0	350.45	349.97	350.2	161380.0
2023-10-31 18:00:00	QQQ	ETF	350.31	350.6	350.08	350.31	105943.0
2023-10-31 19:00:00	QQQ	ETF	350.24	350.24	349.93	350.07	60171.0
2023-10-31 04:00:00	IWM	ETF	162.72	163.47	162.62	163.47	17576.0
2023-10-31 05:00:00	IWM	ETF	163.49	163.62	163.19	163.59	7304.0
2023-10-31 06:00:00	IWM	ETF	163.59	163.81	163.59	163.81	54376.0
2023-10-31 07:00:00	IWM	ETF	163.73	164.05	163.62	163.93	65030.0
2023-10-31 08:00:00	IWM	ETF	163.7512	164.01	162.38	163.7	588590.0
2023-10-31 09:00:00	IWM	ETF	163.73	164.02	162.94	163.12	2842838.0
2023-10-31 10:00:00	IWM	ETF	163.13	164.44	162.83	164.35	4202399.0
2023-10-31 11:00:00	IWM	ETF	164.36	164.8	164.09	164.79	3720956.0
2023-10-31 12:00:00	IWM	ETF	164.79	164.87	164.085	164.475	2921688.0
2023-10-31 13:00:00	IWM	ETF	164.47	164.63	164.15	164.565	2746322.0
2023-10-31 14:00:00	IWM	ETF	164.57	164.845	164.28	164.8	1824774.0
2023-10-31 15:00:00	IWM	ETF	164.81	164.99	164.49	164.6	5027792.0
2023-10-31 16:00:00	IWM	ETF	164.52	164.63	164.19	164.23	1190227.0
2023-10-31 17:00:00	IWM	ETF	164.26	164.4	164.25	164.27	5817.0
2023-10-31 18:00:00	IWM	ETF	164.3	164.3	164.1	164.22	4087.0
2023-10-31 19:00:00	IWM	ETF	164.22	164.22	164.02	164.02	22928.0
2023-10-31 04:00:00	DIA	ETF	329.36	330.29	329.19	330.29	1953.0
2023-10-31 05:00:00	DIA	ETF	330.42	330.47	330.02	330.44	1903.0

> showing 50 of 17,955 rows — these rows as CSV

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