PREVIEW / etf_1hour / 2023-03-10

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-10.parquet
  size:    474 KB
  rows:    17,687

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-10 04:00:00	SPY	ETF	389.34	390.76	389.25	389.92	72977.0
2023-03-10 05:00:00	SPY	ETF	389.91	390.99	389.86	390.21	125085.0
2023-03-10 06:00:00	SPY	ETF	390.26	391.67	389.72	391.09	320691.0
2023-03-10 07:00:00	SPY	ETF	391.06	391.42	390.5	391.01	463537.0
2023-03-10 08:00:00	SPY	ETF	391.0	393.8	388.12	392.58	4690680.0
2023-03-10 09:00:00	SPY	ETF	392.62	392.99	387.48	389.15	24077684.0
2023-03-10 10:00:00	SPY	ETF	389.18	391.38	388.4	391.265	20535001.0
2023-03-10 11:00:00	SPY	ETF	391.265	393.16	389.7	389.87	17716483.0
2023-03-10 12:00:00	SPY	ETF	389.87	390.31	387.7	387.835	12266041.0
2023-03-10 13:00:00	SPY	ETF	387.84	388.43	384.32	384.91	14132366.0
2023-03-10 14:00:00	SPY	ETF	384.91	388.42	384.86	387.44	17933553.0
2023-03-10 15:00:00	SPY	ETF	387.46	387.95	384.66	385.92	25737289.0
2023-03-10 16:00:00	SPY	ETF	385.92	391.6112	385.62	387.51	8900087.0
2023-03-10 17:00:00	SPY	ETF	387.59	387.65	386.9	386.95	404755.0
2023-03-10 18:00:00	SPY	ETF	386.9	387.01	386.75	386.78	77987.0
2023-03-10 19:00:00	SPY	ETF	386.78	387.22	386.6	387.06	67312.0
2023-03-10 04:00:00	QQQ	ETF	291.67	292.92	291.48	292.41	94496.0
2023-03-10 05:00:00	QQQ	ETF	292.3	292.96	292.24	292.37	43705.0
2023-03-10 06:00:00	QQQ	ETF	292.51	293.63	292.03	293.0	170890.0
2023-03-10 07:00:00	QQQ	ETF	293.0	293.12	292.16	292.62	345908.0
2023-03-10 08:00:00	QQQ	ETF	292.62	295.05	290.67	294.11	3428884.0
2023-03-10 09:00:00	QQQ	ETF	294.15	294.54	289.13	290.1969	12601409.0
2023-03-10 10:00:00	QQQ	ETF	290.2	292.86	289.96	292.74	11577988.0
2023-03-10 11:00:00	QQQ	ETF	292.75	294.35	291.55	291.71	9928552.0
2023-03-10 12:00:00	QQQ	ETF	291.75	292.16	289.825	289.94	6755470.0
2023-03-10 13:00:00	QQQ	ETF	289.95	290.44	287.46	287.76	8171307.0
2023-03-10 14:00:00	QQQ	ETF	287.77	290.22	287.7	289.51	10220337.0
2023-03-10 15:00:00	QQQ	ETF	289.51	290.02	287.38	288.5	13898016.0
2023-03-10 16:00:00	QQQ	ETF	288.51	289.87	288.0781	289.8	2270195.0
2023-03-10 17:00:00	QQQ	ETF	289.66	289.8	288.55	289.45	301050.0
2023-03-10 18:00:00	QQQ	ETF	289.45	289.5	289.24	289.24	34827.0
2023-03-10 19:00:00	QQQ	ETF	289.23	289.4	289.06	289.29	38145.0
2023-03-10 04:00:00	IWM	ETF	180.02	181.01	180.0	180.49	24448.0
2023-03-10 05:00:00	IWM	ETF	180.53	181.11	180.53	180.57	66814.0
2023-03-10 06:00:00	IWM	ETF	180.69	181.13	180.26	180.82	76478.0
2023-03-10 07:00:00	IWM	ETF	180.84	180.97	180.49	180.7	136910.0
2023-03-10 08:00:00	IWM	ETF	180.85	182.51	179.53	182.06	716490.0
2023-03-10 09:00:00	IWM	ETF	182.0	182.16	177.24	178.28	7472693.0
2023-03-10 10:00:00	IWM	ETF	178.29	179.3	177.44	179.1	8364660.0
2023-03-10 11:00:00	IWM	ETF	179.095	180.35	178.32	178.35	6156588.0
2023-03-10 12:00:00	IWM	ETF	178.36	178.56	176.33	176.365	7090885.0
2023-03-10 13:00:00	IWM	ETF	176.39	176.83	174.255	174.695	7113143.0
2023-03-10 14:00:00	IWM	ETF	174.695	176.93	174.62	176.39	6626538.0
2023-03-10 15:00:00	IWM	ETF	176.38	176.66	175.14	176.1	9152297.0
2023-03-10 16:00:00	IWM	ETF	176.18	177.0	175.97	176.89	1788351.0
2023-03-10 17:00:00	IWM	ETF	176.74	176.74	176.25	176.32	47444.0
2023-03-10 18:00:00	IWM	ETF	176.29	176.36	176.17	176.18	29759.0
2023-03-10 19:00:00	IWM	ETF	176.17	176.72	176.17	176.55	50901.0
2023-03-10 04:00:00	DIA	ETF	321.08	321.91	321.08	321.77	4691.0
2023-03-10 05:00:00	DIA	ETF	322.11	322.11	322.06	322.06	2280.0

> showing 50 of 17,687 rows — these rows as CSV

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