PREVIEW / etf_1hour / 2021-03-23

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-23.parquet
  size:    421 KB
  rows:    14,527

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
2021-03-23 04:00:00	SPY	ETF	391.78	391.78	390.95	391.63	40573.0
2021-03-23 05:00:00	SPY	ETF	391.6	391.72	390.79	390.82	136164.0
2021-03-23 06:00:00	SPY	ETF	390.72	391.11	390.4	391.09	184683.0
2021-03-23 07:00:00	SPY	ETF	391.1	391.65	390.85	391.17	278651.0
2021-03-23 08:00:00	SPY	ETF	391.1201	392.0	390.81	391.7	226060.0
2021-03-23 09:00:00	SPY	ETF	391.73	392.445	391.56	392.44	5340137.0
2021-03-23 10:00:00	SPY	ETF	392.44	393.0	391.24	392.3467	8889668.0
2021-03-23 11:00:00	SPY	ETF	392.35	393.46	392.18	392.83	6718473.0
2021-03-23 12:00:00	SPY	ETF	392.869	393.35	392.06	392.968	5932397.0
2021-03-23 13:00:00	SPY	ETF	392.95	393.31	391.63	391.85	5319359.0
2021-03-23 14:00:00	SPY	ETF	391.855	392.245	390.46	390.49	8232412.0
2021-03-23 15:00:00	SPY	ETF	390.49	390.95	388.66	389.51	24069441.0
2021-03-23 16:00:00	SPY	ETF	389.51	390.17	389.5	389.98	3383517.0
2021-03-23 17:00:00	SPY	ETF	390.07	390.24	389.77	390.19	104633.0
2021-03-23 18:00:00	SPY	ETF	390.11	390.11	389.47	389.8	121235.0
2021-03-23 19:00:00	SPY	ETF	389.8	389.8	389.15	389.43	254223.0
2021-03-23 04:00:00	QQQ	ETF	318.1	318.28	317.35	318.26	78627.0
2021-03-23 05:00:00	QQQ	ETF	318.12	318.49	317.37	317.83	48952.0
2021-03-23 06:00:00	QQQ	ETF	317.65	318.39	317.4	318.16	86518.0
2021-03-23 07:00:00	QQQ	ETF	318.23	319.16	318.2	318.88	373956.0
2021-03-23 08:00:00	QQQ	ETF	318.24	319.76	317.05	319.57	412271.0
2021-03-23 09:00:00	QQQ	ETF	319.6	319.86	318.18	318.88	5808981.0
2021-03-23 10:00:00	QQQ	ETF	318.81	320.185	318.17	319.96	7040311.0
2021-03-23 11:00:00	QQQ	ETF	319.96	321.09	319.335	319.7	6074694.0
2021-03-23 12:00:00	QQQ	ETF	319.71	320.28	318.5	319.86	4814678.0
2021-03-23 13:00:00	QQQ	ETF	319.84	320.54	318.61	318.88	3804137.0
2021-03-23 14:00:00	QQQ	ETF	318.88	319.9	317.92	317.955	4204190.0
2021-03-23 15:00:00	QQQ	ETF	317.93	318.39	316.375	317.02	8835918.0
2021-03-23 16:00:00	QQQ	ETF	317.01	317.81	317.01	317.68	824522.0
2021-03-23 17:00:00	QQQ	ETF	317.6	318.0	317.55	317.9	38495.0
2021-03-23 18:00:00	QQQ	ETF	317.98	318.13	317.5	317.81	98903.0
2021-03-23 19:00:00	QQQ	ETF	317.65	317.74	317.3	317.6	34926.0
2021-03-23 04:00:00	IWM	ETF	224.3	224.88	222.92	223.42	17930.0
2021-03-23 05:00:00	IWM	ETF	223.42	223.53	222.2	222.2	19555.0
2021-03-23 06:00:00	IWM	ETF	222.24	222.47	221.85	222.35	50102.0
2021-03-23 07:00:00	IWM	ETF	222.39	222.84	222.31	222.64	77601.0
2021-03-23 08:00:00	IWM	ETF	222.35	224.54	222.35	223.09	105952.0
2021-03-23 09:00:00	IWM	ETF	223.16	223.86	222.13	222.73	2736644.0
2021-03-23 10:00:00	IWM	ETF	222.73	223.13	220.57	221.34	5646325.0
2021-03-23 11:00:00	IWM	ETF	221.335	221.98	220.47	220.81	3770229.0
2021-03-23 12:00:00	IWM	ETF	220.83	221.58	220.5019	221.48	2087013.0
2021-03-23 13:00:00	IWM	ETF	221.47	221.645	219.55	219.865	2790979.0
2021-03-23 14:00:00	IWM	ETF	219.89	220.42	217.65	217.68	4181364.0
2021-03-23 15:00:00	IWM	ETF	217.68	218.67	216.03	217.11	9970293.0
2021-03-23 16:00:00	IWM	ETF	217.06	217.9	216.7	217.59	1988409.0
2021-03-23 17:00:00	IWM	ETF	217.77	218.2	217.06	218.0	228515.0
2021-03-23 18:00:00	IWM	ETF	217.92	217.92	217.04	217.12	267906.0
2021-03-23 19:00:00	IWM	ETF	217.11	217.11	216.2	216.4	230237.0
2021-03-23 04:00:00	DIA	ETF	326.72	326.72	325.95	326.22	3900.0
2021-03-23 05:00:00	DIA	ETF	326.44	326.44	325.96	325.96	200.0

> showing 50 of 14,527 rows — these rows as CSV

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