PREVIEW / etf_1hour / 2022-09-21

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-09-21.parquet
  size:    449 KB
  rows:    16,647

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-09-21 04:00:00	SPY	ETF	383.96	384.65	383.75	384.39	25785.0
2022-09-21 05:00:00	SPY	ETF	384.41	385.32	384.04	385.21	31578.0
2022-09-21 06:00:00	SPY	ETF	385.24	385.31	384.16	384.91	164333.0
2022-09-21 07:00:00	SPY	ETF	384.96	385.79	384.64	385.51	443388.0
2022-09-21 08:00:00	SPY	ETF	384.85	386.44	382.79	386.05	432571.0
2022-09-21 09:00:00	SPY	ETF	386.09	386.88	385.42	386.24	5390323.0
2022-09-21 10:00:00	SPY	ETF	386.23	387.26	385.57	385.99	5598344.0
2022-09-21 11:00:00	SPY	ETF	385.985	386.38	385.4	386.05	3446748.0
2022-09-21 12:00:00	SPY	ETF	386.03	386.85	385.81	385.89	2647037.0
2022-09-21 13:00:00	SPY	ETF	385.91	387.33	385.59	387.1	3395755.0
2022-09-21 14:00:00	SPY	ETF	387.1	389.31	380.25	387.5	30948206.0
2022-09-21 15:00:00	SPY	ETF	387.51	388.06	377.39	377.39	26875073.0
2022-09-21 16:00:00	SPY	ETF	377.4	378.6	376.2	376.63	4624218.0
2022-09-21 17:00:00	SPY	ETF	376.65	377.39	376.4	376.56	174352.0
2022-09-21 18:00:00	SPY	ETF	376.51	376.97	375.29	375.45	232421.0
2022-09-21 19:00:00	SPY	ETF	375.43	375.65	375.0	375.1	246875.0
2022-09-21 04:00:00	QQQ	ETF	288.7	288.98	288.17	288.74	33751.0
2022-09-21 05:00:00	QQQ	ETF	288.69	289.17	288.21	288.98	34353.0
2022-09-21 06:00:00	QQQ	ETF	289.04	289.04	288.25	288.79	58384.0
2022-09-21 07:00:00	QQQ	ETF	288.76	289.28	288.45	289.09	197014.0
2022-09-21 08:00:00	QQQ	ETF	288.71	290.22	287.74	289.89	415920.0
2022-09-21 09:00:00	QQQ	ETF	289.97	290.48	289.025	289.84	4712755.0
2022-09-21 10:00:00	QQQ	ETF	289.83	290.56	289.13	289.5	5084019.0
2022-09-21 11:00:00	QQQ	ETF	289.52	290.05	289.08	289.81	2184840.0
2022-09-21 12:00:00	QQQ	ETF	289.79	290.81	289.56	290.1198	2344285.0
2022-09-21 13:00:00	QQQ	ETF	290.13	291.88	289.73	291.3015	2938632.0
2022-09-21 14:00:00	QQQ	ETF	291.355	293.95	284.85	292.4	24802109.0
2022-09-21 15:00:00	QQQ	ETF	292.4	292.9	283.42	283.42	19091573.0
2022-09-21 16:00:00	QQQ	ETF	283.42	283.56	282.07	282.51	2828825.0
2022-09-21 17:00:00	QQQ	ETF	282.5	283.56	282.33	282.54	443290.0
2022-09-21 18:00:00	QQQ	ETF	282.45	282.81	281.41	281.56	335098.0
2022-09-21 19:00:00	QQQ	ETF	281.51	281.75	281.15	281.23	228991.0
2022-09-21 04:00:00	IWM	ETF	178.3	178.7	178.16	178.7	11050.0
2022-09-21 05:00:00	IWM	ETF	178.58	179.15	178.49	179.06	11957.0
2022-09-21 06:00:00	IWM	ETF	179.08	179.18	178.55	179.05	47488.0
2022-09-21 07:00:00	IWM	ETF	179.01	179.33	178.85	179.21	30112.0
2022-09-21 08:00:00	IWM	ETF	179.2	179.72	178.85	179.34	111343.0
2022-09-21 09:00:00	IWM	ETF	179.39	179.52	178.0603	179.0	1615525.0
2022-09-21 10:00:00	IWM	ETF	178.98	179.92	178.5	179.23	1748767.0
2022-09-21 11:00:00	IWM	ETF	179.245	179.7925	178.94	179.51	993655.0
2022-09-21 12:00:00	IWM	ETF	179.5	179.68	179.015	179.035	659855.0
2022-09-21 13:00:00	IWM	ETF	179.03	179.9	178.82	179.67	1310549.0
2022-09-21 14:00:00	IWM	ETF	179.72	181.1	176.18	180.28	6701999.0
2022-09-21 15:00:00	IWM	ETF	180.35	180.54	175.33	175.34	6305626.0
2022-09-21 16:00:00	IWM	ETF	175.34	175.45	174.74	175.03	915645.0
2022-09-21 17:00:00	IWM	ETF	175.06	175.34	174.76	174.79	563841.0
2022-09-21 18:00:00	IWM	ETF	174.84	175.1	174.15	174.3	44638.0
2022-09-21 19:00:00	IWM	ETF	174.27	174.4	174.03	174.2	33592.0
2022-09-21 04:00:00	DIA	ETF	306.74	307.39	306.74	307.39	300.0
2022-09-21 05:00:00	DIA	ETF	307.55	307.9	307.53	307.9	1600.0

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

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