PREVIEW / etf_1hour / 2023-10-26

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-26.parquet
  size:    495 KB
  rows:    18,428

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-26 04:00:00	SPY	ETF	414.88	415.43	414.75	415.04	38510.0
2023-10-26 05:00:00	SPY	ETF	415.2	415.75	414.75	415.17	47473.0
2023-10-26 06:00:00	SPY	ETF	415.15	415.75	414.85	414.85	118112.0
2023-10-26 07:00:00	SPY	ETF	414.93	414.96	414.06	414.77	251784.0
2023-10-26 08:00:00	SPY	ETF	414.38	416.78	414.0	416.64	1076320.0
2023-10-26 09:00:00	SPY	ETF	416.65	417.325	415.25	415.39	9188788.0
2023-10-26 10:00:00	SPY	ETF	415.38	416.88	414.32	416.34	13654420.0
2023-10-26 11:00:00	SPY	ETF	416.34	416.6	413.89	414.52	8960066.0
2023-10-26 12:00:00	SPY	ETF	414.5	414.51	412.14	412.185	11282620.0
2023-10-26 13:00:00	SPY	ETF	412.185	413.72	411.6	413.6201	10800686.0
2023-10-26 14:00:00	SPY	ETF	413.63	415.55	413.34	415.55	9893119.0
2023-10-26 15:00:00	SPY	ETF	415.55	415.94	412.285	412.59	23264099.0
2023-10-26 16:00:00	SPY	ETF	412.58	415.3844	411.88	412.87	5574519.0
2023-10-26 17:00:00	SPY	ETF	412.81	414.0	412.6618	413.75	201218.0
2023-10-26 18:00:00	SPY	ETF	413.6	414.45	413.6	414.33	176463.0
2023-10-26 19:00:00	SPY	ETF	414.33	414.94	414.33	414.83	64872.0
2023-10-26 04:00:00	QQQ	ETF	346.88	347.84	346.12	346.93	159374.0
2023-10-26 05:00:00	QQQ	ETF	347.06	347.56	346.5	347.08	118465.0
2023-10-26 06:00:00	QQQ	ETF	347.14	347.83	346.83	347.05	148799.0
2023-10-26 07:00:00	QQQ	ETF	347.06	347.13	346.29	346.99	306683.0
2023-10-26 08:00:00	QQQ	ETF	347.01	350.602	345.26	348.74	1348475.0
2023-10-26 09:00:00	QQQ	ETF	348.7	350.07	346.54	346.9509	8982105.0
2023-10-26 10:00:00	QQQ	ETF	346.9599	348.24	345.4112	347.49	10791357.0
2023-10-26 11:00:00	QQQ	ETF	347.49	347.6	344.4799	345.42	6778652.0
2023-10-26 12:00:00	QQQ	ETF	345.4	345.59	342.46	342.62	7629736.0
2023-10-26 13:00:00	QQQ	ETF	342.64	344.51	342.35	344.39	7084312.0
2023-10-26 14:00:00	QQQ	ETF	344.41	346.665	344.1	346.66	6493669.0
2023-10-26 15:00:00	QQQ	ETF	346.65	347.0	343.275	343.64	10921535.0
2023-10-26 16:00:00	QQQ	ETF	343.64	345.16	343.37	344.06	3485505.0
2023-10-26 17:00:00	QQQ	ETF	344.03	344.92	343.07	344.9	471906.0
2023-10-26 18:00:00	QQQ	ETF	344.9	346.23	344.89	345.99	378458.0
2023-10-26 19:00:00	QQQ	ETF	345.97	346.66	345.97	346.62	166988.0
2023-10-26 04:00:00	IWM	ETF	163.08	163.32	163.01	163.17	26167.0
2023-10-26 05:00:00	IWM	ETF	163.22	163.49	163.01	163.4	4350.0
2023-10-26 06:00:00	IWM	ETF	163.25	163.58	163.12	163.12	33909.0
2023-10-26 07:00:00	IWM	ETF	163.08	163.08	162.62	163.03	73675.0
2023-10-26 08:00:00	IWM	ETF	163.08	164.32	162.71	164.21	346645.0
2023-10-26 09:00:00	IWM	ETF	164.18	164.91	163.9	164.1	4456828.0
2023-10-26 10:00:00	IWM	ETF	164.1	165.77	163.7	165.45	7511268.0
2023-10-26 11:00:00	IWM	ETF	165.46	165.71	164.57	164.77	4741935.0
2023-10-26 12:00:00	IWM	ETF	164.76	164.76	163.39	163.43	4179430.0
2023-10-26 13:00:00	IWM	ETF	163.43	164.11	163.2	164.105	3946904.0
2023-10-26 14:00:00	IWM	ETF	164.1	165.335	164.01	165.32	3551305.0
2023-10-26 15:00:00	IWM	ETF	165.325	165.6	163.86	164.15	4740954.0
2023-10-26 16:00:00	IWM	ETF	164.14	164.43	163.82	164.21	1328894.0
2023-10-26 17:00:00	IWM	ETF	164.18	164.29	164.05	164.29	17066.0
2023-10-26 18:00:00	IWM	ETF	164.34	164.61	164.32	164.5	65628.0
2023-10-26 19:00:00	IWM	ETF	164.55	164.9	164.55	164.89	42093.0
2023-10-26 04:00:00	DIA	ETF	329.58	329.79	329.26	329.27	1925.0
2023-10-26 05:00:00	DIA	ETF	329.2	329.8	329.2	329.8	1850.0

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

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