PREVIEW / etf_1hour / 2023-06-12

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-06-12.parquet
  size:    481 KB
  rows:    17,303

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-06-12 04:00:00	SPY	ETF	431.34	431.68	431.01	431.64	39983.0
2023-06-12 05:00:00	SPY	ETF	431.57	431.73	430.92	431.08	21715.0
2023-06-12 06:00:00	SPY	ETF	431.05	431.05	430.43	430.8	39239.0
2023-06-12 07:00:00	SPY	ETF	430.7	431.26	430.61	431.13	103560.0
2023-06-12 08:00:00	SPY	ETF	431.03	431.7096	430.36	431.26	163832.0
2023-06-12 09:00:00	SPY	ETF	431.3	431.35	430.29	430.97	4870486.0
2023-06-12 10:00:00	SPY	ETF	430.98	431.0	430.17	430.51	7005019.0
2023-06-12 11:00:00	SPY	ETF	430.51	431.21	430.34	431.1	5107469.0
2023-06-12 12:00:00	SPY	ETF	431.11	431.54	430.99	431.455	4228509.0
2023-06-12 13:00:00	SPY	ETF	431.45	431.83	431.16	431.79	4428377.0
2023-06-12 14:00:00	SPY	ETF	431.785	432.57	431.58	432.5119	5330916.0
2023-06-12 15:00:00	SPY	ETF	432.52	433.88	432.41	433.79	19722531.0
2023-06-12 16:00:00	SPY	ETF	433.79	434.06	433.28	434.04	3481341.0
2023-06-12 17:00:00	SPY	ETF	434.02	434.06	433.8	433.94	82040.0
2023-06-12 18:00:00	SPY	ETF	433.91	434.24	433.78	434.15	85303.0
2023-06-12 19:00:00	SPY	ETF	434.19	434.19	433.73	433.9	78548.0
2023-06-12 04:00:00	QQQ	ETF	356.2	356.6	355.81	356.6	27277.0
2023-06-12 05:00:00	QQQ	ETF	356.54	356.86	356.1	356.24	29364.0
2023-06-12 06:00:00	QQQ	ETF	356.25	356.25	355.65	356.02	38026.0
2023-06-12 07:00:00	QQQ	ETF	356.01	356.41	355.88	356.33	83858.0
2023-06-12 08:00:00	QQQ	ETF	356.0119	356.8196	354.765	356.44	218510.0
2023-06-12 09:00:00	QQQ	ETF	356.5	356.53	355.64	355.96	4256200.0
2023-06-12 10:00:00	QQQ	ETF	355.97	356.854	355.2	356.0014	4800174.0
2023-06-12 11:00:00	QQQ	ETF	356.01	357.42	355.67	357.28	3187005.0
2023-06-12 12:00:00	QQQ	ETF	357.28	357.5	356.82	357.35	2134773.0
2023-06-12 13:00:00	QQQ	ETF	357.338	358.35	357.2407	358.32	2657846.0
2023-06-12 14:00:00	QQQ	ETF	358.32	359.29	358.05	359.23	2648951.0
2023-06-12 15:00:00	QQQ	ETF	359.2396	360.59	358.98	360.53	9089875.0
2023-06-12 16:00:00	QQQ	ETF	360.53	361.11	360.3	361.11	1816021.0
2023-06-12 17:00:00	QQQ	ETF	361.12	361.13	360.49	360.93	443331.0
2023-06-12 18:00:00	QQQ	ETF	360.92	361.41	360.83	361.41	89711.0
2023-06-12 19:00:00	QQQ	ETF	361.28	361.39	360.85	360.99	116320.0
2023-06-12 04:00:00	IWM	ETF	186.02	186.52	185.57	185.74	14959.0
2023-06-12 05:00:00	IWM	ETF	185.77	185.92	185.53	185.56	12826.0
2023-06-12 06:00:00	IWM	ETF	185.36	185.42	185.05	185.38	34453.0
2023-06-12 07:00:00	IWM	ETF	185.27	185.67	185.21	185.53	56843.0
2023-06-12 08:00:00	IWM	ETF	185.37	185.6404	185.0204	185.55	103918.0
2023-06-12 09:00:00	IWM	ETF	185.53	186.22	184.22	186.21	3445632.0
2023-06-12 10:00:00	IWM	ETF	186.2	186.675	185.21	185.77	3671518.0
2023-06-12 11:00:00	IWM	ETF	185.775	186.39	185.21	185.555	2259062.0
2023-06-12 12:00:00	IWM	ETF	185.55	185.96	185.51	185.795	1381698.0
2023-06-12 13:00:00	IWM	ETF	185.8	185.89	185.085	185.63	1689819.0
2023-06-12 14:00:00	IWM	ETF	185.64	185.99	185.48	185.79	2468981.0
2023-06-12 15:00:00	IWM	ETF	185.8	186.41	185.6	185.85	5110612.0
2023-06-12 16:00:00	IWM	ETF	185.8	186.24	185.7	186.15	842340.0
2023-06-12 17:00:00	IWM	ETF	186.13	186.25	185.95	186.15	8921.0
2023-06-12 18:00:00	IWM	ETF	186.11	186.35	186.05	186.35	18458.0
2023-06-12 19:00:00	IWM	ETF	186.35	186.46	186.02	186.08	16514.0
2023-06-12 04:00:00	DIA	ETF	340.26	340.26	339.99	339.99	243.0
2023-06-12 06:00:00	DIA	ETF	339.33	339.33	339.33	339.33	1600.0

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

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