PREVIEW / etf_1hour / 2022-05-17

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-05-17.parquet
  size:    464 KB
  rows:    16,661

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-05-17 04:00:00	SPY	ETF	402.02	406.6	402.02	405.8	124322.0
2022-05-17 05:00:00	SPY	ETF	405.8	407.43	405.75	407.24	72038.0
2022-05-17 06:00:00	SPY	ETF	407.27	407.87	406.55	406.65	232166.0
2022-05-17 07:00:00	SPY	ETF	406.55	407.08	405.9	405.93	502151.0
2022-05-17 08:00:00	SPY	ETF	406.2075	407.53	400.84	406.2	810528.0
2022-05-17 09:00:00	SPY	ETF	406.22	406.78	404.4	405.195	7478800.0
2022-05-17 10:00:00	SPY	ETF	405.18	406.15	402.5824	403.79	8707658.0
2022-05-17 11:00:00	SPY	ETF	403.81	406.03	403.65	405.4599	5889514.0
2022-05-17 12:00:00	SPY	ETF	405.45	406.92	404.59	406.2354	5362831.0
2022-05-17 13:00:00	SPY	ETF	406.24	407.15	405.46	406.31	5054241.0
2022-05-17 14:00:00	SPY	ETF	406.3	407.754	403.5	407.07	11954264.0
2022-05-17 15:00:00	SPY	ETF	407.1	408.57	406.79	408.27	14032375.0
2022-05-17 16:00:00	SPY	ETF	408.25	408.73	407.4	408.66	3536987.0
2022-05-17 17:00:00	SPY	ETF	408.66	408.75	408.6	408.67	47771.0
2022-05-17 18:00:00	SPY	ETF	408.75	409.1	408.66	408.67	82135.0
2022-05-17 19:00:00	SPY	ETF	408.67	408.71	408.15	408.19	62720.0
2022-05-17 04:00:00	QQQ	ETF	301.36	305.36	301.36	304.6	209749.0
2022-05-17 05:00:00	QQQ	ETF	304.51	305.6	304.37	305.5	107058.0
2022-05-17 06:00:00	QQQ	ETF	305.47	305.73	304.32	304.32	178495.0
2022-05-17 07:00:00	QQQ	ETF	304.36	304.88	303.87	304.02	479941.0
2022-05-17 08:00:00	QQQ	ETF	304.06	305.5496	300.0	304.06	671228.0
2022-05-17 09:00:00	QQQ	ETF	304.07	305.54	303.02	303.35	6898410.0
2022-05-17 10:00:00	QQQ	ETF	303.32	304.51	300.55	301.39	7548527.0
2022-05-17 11:00:00	QQQ	ETF	301.37	304.44	301.135	303.86	5683884.0
2022-05-17 12:00:00	QQQ	ETF	303.86	304.69	302.96	303.85	3305413.0
2022-05-17 13:00:00	QQQ	ETF	303.845	304.9	303.12	304.2989	2926618.0
2022-05-17 14:00:00	QQQ	ETF	304.31	305.77	301.56	305.06	9254195.0
2022-05-17 15:00:00	QQQ	ETF	305.08	306.56	304.99	306.25	8437958.0
2022-05-17 16:00:00	QQQ	ETF	306.25	306.57	305.84	306.49	1813806.0
2022-05-17 17:00:00	QQQ	ETF	306.56	306.6	306.46	306.6	53780.0
2022-05-17 18:00:00	QQQ	ETF	306.62	306.94	306.41	306.43	131297.0
2022-05-17 19:00:00	QQQ	ETF	306.45	306.5	306.03	306.22	106418.0
2022-05-17 04:00:00	IWM	ETF	178.97	180.55	178.97	179.91	35937.0
2022-05-17 05:00:00	IWM	ETF	179.94	180.7	179.89	180.64	22887.0
2022-05-17 06:00:00	IWM	ETF	180.86	180.98	180.46	180.55	51302.0
2022-05-17 07:00:00	IWM	ETF	180.51	181.08	180.37	180.47	91130.0
2022-05-17 08:00:00	IWM	ETF	180.4899	180.93	178.33	180.5301	160605.0
2022-05-17 09:00:00	IWM	ETF	180.52	181.18	179.9	180.39	3869027.0
2022-05-17 10:00:00	IWM	ETF	180.4	180.95	178.99	179.88	3210439.0
2022-05-17 11:00:00	IWM	ETF	179.9	181.47	179.85	181.42	1799321.0
2022-05-17 12:00:00	IWM	ETF	181.42	181.87	180.96	181.71	1413168.0
2022-05-17 13:00:00	IWM	ETF	181.72	182.33	181.36	181.85	1274922.0
2022-05-17 14:00:00	IWM	ETF	181.86	182.54	180.69	182.22	3615172.0
2022-05-17 15:00:00	IWM	ETF	182.205	182.84	182.035	182.82	5164884.0
2022-05-17 16:00:00	IWM	ETF	182.81	182.95	182.4	182.64	2570429.0
2022-05-17 17:00:00	IWM	ETF	182.66	182.94	182.66	182.89	9073.0
2022-05-17 18:00:00	IWM	ETF	182.9	183.12	182.82	182.9	16512.0
2022-05-17 19:00:00	IWM	ETF	182.84	182.98	182.66	182.72	16670.0
2022-05-17 04:00:00	DIA	ETF	325.41	326.41	325.41	326.41	4456.0
2022-05-17 05:00:00	DIA	ETF	326.19	326.66	326.1	326.5	7976.0

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

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