PREVIEW / etf_1hour / 2023-03-13

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-13.parquet
  size:    481 KB
  rows:    18,125

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-03-13 04:00:00	SPY	ETF	391.75	391.78	388.0	388.23	245536.0
2023-03-13 05:00:00	SPY	ETF	388.09	388.27	384.83	385.89	325058.0
2023-03-13 06:00:00	SPY	ETF	385.96	388.2	385.3	387.73	465614.0
2023-03-13 07:00:00	SPY	ETF	387.61	389.19	385.78	386.16	1336191.0
2023-03-13 08:00:00	SPY	ETF	387.9399	393.25	380.49	383.04	4131742.0
2023-03-13 09:00:00	SPY	ETF	383.12	386.28	380.65	385.5664	21810330.0
2023-03-13 10:00:00	SPY	ETF	385.55	387.85	383.65	387.7	21318295.0
2023-03-13 11:00:00	SPY	ETF	387.72	389.86	387.12	388.86	15859452.0
2023-03-13 12:00:00	SPY	ETF	388.85	390.39	386.1	386.62	10688667.0
2023-03-13 13:00:00	SPY	ETF	386.61	388.11	385.36	387.83	9768342.0
2023-03-13 14:00:00	SPY	ETF	387.88	389.495	387.67	388.48	8719508.0
2023-03-13 15:00:00	SPY	ETF	388.49	388.9	385.045	385.29	18499130.0
2023-03-13 16:00:00	SPY	ETF	385.28	386.21	385.11	386.0	4294240.0
2023-03-13 17:00:00	SPY	ETF	385.93	386.08	385.36	386.03	49674.0
2023-03-13 18:00:00	SPY	ETF	386.02	386.65	385.317	386.62	147047.0
2023-03-13 19:00:00	SPY	ETF	386.58	386.59	385.71	385.73	94435.0
2023-03-13 04:00:00	QQQ	ETF	293.26	297.1	290.56	290.67	289177.0
2023-03-13 05:00:00	QQQ	ETF	290.67	291.23	288.96	289.8	449661.0
2023-03-13 06:00:00	QQQ	ETF	290.17	292.06	289.22	291.78	210596.0
2023-03-13 07:00:00	QQQ	ETF	291.51	292.48	290.11	290.68	708373.0
2023-03-13 08:00:00	QQQ	ETF	290.68	294.68	284.73	287.08	2177335.0
2023-03-13 09:00:00	QQQ	ETF	287.08	290.485	285.19	289.68	12405976.0
2023-03-13 10:00:00	QQQ	ETF	289.64	291.37	288.6	291.1001	13855680.0
2023-03-13 11:00:00	QQQ	ETF	291.1001	293.93	290.77	293.28	12291962.0
2023-03-13 12:00:00	QQQ	ETF	293.29	294.33	291.44	291.85	8055616.0
2023-03-13 13:00:00	QQQ	ETF	291.84	292.81	290.72	292.58	7088495.0
2023-03-13 14:00:00	QQQ	ETF	292.59	294.47	292.41	293.53	7128302.0
2023-03-13 15:00:00	QQQ	ETF	293.52	293.95	290.65	290.72	10910923.0
2023-03-13 16:00:00	QQQ	ETF	290.71	291.36	290.54	291.15	1282149.0
2023-03-13 17:00:00	QQQ	ETF	291.2	291.34	290.69	291.32	380319.0
2023-03-13 18:00:00	QQQ	ETF	291.32	291.67	290.69	291.59	119230.0
2023-03-13 19:00:00	QQQ	ETF	291.65	291.77	291.0199	291.14	79366.0
2023-03-13 04:00:00	IWM	ETF	180.07	180.07	176.28	176.33	91560.0
2023-03-13 05:00:00	IWM	ETF	176.29	176.42	174.43	174.95	99022.0
2023-03-13 06:00:00	IWM	ETF	175.14	176.5	174.81	176.29	167575.0
2023-03-13 07:00:00	IWM	ETF	176.18	176.95	174.78	175.21	443799.0
2023-03-13 08:00:00	IWM	ETF	176.42	179.29	171.65	172.99	1364944.0
2023-03-13 09:00:00	IWM	ETF	173.07	174.2	171.07	173.69	9233042.0
2023-03-13 10:00:00	IWM	ETF	173.7	174.97	172.21	174.74	11424109.0
2023-03-13 11:00:00	IWM	ETF	174.75	176.36	174.39	175.54	8294905.0
2023-03-13 12:00:00	IWM	ETF	175.53	176.4	173.2	173.59	8422163.0
2023-03-13 13:00:00	IWM	ETF	173.59	174.495	172.92	174.38	4469135.0
2023-03-13 14:00:00	IWM	ETF	174.39	175.27	174.12	174.56	4372445.0
2023-03-13 15:00:00	IWM	ETF	174.55	174.72	173.13	173.26	9064157.0
2023-03-13 16:00:00	IWM	ETF	173.25	173.93	173.24	173.63	4031685.0
2023-03-13 17:00:00	IWM	ETF	173.53	173.75	173.31	173.72	338850.0
2023-03-13 18:00:00	IWM	ETF	173.71	174.08	173.2261	174.0	351350.0
2023-03-13 19:00:00	IWM	ETF	174.03	174.06	173.51	173.62	62400.0
2023-03-13 04:00:00	DIA	ETF	322.61	323.2	320.9	321.03	10911.0
2023-03-13 05:00:00	DIA	ETF	320.62	320.69	317.98	318.8	10634.0

> showing 50 of 18,125 rows — these rows as CSV

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