PREVIEW / etf_1hour / 2023-11-16

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-11-16.parquet
  size:    496 KB
  rows:    18,401

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-11-16 04:00:00	SPY	ETF	449.69	450.07	449.41	449.51	62749.0
2023-11-16 05:00:00	SPY	ETF	449.52	449.94	449.42	449.66	11139.0
2023-11-16 06:00:00	SPY	ETF	449.7	449.84	449.49	449.71	22750.0
2023-11-16 07:00:00	SPY	ETF	449.78	449.78	448.87	448.95	239978.0
2023-11-16 08:00:00	SPY	ETF	449.4901	450.18	448.75	450.12	673347.0
2023-11-16 09:00:00	SPY	ETF	450.14	450.47	448.92	450.355	4335673.0
2023-11-16 10:00:00	SPY	ETF	450.37	450.56	448.76	449.025	8774743.0
2023-11-16 11:00:00	SPY	ETF	449.03	449.2799	448.12	448.749	7650973.0
2023-11-16 12:00:00	SPY	ETF	448.76	449.915	448.63	449.4701	5391161.0
2023-11-16 13:00:00	SPY	ETF	449.48	449.61	448.58	448.9297	4847606.0
2023-11-16 14:00:00	SPY	ETF	448.93	449.84	448.79	449.58	5234884.0
2023-11-16 15:00:00	SPY	ETF	449.58	450.32	449.335	450.21	12083972.0
2023-11-16 16:00:00	SPY	ETF	450.21	450.85	450.15	450.76	2619522.0
2023-11-16 17:00:00	SPY	ETF	450.75	450.76	450.62	450.63	61423.0
2023-11-16 18:00:00	SPY	ETF	450.67	450.67	450.23	450.38	105916.0
2023-11-16 19:00:00	SPY	ETF	450.38	450.61	450.3	450.54	38848.0
2023-11-16 04:00:00	QQQ	ETF	385.0	385.37	384.76	384.99	63130.0
2023-11-16 05:00:00	QQQ	ETF	384.89	385.3	384.89	385.16	27073.0
2023-11-16 06:00:00	QQQ	ETF	385.18	385.26	384.88	385.06	34570.0
2023-11-16 07:00:00	QQQ	ETF	385.05	385.09	384.34	384.45	210056.0
2023-11-16 08:00:00	QQQ	ETF	384.43	385.909	384.15	385.63	666040.0
2023-11-16 09:00:00	QQQ	ETF	385.57	385.985	384.21	385.7701	5597931.0
2023-11-16 10:00:00	QQQ	ETF	385.78	386.17	383.98	384.5201	5928411.0
2023-11-16 11:00:00	QQQ	ETF	384.53	384.85	383.56	384.6	5749214.0
2023-11-16 12:00:00	QQQ	ETF	384.61	386.09	384.47	385.63	4005398.0
2023-11-16 13:00:00	QQQ	ETF	385.65	385.71	384.38	384.79	3484642.0
2023-11-16 14:00:00	QQQ	ETF	384.781	385.87	384.62	385.51	3599699.0
2023-11-16 15:00:00	QQQ	ETF	385.51	386.19	385.18	385.96	6465791.0
2023-11-16 16:00:00	QQQ	ETF	385.96	386.13	385.67	386.0	1092622.0
2023-11-16 17:00:00	QQQ	ETF	386.02	386.07	385.94	385.95	476781.0
2023-11-16 18:00:00	QQQ	ETF	385.93	385.93	385.62	385.7	48043.0
2023-11-16 19:00:00	QQQ	ETF	385.71	385.95	385.62	385.84	52433.0
2023-11-16 04:00:00	IWM	ETF	178.99	179.33	178.74	178.8	19760.0
2023-11-16 05:00:00	IWM	ETF	178.71	178.9	178.67	178.76	7016.0
2023-11-16 06:00:00	IWM	ETF	178.79	178.85	178.63	178.7	9319.0
2023-11-16 07:00:00	IWM	ETF	178.66	178.66	177.55	177.571	103631.0
2023-11-16 08:00:00	IWM	ETF	178.3503	179.2404	177.55	178.75	226139.0
2023-11-16 09:00:00	IWM	ETF	178.71	178.79	176.92	176.96	5141122.0
2023-11-16 10:00:00	IWM	ETF	176.97	177.085	175.36	175.605	8293488.0
2023-11-16 11:00:00	IWM	ETF	175.6	176.18	175.155	175.37	5028917.0
2023-11-16 12:00:00	IWM	ETF	175.38	176.42	175.285	175.98	3925661.0
2023-11-16 13:00:00	IWM	ETF	175.98	176.0202	175.4599	175.695	2372645.0
2023-11-16 14:00:00	IWM	ETF	175.7	176.46	175.65	176.23	2986616.0
2023-11-16 15:00:00	IWM	ETF	176.24	176.4321	175.79	176.0	6073877.0
2023-11-16 16:00:00	IWM	ETF	176.0	176.42	175.88	176.38	1675885.0
2023-11-16 17:00:00	IWM	ETF	176.41	176.41	175.88	176.22	18486.0
2023-11-16 18:00:00	IWM	ETF	176.3	176.41	176.15	176.21	38056.0
2023-11-16 19:00:00	IWM	ETF	176.22	176.39	176.13	176.3212	43360.0
2023-11-16 04:00:00	DIA	ETF	350.36	350.59	350.28	350.59	1490.0
2023-11-16 05:00:00	DIA	ETF	350.39	350.39	350.39	350.39	200.0

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

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