PREVIEW / etf_1hour / 2022-07-27

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-07-27.parquet
  size:    436 KB
  rows:    15,923

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
2022-07-27 04:00:00	SPY	ETF	394.5	395.42	394.28	395.04	63898.0
2022-07-27 05:00:00	SPY	ETF	394.89	395.15	394.5	394.57	29271.0
2022-07-27 06:00:00	SPY	ETF	394.41	394.51	394.1	394.4	108620.0
2022-07-27 07:00:00	SPY	ETF	394.41	394.41	393.93	393.99	180785.0
2022-07-27 08:00:00	SPY	ETF	394.03	395.3604	393.94	394.6	189679.0
2022-07-27 09:00:00	SPY	ETF	394.61	395.699	394.05	395.33	4637645.0
2022-07-27 10:00:00	SPY	ETF	395.31	396.16	394.96	396.12	4981884.0
2022-07-27 11:00:00	SPY	ETF	396.14	396.87	395.79	396.65	4257370.0
2022-07-27 12:00:00	SPY	ETF	396.65	397.07	396.0	396.03	3540547.0
2022-07-27 13:00:00	SPY	ETF	396.02	396.545	395.72	396.31	3111239.0
2022-07-27 14:00:00	SPY	ETF	396.34	400.85	395.47	399.86	16218697.0
2022-07-27 15:00:00	SPY	ETF	399.87	402.88	399.49	401.0	20271335.0
2022-07-27 16:00:00	SPY	ETF	401.0	401.1	400.03	400.66	4797152.0
2022-07-27 17:00:00	SPY	ETF	400.64	400.79	400.5	400.59	72909.0
2022-07-27 18:00:00	SPY	ETF	400.68	400.77	400.44	400.49	99716.0
2022-07-27 19:00:00	SPY	ETF	400.58	400.83	400.4	400.5	47000.0
2022-07-27 04:00:00	QQQ	ETF	299.0	299.79	298.9	299.37	144957.0
2022-07-27 05:00:00	QQQ	ETF	299.32	299.38	298.8	298.87	73161.0
2022-07-27 06:00:00	QQQ	ETF	298.94	298.94	298.4	298.87	42076.0
2022-07-27 07:00:00	QQQ	ETF	298.8	298.86	298.14	298.26	160451.0
2022-07-27 08:00:00	QQQ	ETF	298.7591	299.5804	294.59	298.93	486114.0
2022-07-27 09:00:00	QQQ	ETF	298.93	301.48	298.46	301.11	5511592.0
2022-07-27 10:00:00	QQQ	ETF	301.11	302.28	300.78	302.0748	5297965.0
2022-07-27 11:00:00	QQQ	ETF	302.06	302.63	301.6	302.42	4244287.0
2022-07-27 12:00:00	QQQ	ETF	302.41	303.27	302.09	302.17	3099245.0
2022-07-27 13:00:00	QQQ	ETF	302.155	302.69	301.85	302.385	3062399.0
2022-07-27 14:00:00	QQQ	ETF	302.43	306.63	301.57	305.85	12892024.0
2022-07-27 15:00:00	QQQ	ETF	305.89	308.54	305.42	306.74	15716950.0
2022-07-27 16:00:00	QQQ	ETF	306.75	306.81	304.82	305.9	2895428.0
2022-07-27 17:00:00	QQQ	ETF	305.81	306.05	305.6	305.84	130943.0
2022-07-27 18:00:00	QQQ	ETF	305.84	305.91	305.6	305.72	159183.0
2022-07-27 19:00:00	QQQ	ETF	305.8	306.12	305.68	305.76	130333.0
2022-07-27 04:00:00	IWM	ETF	180.38	180.79	180.37	180.54	25268.0
2022-07-27 05:00:00	IWM	ETF	180.5	180.65	180.38	180.49	12100.0
2022-07-27 06:00:00	IWM	ETF	180.48	180.48	180.16	180.36	7133.0
2022-07-27 07:00:00	IWM	ETF	180.37	180.41	180.15	180.27	35791.0
2022-07-27 08:00:00	IWM	ETF	180.33	180.64	180.23	180.6	70453.0
2022-07-27 09:00:00	IWM	ETF	180.6	180.94	180.04	180.17	2330994.0
2022-07-27 10:00:00	IWM	ETF	180.18	181.19	180.0	181.13	1968613.0
2022-07-27 11:00:00	IWM	ETF	181.13	181.42	180.86	181.04	1183941.0
2022-07-27 12:00:00	IWM	ETF	181.05	181.16	180.5816	180.63	990727.0
2022-07-27 13:00:00	IWM	ETF	180.61	181.2	180.46	181.13	1089951.0
2022-07-27 14:00:00	IWM	ETF	181.15	183.25	180.44	182.81	4043057.0
2022-07-27 15:00:00	IWM	ETF	182.84	184.25	182.605	183.35	4474598.0
2022-07-27 16:00:00	IWM	ETF	183.41	183.58	183.0	183.52	1140086.0
2022-07-27 17:00:00	IWM	ETF	183.7	183.88	183.42	183.66	35071.0
2022-07-27 18:00:00	IWM	ETF	183.65	183.68	183.41	183.49	56426.0
2022-07-27 19:00:00	IWM	ETF	183.51	183.59	183.1	183.31	34886.0
2022-07-27 04:00:00	DIA	ETF	319.68	319.68	319.29	319.29	3170.0
2022-07-27 05:00:00	DIA	ETF	319.35	319.47	319.1	319.1	2999.0

> showing 50 of 15,923 rows — these rows as CSV

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