PREVIEW / etf_1hour / 2023-11-14

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-11-14.parquet
  size:    516 KB
  rows:    19,092

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-14 04:00:00	SPY	ETF	440.5	441.39	440.5	441.08	44077.0
2023-11-14 05:00:00	SPY	ETF	441.2	441.29	440.58	440.66	21680.0
2023-11-14 06:00:00	SPY	ETF	440.73	440.75	440.34	440.75	82907.0
2023-11-14 07:00:00	SPY	ETF	440.68	440.75	440.23	440.61	77634.0
2023-11-14 08:00:00	SPY	ETF	440.7003	446.7	439.92	446.47	2950684.0
2023-11-14 09:00:00	SPY	ETF	446.47	448.045	445.91	447.94	12038641.0
2023-11-14 10:00:00	SPY	ETF	447.93	449.3812	447.62	448.96	13921791.0
2023-11-14 11:00:00	SPY	ETF	448.98	449.73	448.4	448.435	7642368.0
2023-11-14 12:00:00	SPY	ETF	448.46	448.82	447.87	448.75	6377521.0
2023-11-14 13:00:00	SPY	ETF	448.75	449.14	448.23	448.23	4168555.0
2023-11-14 14:00:00	SPY	ETF	448.25	449.505	447.7	449.43	6692396.0
2023-11-14 15:00:00	SPY	ETF	449.43	450.06	448.29	448.71	18173009.0
2023-11-14 16:00:00	SPY	ETF	448.71	449.7006	448.3048	449.1	3674432.0
2023-11-14 17:00:00	SPY	ETF	449.09	449.3	448.99	449.2502	137599.0
2023-11-14 18:00:00	SPY	ETF	449.25	449.61	449.21	449.26	98687.0
2023-11-14 19:00:00	SPY	ETF	449.36	449.39	449.09	449.26	78465.0
2023-11-14 04:00:00	QQQ	ETF	378.44	378.73	378.27	378.36	130292.0
2023-11-14 05:00:00	QQQ	ETF	378.39	378.54	377.93	378.07	145029.0
2023-11-14 06:00:00	QQQ	ETF	378.06	378.18	377.77	378.14	11352.0
2023-11-14 07:00:00	QQQ	ETF	378.14	378.23	377.8	378.17	108131.0
2023-11-14 08:00:00	QQQ	ETF	378.13	384.38	377.0	383.93	4042684.0
2023-11-14 09:00:00	QQQ	ETF	383.88	385.01	383.18	384.8905	10561284.0
2023-11-14 10:00:00	QQQ	ETF	384.89	385.87	384.57	385.01	7879254.0
2023-11-14 11:00:00	QQQ	ETF	385.01	385.63	384.25	384.4	5071496.0
2023-11-14 12:00:00	QQQ	ETF	384.41	385.28	384.19	385.2298	4201516.0
2023-11-14 13:00:00	QQQ	ETF	385.23	385.52	384.6298	384.63	3780885.0
2023-11-14 14:00:00	QQQ	ETF	384.64	385.6601	383.915	385.555	4726279.0
2023-11-14 15:00:00	QQQ	ETF	385.55	386.26	384.91	385.29	8993505.0
2023-11-14 16:00:00	QQQ	ETF	385.29	385.92	384.66	385.67	2439829.0
2023-11-14 17:00:00	QQQ	ETF	385.65	385.9708	385.65	385.95	44057.0
2023-11-14 18:00:00	QQQ	ETF	385.87	386.109	385.75	385.97	46468.0
2023-11-14 19:00:00	QQQ	ETF	385.9702	386.0	385.7398	385.95	83978.0
2023-11-14 04:00:00	IWM	ETF	169.28	169.5	169.24	169.43	8477.0
2023-11-14 05:00:00	IWM	ETF	169.38	169.56	169.1	169.14	14040.0
2023-11-14 06:00:00	IWM	ETF	169.18	169.18	169.0	169.17	5368.0
2023-11-14 07:00:00	IWM	ETF	169.14	169.18	168.88	169.08	75031.0
2023-11-14 08:00:00	IWM	ETF	169.16	176.19	168.93	175.13	3286348.0
2023-11-14 09:00:00	IWM	ETF	174.99	176.069	174.02	175.76	10014903.0
2023-11-14 10:00:00	IWM	ETF	175.76	177.345	175.47	177.085	8853814.0
2023-11-14 11:00:00	IWM	ETF	177.09	178.045	176.97	177.01	7367784.0
2023-11-14 12:00:00	IWM	ETF	177.02	177.25	176.5	177.185	4679926.0
2023-11-14 13:00:00	IWM	ETF	177.19	177.69	177.135	177.2299	3515787.0
2023-11-14 14:00:00	IWM	ETF	177.23	177.51	176.93	177.49	4170542.0
2023-11-14 15:00:00	IWM	ETF	177.49	178.47	177.44	178.43	13140905.0
2023-11-14 16:00:00	IWM	ETF	178.43	178.72	175.4864	178.62	2391159.0
2023-11-14 17:00:00	IWM	ETF	178.67	178.95	178.62	178.84	97988.0
2023-11-14 18:00:00	IWM	ETF	178.83	178.95	178.63	178.81	71089.0
2023-11-14 19:00:00	IWM	ETF	178.8	178.82	178.62	178.78	81073.0
2023-11-14 04:00:00	DIA	ETF	343.97	344.1	343.87	344.1	2430.0
2023-11-14 06:00:00	DIA	ETF	343.8	344.0	343.73	343.73	946.0

> showing 50 of 19,092 rows — these rows as CSV

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