PREVIEW / etf_1hour / 2023-05-18

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-05-18.parquet
  size:    470 KB
  rows:    17,267

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-05-18 04:00:00	SPY	ETF	415.69	416.3	415.2	415.93	27377.0
2023-05-18 05:00:00	SPY	ETF	415.74	416.19	415.72	416.12	17336.0
2023-05-18 06:00:00	SPY	ETF	416.11	416.47	416.01	416.25	140031.0
2023-05-18 07:00:00	SPY	ETF	416.24	416.52	416.07	416.13	214229.0
2023-05-18 08:00:00	SPY	ETF	416.2213	416.5	414.59	414.63	724600.0
2023-05-18 09:00:00	SPY	ETF	414.6	415.47	414.31	415.1494	4974424.0
2023-05-18 10:00:00	SPY	ETF	415.15	417.53	414.95	417.28	10220570.0
2023-05-18 11:00:00	SPY	ETF	417.28	418.06	416.775	417.08	8531177.0
2023-05-18 12:00:00	SPY	ETF	417.08	417.13	415.72	416.2	7513190.0
2023-05-18 13:00:00	SPY	ETF	416.2	417.21	415.395	415.625	6866520.0
2023-05-18 14:00:00	SPY	ETF	415.62	417.14	415.47	417.03	6238627.0
2023-05-18 15:00:00	SPY	ETF	417.04	419.67	416.8123	419.23	20280414.0
2023-05-18 16:00:00	SPY	ETF	419.22	419.65	419.08	419.6	4091345.0
2023-05-18 17:00:00	SPY	ETF	419.61	419.79	419.59	419.75	159426.0
2023-05-18 18:00:00	SPY	ETF	419.71	420.65	419.48	420.39	319994.0
2023-05-18 19:00:00	SPY	ETF	420.27	420.27	419.88	419.9	77270.0
2023-05-18 04:00:00	QQQ	ETF	331.5	332.04	331.5	331.79	28961.0
2023-05-18 05:00:00	QQQ	ETF	331.69	331.9	331.68	331.8	10996.0
2023-05-18 06:00:00	QQQ	ETF	331.9	332.12	331.79	331.9	44357.0
2023-05-18 07:00:00	QQQ	ETF	331.92	332.22	331.92	332.12	73540.0
2023-05-18 08:00:00	QQQ	ETF	332.04	332.2101	331.06	331.17	536151.0
2023-05-18 09:00:00	QQQ	ETF	331.15	333.08	331.001	332.97	5728719.0
2023-05-18 10:00:00	QQQ	ETF	332.98	334.84	332.66	334.68	8937425.0
2023-05-18 11:00:00	QQQ	ETF	334.69	336.4	334.64	335.64	8273506.0
2023-05-18 12:00:00	QQQ	ETF	335.64	335.72	334.44	334.84	6690931.0
2023-05-18 13:00:00	QQQ	ETF	334.85	336.01	334.18	334.31	4978212.0
2023-05-18 14:00:00	QQQ	ETF	334.315	335.51	334.0	335.41	3885641.0
2023-05-18 15:00:00	QQQ	ETF	335.41	337.49	335.19	337.23	9996495.0
2023-05-18 16:00:00	QQQ	ETF	337.22	337.76	337.17	337.74	1745171.0
2023-05-18 17:00:00	QQQ	ETF	337.75	337.75	337.27	337.6	94674.0
2023-05-18 18:00:00	QQQ	ETF	337.69	338.9	337.5	338.6	458295.0
2023-05-18 19:00:00	QQQ	ETF	338.45	338.47	338.1499	338.21	97904.0
2023-05-18 04:00:00	IWM	ETF	176.56	176.88	176.52	176.62	9808.0
2023-05-18 05:00:00	IWM	ETF	176.53	176.76	176.53	176.75	5603.0
2023-05-18 06:00:00	IWM	ETF	176.81	176.99	176.78	176.88	19375.0
2023-05-18 07:00:00	IWM	ETF	176.91	177.29	176.66	176.69	81783.0
2023-05-18 08:00:00	IWM	ETF	176.91	176.91	175.61	175.61	290807.0
2023-05-18 09:00:00	IWM	ETF	175.55	175.88	175.02	175.55	4206547.0
2023-05-18 10:00:00	IWM	ETF	175.56	176.86	175.51	176.76	3746144.0
2023-05-18 11:00:00	IWM	ETF	176.77	177.27	176.48	176.65	2774287.0
2023-05-18 12:00:00	IWM	ETF	176.64	176.66	175.56	175.83	2496639.0
2023-05-18 13:00:00	IWM	ETF	175.83	176.24	175.33	175.47	1628176.0
2023-05-18 14:00:00	IWM	ETF	175.45	176.34	175.41	176.3	1082708.0
2023-05-18 15:00:00	IWM	ETF	176.3	177.57	176.11	177.23	4880222.0
2023-05-18 16:00:00	IWM	ETF	177.19	177.5	177.19	177.19	1471531.0
2023-05-18 17:00:00	IWM	ETF	177.45	177.57	177.31	177.36	49629.0
2023-05-18 18:00:00	IWM	ETF	177.42	177.98	177.32	177.84	65744.0
2023-05-18 19:00:00	IWM	ETF	177.81	177.81	177.49	177.57	10656.0
2023-05-18 04:00:00	DIA	ETF	334.85	335.01	334.85	334.95	905.0
2023-05-18 06:00:00	DIA	ETF	334.95	335.03	334.95	335.03	1304.0

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

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