PREVIEW / etf_1hour / 2022-07-18

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-07-18.parquet
  size:    449 KB
  rows:    16,295

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-18 04:00:00	SPY	ETF	388.24	389.45	386.71	389.35	37896.0
2022-07-18 05:00:00	SPY	ETF	389.35	389.37	388.6	388.76	29811.0
2022-07-18 06:00:00	SPY	ETF	388.75	389.05	388.62	388.77	28368.0
2022-07-18 07:00:00	SPY	ETF	388.73	389.29	388.46	388.8	189556.0
2022-07-18 08:00:00	SPY	ETF	388.5001	389.29	385.8	388.2	366501.0
2022-07-18 09:00:00	SPY	ETF	388.18	389.09	387.67	388.3	6314846.0
2022-07-18 10:00:00	SPY	ETF	388.28	388.7	387.2	387.94	5234115.0
2022-07-18 11:00:00	SPY	ETF	387.94	388.45	387.3	388.3606	4159998.0
2022-07-18 12:00:00	SPY	ETF	388.36	388.4	387.0	387.155	3157291.0
2022-07-18 13:00:00	SPY	ETF	387.15	387.3594	384.33	384.5171	5422213.0
2022-07-18 14:00:00	SPY	ETF	384.51	385.12	382.97	383.12	6747895.0
2022-07-18 15:00:00	SPY	ETF	383.12	383.99	380.66	381.99	12577094.0
2022-07-18 16:00:00	SPY	ETF	382.0	382.49	381.79	382.41	4006613.0
2022-07-18 17:00:00	SPY	ETF	382.26	382.42	382.14	382.39	85076.0
2022-07-18 18:00:00	SPY	ETF	382.4	382.68	382.05	382.53	60547.0
2022-07-18 19:00:00	SPY	ETF	382.53	383.03	382.2	383.01	91248.0
2022-07-18 04:00:00	QQQ	ETF	294.02	296.0	293.04	295.79	133616.0
2022-07-18 05:00:00	QQQ	ETF	295.79	295.8	295.17	295.31	76610.0
2022-07-18 06:00:00	QQQ	ETF	295.2	295.46	295.1	295.2	86580.0
2022-07-18 07:00:00	QQQ	ETF	295.16	295.62	294.9	295.28	252318.0
2022-07-18 08:00:00	QQQ	ETF	295.3697	295.7304	293.8	294.75	636751.0
2022-07-18 09:00:00	QQQ	ETF	294.73	296.16	293.85	295.6	6133150.0
2022-07-18 10:00:00	QQQ	ETF	295.57	296.09	293.97	294.96	5462125.0
2022-07-18 11:00:00	QQQ	ETF	294.98	296.08	294.59	296.0095	3324273.0
2022-07-18 12:00:00	QQQ	ETF	296.0287	296.1	295.03	295.125	2178352.0
2022-07-18 13:00:00	QQQ	ETF	295.1263	295.28	291.01	291.38	5672367.0
2022-07-18 14:00:00	QQQ	ETF	291.37	292.06	289.78	289.9	6656034.0
2022-07-18 15:00:00	QQQ	ETF	289.91	290.83	288.2	289.41	9149344.0
2022-07-18 16:00:00	QQQ	ETF	289.4	289.7	289.21	289.62	7005247.0
2022-07-18 17:00:00	QQQ	ETF	289.65	289.66	289.38	289.38	104168.0
2022-07-18 18:00:00	QQQ	ETF	289.43	289.89	289.28	289.8	212254.0
2022-07-18 19:00:00	QQQ	ETF	289.8	290.25	289.5	290.2	217776.0
2022-07-18 04:00:00	IWM	ETF	174.89	175.48	174.81	175.47	38019.0
2022-07-18 05:00:00	IWM	ETF	175.45	175.45	174.94	175.03	31834.0
2022-07-18 06:00:00	IWM	ETF	175.0	175.16	174.93	174.99	16085.0
2022-07-18 07:00:00	IWM	ETF	174.9	175.29	174.85	175.03	61722.0
2022-07-18 08:00:00	IWM	ETF	175.25	175.25	174.31	174.78	187493.0
2022-07-18 09:00:00	IWM	ETF	174.8	176.2893	174.7	175.94	3095454.0
2022-07-18 10:00:00	IWM	ETF	175.95	176.03	175.05	175.7399	2278702.0
2022-07-18 11:00:00	IWM	ETF	175.74	176.14	175.51	175.9	1344357.0
2022-07-18 12:00:00	IWM	ETF	175.905	175.93	175.12	175.135	945871.0
2022-07-18 13:00:00	IWM	ETF	175.145	175.38	173.85	173.9	1249829.0
2022-07-18 14:00:00	IWM	ETF	173.89	174.07	172.91	173.045	1741420.0
2022-07-18 15:00:00	IWM	ETF	173.03	173.5	172.06	172.59	3549170.0
2022-07-18 16:00:00	IWM	ETF	172.6	172.87	172.47	172.84	3877061.0
2022-07-18 17:00:00	IWM	ETF	172.8	172.89	172.67	172.89	5846.0
2022-07-18 18:00:00	IWM	ETF	172.88	172.96	172.7	172.82	72511.0
2022-07-18 19:00:00	IWM	ETF	172.8	173.11	172.7	172.99	34638.0
2022-07-18 04:00:00	DIA	ETF	312.97	315.6	312.97	315.6	1901.0
2022-07-18 05:00:00	DIA	ETF	315.19	315.19	315.19	315.19	900.0

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

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