PREVIEW / etf_1hour / 2022-08-01

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-01.parquet
  size:    450 KB
  rows:    16,313

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
2022-08-01 04:00:00	SPY	ETF	411.19	411.42	410.45	410.58	17002.0
2022-08-01 05:00:00	SPY	ETF	410.66	411.36	410.66	411.21	8582.0
2022-08-01 06:00:00	SPY	ETF	411.16	411.43	411.03	411.17	27942.0
2022-08-01 07:00:00	SPY	ETF	411.16	412.06	411.16	411.5	118736.0
2022-08-01 08:00:00	SPY	ETF	411.5	411.985	409.0	409.4	773531.0
2022-08-01 09:00:00	SPY	ETF	409.4	411.76	408.4	411.19	6947463.0
2022-08-01 10:00:00	SPY	ETF	411.13	413.41	410.04	413.045	9375574.0
2022-08-01 11:00:00	SPY	ETF	413.05	413.3911	411.545	412.74	5152785.0
2022-08-01 12:00:00	SPY	ETF	412.7101	412.831	411.2902	411.86	3809498.0
2022-08-01 13:00:00	SPY	ETF	411.87	411.8799	409.07	410.03	5763973.0
2022-08-01 14:00:00	SPY	ETF	410.03	411.71	409.24	411.38	6321461.0
2022-08-01 15:00:00	SPY	ETF	411.39	411.85	410.445	410.71	12093486.0
2022-08-01 16:00:00	SPY	ETF	410.71	411.09	410.55	411.02	2847809.0
2022-08-01 17:00:00	SPY	ETF	411.02	411.02	410.53	410.63	240384.0
2022-08-01 18:00:00	SPY	ETF	410.63	410.83	410.27	410.61	164072.0
2022-08-01 19:00:00	SPY	ETF	410.57	410.9	410.0	410.13	76930.0
2022-08-01 04:00:00	QQQ	ETF	315.04	315.07	314.0	314.23	52414.0
2022-08-01 05:00:00	QQQ	ETF	314.28	314.89	314.28	314.75	18193.0
2022-08-01 06:00:00	QQQ	ETF	314.98	314.98	314.59	314.76	46056.0
2022-08-01 07:00:00	QQQ	ETF	314.85	315.88	314.85	315.36	169013.0
2022-08-01 08:00:00	QQQ	ETF	314.98	315.696	313.79	313.79	502505.0
2022-08-01 09:00:00	QQQ	ETF	313.77	316.738	312.53	315.9	7067768.0
2022-08-01 10:00:00	QQQ	ETF	315.9	318.81	315.35	318.35	7296885.0
2022-08-01 11:00:00	QQQ	ETF	318.37	318.625	316.91	318.07	4078093.0
2022-08-01 12:00:00	QQQ	ETF	318.07	318.22	315.96	316.42	3132177.0
2022-08-01 13:00:00	QQQ	ETF	316.43	316.43	313.69	314.55	4333969.0
2022-08-01 14:00:00	QQQ	ETF	314.55	316.12	313.9424	315.89	3833220.0
2022-08-01 15:00:00	QQQ	ETF	315.9	316.18	314.72	315.24	4988141.0
2022-08-01 16:00:00	QQQ	ETF	315.25	315.74	315.13	315.68	719761.0
2022-08-01 17:00:00	QQQ	ETF	315.68	315.72	315.28	315.36	58082.0
2022-08-01 18:00:00	QQQ	ETF	315.41	315.49	315.01	315.22	70985.0
2022-08-01 19:00:00	QQQ	ETF	315.2	315.55	314.93	314.93	45504.0
2022-08-01 04:00:00	IWM	ETF	186.39	186.69	186.26	186.32	16493.0
2022-08-01 05:00:00	IWM	ETF	186.42	186.78	186.38	186.71	7308.0
2022-08-01 06:00:00	IWM	ETF	186.67	186.79	186.56	186.67	5933.0
2022-08-01 07:00:00	IWM	ETF	186.66	187.06	186.6	186.76	32024.0
2022-08-01 08:00:00	IWM	ETF	186.9	187.25	185.77	185.81	79800.0
2022-08-01 09:00:00	IWM	ETF	185.79	186.22	184.22	185.8874	2683981.0
2022-08-01 10:00:00	IWM	ETF	185.82	187.44	185.2442	187.38	2836159.0
2022-08-01 11:00:00	IWM	ETF	187.39	187.55	186.35	187.1	1493589.0
2022-08-01 12:00:00	IWM	ETF	187.1	188.32	186.8	188.05	2019290.0
2022-08-01 13:00:00	IWM	ETF	188.075	188.165	186.715	187.04	2416687.0
2022-08-01 14:00:00	IWM	ETF	187.02	188.055	186.621	187.91	1950373.0
2022-08-01 15:00:00	IWM	ETF	187.92	188.19	187.0	187.17	3039015.0
2022-08-01 16:00:00	IWM	ETF	187.18	187.4	187.05	187.3	1001849.0
2022-08-01 17:00:00	IWM	ETF	187.07	187.29	187.05	187.05	14976.0
2022-08-01 18:00:00	IWM	ETF	187.02	187.12	186.89	187.1	30450.0
2022-08-01 19:00:00	IWM	ETF	187.07	187.2	186.85	186.85	55515.0
2022-08-01 04:00:00	DIA	ETF	328.13	328.13	327.94	327.94	892.0
2022-08-01 05:00:00	DIA	ETF	328.0	328.0	328.0	328.0	263.0

> showing 50 of 16,313 rows — these rows as CSV

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