PREVIEW / etf_1hour / 2023-08-29

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-29.parquet
  size:    479 KB
  rows:    17,497

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-08-29 04:00:00	SPY	ETF	442.68	443.04	442.46	442.69	30668.0
2023-08-29 05:00:00	SPY	ETF	442.44	443.41	442.42	443.4	21910.0
2023-08-29 06:00:00	SPY	ETF	443.39	443.44	442.69	442.69	19137.0
2023-08-29 07:00:00	SPY	ETF	442.68	442.91	442.22	442.36	103282.0
2023-08-29 08:00:00	SPY	ETF	442.7505	443.42	441.95	442.5	225357.0
2023-08-29 09:00:00	SPY	ETF	442.58	444.22	442.2	443.86	5273454.0
2023-08-29 10:00:00	SPY	ETF	443.81	446.78	443.81	445.79	15067481.0
2023-08-29 11:00:00	SPY	ETF	445.79	447.95	445.72	447.62	7533668.0
2023-08-29 12:00:00	SPY	ETF	447.62	448.445	447.49	448.035	5755475.0
2023-08-29 13:00:00	SPY	ETF	448.05	448.76	447.67	448.07	6188150.0
2023-08-29 14:00:00	SPY	ETF	448.08	448.86	447.94	448.525	6718787.0
2023-08-29 15:00:00	SPY	ETF	448.52	449.45	448.12	449.14	16914335.0
2023-08-29 16:00:00	SPY	ETF	449.15	449.47	443.0222	449.32	4483537.0
2023-08-29 17:00:00	SPY	ETF	449.35	449.38	449.27	449.35	66829.0
2023-08-29 18:00:00	SPY	ETF	449.35	449.66	449.31	449.49	55034.0
2023-08-29 19:00:00	SPY	ETF	449.49	449.57	449.38	449.45	33949.0
2023-08-29 04:00:00	QQQ	ETF	366.81	367.05	366.4	366.51	46292.0
2023-08-29 05:00:00	QQQ	ETF	366.48	367.34	366.41	367.31	27066.0
2023-08-29 06:00:00	QQQ	ETF	367.32	367.4	366.73	366.78	35390.0
2023-08-29 07:00:00	QQQ	ETF	366.76	366.97	366.37	366.48	50681.0
2023-08-29 08:00:00	QQQ	ETF	366.621	368.01	365.94	366.42	171859.0
2023-08-29 09:00:00	QQQ	ETF	366.44	368.93	366.17	368.505	4448388.0
2023-08-29 10:00:00	QQQ	ETF	368.52	372.63	368.475	372.0	12379654.0
2023-08-29 11:00:00	QQQ	ETF	371.99	374.04	371.95	373.595	6452639.0
2023-08-29 12:00:00	QQQ	ETF	373.6	374.16	373.23	373.86	4263767.0
2023-08-29 13:00:00	QQQ	ETF	373.87	374.4	373.35	373.7013	4058743.0
2023-08-29 14:00:00	QQQ	ETF	373.7	374.67	373.6	374.48	4464065.0
2023-08-29 15:00:00	QQQ	ETF	374.47	375.13	374.1	374.73	8121641.0
2023-08-29 16:00:00	QQQ	ETF	374.74	375.1	372.5378	375.02	1999243.0
2023-08-29 17:00:00	QQQ	ETF	375.02	375.1	375.0	375.04	51743.0
2023-08-29 18:00:00	QQQ	ETF	375.04	375.42	374.99	375.2	82441.0
2023-08-29 19:00:00	QQQ	ETF	375.2892	375.37	375.16	375.26	60583.0
2023-08-29 04:00:00	IWM	ETF	185.43	185.78	185.41	185.41	9117.0
2023-08-29 05:00:00	IWM	ETF	185.47	185.95	185.44	185.95	5511.0
2023-08-29 06:00:00	IWM	ETF	185.64	185.73	185.49	185.51	1526.0
2023-08-29 07:00:00	IWM	ETF	185.5	185.63	185.18	185.25	12798.0
2023-08-29 08:00:00	IWM	ETF	185.25	185.48	185.12	185.33	54014.0
2023-08-29 09:00:00	IWM	ETF	185.3	185.95	184.57	185.81	2916303.0
2023-08-29 10:00:00	IWM	ETF	185.81	187.175	185.81	186.94	3898983.0
2023-08-29 11:00:00	IWM	ETF	186.94	187.91	186.93	187.8	2028893.0
2023-08-29 12:00:00	IWM	ETF	187.8	188.07	187.7125	188.01	1469161.0
2023-08-29 13:00:00	IWM	ETF	188.02	188.365	187.945	188.23	1842296.0
2023-08-29 14:00:00	IWM	ETF	188.24	188.32	188.04	188.13	1872425.0
2023-08-29 15:00:00	IWM	ETF	188.12	188.23	187.88	188.145	3712927.0
2023-08-29 16:00:00	IWM	ETF	188.23	188.27	188.0	188.17	1060308.0
2023-08-29 17:00:00	IWM	ETF	188.18	188.29	188.16	188.25	4377.0
2023-08-29 18:00:00	IWM	ETF	188.18	188.35	188.14	188.25	8310.0
2023-08-29 19:00:00	IWM	ETF	188.26	188.27	188.13	188.19	40729.0
2023-08-29 04:00:00	DIA	ETF	345.88	345.88	345.69	345.69	2315.0
2023-08-29 05:00:00	DIA	ETF	345.48	346.15	345.48	346.13	2300.0

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

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