PREVIEW / etf_1hour / 2023-05-05

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-05-05.parquet
  size:    461 KB
  rows:    16,822

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-05-05 04:00:00	SPY	ETF	406.48	407.11	406.25	407.05	28796.0
2023-05-05 05:00:00	SPY	ETF	407.02	407.26	406.76	407.15	31269.0
2023-05-05 06:00:00	SPY	ETF	407.22	407.75	407.22	407.5	62381.0
2023-05-05 07:00:00	SPY	ETF	407.55	408.22	407.47	407.98	188887.0
2023-05-05 08:00:00	SPY	ETF	407.58	408.76	406.54	407.95	1522512.0
2023-05-05 09:00:00	SPY	ETF	407.97	410.34	407.97	410.115	8496833.0
2023-05-05 10:00:00	SPY	ETF	410.12	411.64	410.05	411.06	10449783.0
2023-05-05 11:00:00	SPY	ETF	411.07	411.47	410.66	411.01	5707452.0
2023-05-05 12:00:00	SPY	ETF	411.02	411.11	410.2	411.089	4537883.0
2023-05-05 13:00:00	SPY	ETF	411.09	411.97	411.08	411.8599	4381476.0
2023-05-05 14:00:00	SPY	ETF	411.86	413.72	411.8	413.256	7420776.0
2023-05-05 15:00:00	SPY	ETF	413.26	413.51	412.17	412.61	18077754.0
2023-05-05 16:00:00	SPY	ETF	412.61	412.71	412.15	412.36	5482915.0
2023-05-05 17:00:00	SPY	ETF	412.35	412.45	412.1	412.45	49073.0
2023-05-05 18:00:00	SPY	ETF	412.36	412.4	412.08	412.08	36160.0
2023-05-05 19:00:00	SPY	ETF	412.1	412.27	412.1	412.2	6638.0
2023-05-05 04:00:00	QQQ	ETF	317.46	317.8	317.25	317.66	39182.0
2023-05-05 05:00:00	QQQ	ETF	317.72	318.1	317.61	317.98	37745.0
2023-05-05 06:00:00	QQQ	ETF	318.14	318.34	317.98	318.08	45162.0
2023-05-05 07:00:00	QQQ	ETF	318.06	318.47	318.03	318.35	115680.0
2023-05-05 08:00:00	QQQ	ETF	318.1699	318.75	316.92	317.85	1283660.0
2023-05-05 09:00:00	QQQ	ETF	317.87	319.76	317.8	319.71	6278454.0
2023-05-05 10:00:00	QQQ	ETF	319.71	321.78	319.71	321.33	7337845.0
2023-05-05 11:00:00	QQQ	ETF	321.34	321.69	320.92	321.3017	3565356.0
2023-05-05 12:00:00	QQQ	ETF	321.32	321.645	320.87	321.6	3318754.0
2023-05-05 13:00:00	QQQ	ETF	321.61	322.46	321.55	322.46	3402347.0
2023-05-05 14:00:00	QQQ	ETF	322.45	323.76	322.225	323.47	4646677.0
2023-05-05 15:00:00	QQQ	ETF	323.49	323.62	322.61	322.91	8650351.0
2023-05-05 16:00:00	QQQ	ETF	322.89	323.03	322.12	322.6399	2787953.0
2023-05-05 17:00:00	QQQ	ETF	322.63	322.89	322.43	322.62	221322.0
2023-05-05 18:00:00	QQQ	ETF	322.62	322.66	322.53	322.53	7951.0
2023-05-05 19:00:00	QQQ	ETF	322.53	322.7	322.53	322.65	14260.0
2023-05-05 04:00:00	IWM	ETF	171.02	171.56	170.91	171.56	6290.0
2023-05-05 05:00:00	IWM	ETF	171.47	171.47	171.29	171.44	11895.0
2023-05-05 06:00:00	IWM	ETF	171.51	171.94	171.46	171.79	74358.0
2023-05-05 07:00:00	IWM	ETF	171.87	172.34	171.78	172.01	112777.0
2023-05-05 08:00:00	IWM	ETF	171.9	172.87	171.04	172.58	452576.0
2023-05-05 09:00:00	IWM	ETF	172.58	174.19	172.58	173.42	4725597.0
2023-05-05 10:00:00	IWM	ETF	173.42	174.0	173.1	173.19	4088352.0
2023-05-05 11:00:00	IWM	ETF	173.2	173.98	173.19	173.83	2658581.0
2023-05-05 12:00:00	IWM	ETF	173.85	174.1	173.28	173.79	2145781.0
2023-05-05 13:00:00	IWM	ETF	173.79	174.03	173.68	173.93	1563677.0
2023-05-05 14:00:00	IWM	ETF	173.935	175.1	173.895	174.785	3822800.0
2023-05-05 15:00:00	IWM	ETF	174.79	174.895	174.35	174.49	5403802.0
2023-05-05 16:00:00	IWM	ETF	174.45	174.64	174.33	174.4	1550499.0
2023-05-05 17:00:00	IWM	ETF	174.39	174.55	174.33	174.55	205619.0
2023-05-05 18:00:00	IWM	ETF	174.51	174.51	174.35	174.43	12298.0
2023-05-05 19:00:00	IWM	ETF	174.36	174.6	174.36	174.6	10393.0
2023-05-05 04:00:00	DIA	ETF	332.47	332.47	332.47	332.47	200.0
2023-05-05 06:00:00	DIA	ETF	332.78	332.91	332.78	332.91	764.0

> showing 50 of 16,822 rows — these rows as CSV

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