PREVIEW / etf_1hour / 2023-08-21

all etf 1-hour files

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

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-21 04:00:00	SPY	ETF	437.02	437.95	436.75	437.95	35755.0
2023-08-21 05:00:00	SPY	ETF	437.97	438.55	437.97	438.52	24295.0
2023-08-21 06:00:00	SPY	ETF	438.49	438.62	438.04	438.04	67116.0
2023-08-21 07:00:00	SPY	ETF	438.12	438.7	438.0	438.57	289366.0
2023-08-21 08:00:00	SPY	ETF	438.3	438.76	435.73	437.57	483289.0
2023-08-21 09:00:00	SPY	ETF	437.54	438.71	437.15	438.71	5133960.0
2023-08-21 10:00:00	SPY	ETF	438.72	438.89	436.42	436.725	9052571.0
2023-08-21 11:00:00	SPY	ETF	436.725	437.06	435.32	435.62	6626878.0
2023-08-21 12:00:00	SPY	ETF	435.62	437.4095	435.52	437.31	5474166.0
2023-08-21 13:00:00	SPY	ETF	437.32	438.45	436.95	438.05	6413772.0
2023-08-21 14:00:00	SPY	ETF	438.06	439.2401	437.9	438.98	5949839.0
2023-08-21 15:00:00	SPY	ETF	439.01	440.11	439.01	439.34	12654563.0
2023-08-21 16:00:00	SPY	ETF	439.33	439.542	437.9266	438.99	2703270.0
2023-08-21 17:00:00	SPY	ETF	438.95	439.09	438.95	439.03	52411.0
2023-08-21 18:00:00	SPY	ETF	439.03	439.03	438.64	438.64	65367.0
2023-08-21 19:00:00	SPY	ETF	438.7	439.03	438.6005	438.67	48686.0
2023-08-21 04:00:00	QQQ	ETF	358.54	360.23	358.54	360.17	108008.0
2023-08-21 05:00:00	QQQ	ETF	360.22	360.44	360.08	360.4	36670.0
2023-08-21 06:00:00	QQQ	ETF	360.34	360.53	359.88	360.06	82110.0
2023-08-21 07:00:00	QQQ	ETF	360.04	360.67	359.91	360.6	332676.0
2023-08-21 08:00:00	QQQ	ETF	360.0	360.8	357.61	359.77	392157.0
2023-08-21 09:00:00	QQQ	ETF	359.78	362.16	359.28	362.16	4991234.0
2023-08-21 10:00:00	QQQ	ETF	362.17	362.61	359.93	360.18	6820880.0
2023-08-21 11:00:00	QQQ	ETF	360.17	360.779	359.15	359.655	4597184.0
2023-08-21 12:00:00	QQQ	ETF	359.65	361.9448	359.58	361.86	4443972.0
2023-08-21 13:00:00	QQQ	ETF	361.8699	363.3591	361.4801	362.8975	4809526.0
2023-08-21 14:00:00	QQQ	ETF	362.905	364.08	362.775	363.78	3349674.0
2023-08-21 15:00:00	QQQ	ETF	363.78	364.59	363.73	363.96	7603324.0
2023-08-21 16:00:00	QQQ	ETF	363.97	364.0291	363.39	363.6	1937228.0
2023-08-21 17:00:00	QQQ	ETF	363.64	363.91	363.59	363.8	106643.0
2023-08-21 18:00:00	QQQ	ETF	363.76	363.76	363.21	363.25	136006.0
2023-08-21 19:00:00	QQQ	ETF	363.31	363.61	363.07	363.18	86084.0
2023-08-21 04:00:00	IWM	ETF	185.35	185.43	185.0	185.24	22415.0
2023-08-21 05:00:00	IWM	ETF	185.26	185.54	185.24	185.44	2741.0
2023-08-21 06:00:00	IWM	ETF	185.34	185.41	185.06	185.13	32925.0
2023-08-21 07:00:00	IWM	ETF	185.09	185.44	185.08	185.29	20905.0
2023-08-21 08:00:00	IWM	ETF	185.12	185.46	184.35	184.74	50573.0
2023-08-21 09:00:00	IWM	ETF	184.73	185.275	184.03	184.59	2747913.0
2023-08-21 10:00:00	IWM	ETF	184.6	184.615	183.63	184.21	2910753.0
2023-08-21 11:00:00	IWM	ETF	184.21	184.3	183.0704	183.345	2702026.0
2023-08-21 12:00:00	IWM	ETF	183.33	183.765	183.22	183.68	1858687.0
2023-08-21 13:00:00	IWM	ETF	183.67	184.24	183.52	184.08	2117143.0
2023-08-21 14:00:00	IWM	ETF	184.09	184.45	184.03	184.325	1236085.0
2023-08-21 15:00:00	IWM	ETF	184.33	184.78	184.24	184.35	3754969.0
2023-08-21 16:00:00	IWM	ETF	184.38	184.38	184.18	184.3	1212237.0
2023-08-21 17:00:00	IWM	ETF	184.25	184.4	184.25	184.31	15572.0
2023-08-21 18:00:00	IWM	ETF	184.22	184.22	184.05	184.12	14346.0
2023-08-21 19:00:00	IWM	ETF	184.11	184.32	184.08	184.1782	82923.0
2023-08-21 04:00:00	DIA	ETF	345.89	345.89	345.89	345.89	345.0
2023-08-21 05:00:00	DIA	ETF	346.03	346.19	346.03	346.16	3147.0

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

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