PREVIEW / etf_1hour / 2023-10-27

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-27.parquet
  size:    488 KB
  rows:    17,864

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-27 04:00:00	SPY	ETF	414.5	415.35	414.4	415.35	34381.0
2023-10-27 05:00:00	SPY	ETF	415.3	415.4	414.54	414.7	41045.0
2023-10-27 06:00:00	SPY	ETF	414.72	414.97	414.22	414.27	19082.0
2023-10-27 07:00:00	SPY	ETF	414.26	414.38	413.11	413.2	199546.0
2023-10-27 08:00:00	SPY	ETF	414.31	415.14	413.0504	414.28	691362.0
2023-10-27 09:00:00	SPY	ETF	414.24	414.77	412.62	413.29	7310607.0
2023-10-27 10:00:00	SPY	ETF	413.3	414.13	411.865	413.52	12527744.0
2023-10-27 11:00:00	SPY	ETF	413.52	414.6	412.81	413.4599	8220541.0
2023-10-27 12:00:00	SPY	ETF	413.423	413.58	411.67	411.8	7127069.0
2023-10-27 13:00:00	SPY	ETF	411.815	412.03	410.12	410.4	10932878.0
2023-10-27 14:00:00	SPY	ETF	410.39	411.22	409.26	409.56	11519853.0
2023-10-27 15:00:00	SPY	ETF	409.55	410.91	409.21	410.73	22771393.0
2023-10-27 16:00:00	SPY	ETF	410.73	412.9909	409.5007	410.62	3158493.0
2023-10-27 17:00:00	SPY	ETF	410.62	410.67	410.04	410.67	91894.0
2023-10-27 18:00:00	SPY	ETF	410.66	411.08	410.66	411.08	51483.0
2023-10-27 19:00:00	SPY	ETF	411.08	411.25	410.22	410.35	61587.0
2023-10-27 04:00:00	QQQ	ETF	346.42	347.2	346.27	347.2	71185.0
2023-10-27 05:00:00	QQQ	ETF	347.19	347.3	346.62	346.9	37588.0
2023-10-27 06:00:00	QQQ	ETF	346.95	347.2	346.52	346.59	92081.0
2023-10-27 07:00:00	QQQ	ETF	346.6	346.78	345.73	345.8	432261.0
2023-10-27 08:00:00	QQQ	ETF	346.5985	347.24	343.917	346.6	824965.0
2023-10-27 09:00:00	QQQ	ETF	346.63	347.62	346.065	346.92	7100440.0
2023-10-27 10:00:00	QQQ	ETF	346.92	347.97	345.6525	347.15	8743122.0
2023-10-27 11:00:00	QQQ	ETF	347.15	348.84	346.89	348.01	6248514.0
2023-10-27 12:00:00	QQQ	ETF	348.0	348.28	346.13	346.33	4147809.0
2023-10-27 13:00:00	QQQ	ETF	346.36	346.53	344.55	344.91	6598775.0
2023-10-27 14:00:00	QQQ	ETF	344.88	345.87	344.14	344.47	6017540.0
2023-10-27 15:00:00	QQQ	ETF	344.48	345.57	344.08	345.42	8696951.0
2023-10-27 16:00:00	QQQ	ETF	345.42	345.82	345.31	345.51	1433923.0
2023-10-27 17:00:00	QQQ	ETF	345.48	345.5	345.3	345.49	40307.0
2023-10-27 18:00:00	QQQ	ETF	345.45	345.6	345.41	345.57	12746.0
2023-10-27 19:00:00	QQQ	ETF	345.57	345.65	345.35	345.43	34750.0
2023-10-27 04:00:00	IWM	ETF	164.72	165.3	164.69	165.2	7083.0
2023-10-27 05:00:00	IWM	ETF	165.16	165.16	164.87	164.87	2312.0
2023-10-27 06:00:00	IWM	ETF	164.9	164.94	164.46	164.52	33455.0
2023-10-27 07:00:00	IWM	ETF	164.46	164.57	164.13	164.13	58908.0
2023-10-27 08:00:00	IWM	ETF	164.3207	165.0604	164.01	164.33	130725.0
2023-10-27 09:00:00	IWM	ETF	164.38	164.83	162.67	162.96	4738128.0
2023-10-27 10:00:00	IWM	ETF	162.95	163.39	162.28	163.16	5591372.0
2023-10-27 11:00:00	IWM	ETF	163.17	163.7671	162.98	163.43	4485473.0
2023-10-27 12:00:00	IWM	ETF	163.43	163.43	162.52	162.575	2664979.0
2023-10-27 13:00:00	IWM	ETF	162.58	162.695	161.755	162.0	5040208.0
2023-10-27 14:00:00	IWM	ETF	162.0	162.355	161.67	161.86	3780262.0
2023-10-27 15:00:00	IWM	ETF	161.86	162.35	161.825	162.25	6982635.0
2023-10-27 16:00:00	IWM	ETF	162.21	162.34	162.0	162.14	3814497.0
2023-10-27 17:00:00	IWM	ETF	162.1402	162.16	162.01	162.14	28973.0
2023-10-27 18:00:00	IWM	ETF	162.17	162.21	162.11	162.16	3621.0
2023-10-27 19:00:00	IWM	ETF	162.19	163.0	162.01	162.01	36620.0
2023-10-27 04:00:00	DIA	ETF	328.43	328.92	328.43	328.92	7215.0
2023-10-27 05:00:00	DIA	ETF	328.75	328.75	328.75	328.75	300.0

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

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