PREVIEW / etf_1hour / 2022-05-03

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-05-03.parquet
  size:    454 KB
  rows:    16,236

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-05-03 04:00:00	SPY	ETF	415.64	416.64	414.73	414.86	63044.0
2022-05-03 05:00:00	SPY	ETF	414.48	415.0	414.21	414.7	46906.0
2022-05-03 06:00:00	SPY	ETF	414.78	414.89	412.42	412.84	77821.0
2022-05-03 07:00:00	SPY	ETF	412.84	414.08	412.5	413.89	284122.0
2022-05-03 08:00:00	SPY	ETF	412.8701	416.37	412.55	415.4	576447.0
2022-05-03 09:00:00	SPY	ETF	415.39	415.7117	413.36	415.42	11161879.0
2022-05-03 10:00:00	SPY	ETF	415.44	416.7	413.78	415.25	14276906.0
2022-05-03 11:00:00	SPY	ETF	415.23	418.93	414.72	417.9	9686284.0
2022-05-03 12:00:00	SPY	ETF	417.89	418.76	415.9525	416.98	8417819.0
2022-05-03 13:00:00	SPY	ETF	416.99	418.71	416.905	417.55	6351916.0
2022-05-03 14:00:00	SPY	ETF	417.55	417.58	414.115	417.3167	10394787.0
2022-05-03 15:00:00	SPY	ETF	417.31	417.98	414.79	416.42	16520114.0
2022-05-03 16:00:00	SPY	ETF	416.42	417.6	416.0	416.7404	6167723.0
2022-05-03 17:00:00	SPY	ETF	416.67	417.01	416.67	416.87	175991.0
2022-05-03 18:00:00	SPY	ETF	416.73	417.12	416.43	416.81	95176.0
2022-05-03 19:00:00	SPY	ETF	416.71	417.29	416.68	416.92	49032.0
2022-05-03 04:00:00	QQQ	ETF	318.39	319.83	318.19	318.63	89184.0
2022-05-03 05:00:00	QQQ	ETF	318.5	318.9	318.09	318.54	85302.0
2022-05-03 06:00:00	QQQ	ETF	318.58	318.81	316.83	317.19	91483.0
2022-05-03 07:00:00	QQQ	ETF	317.23	318.22	316.89	318.17	211760.0
2022-05-03 08:00:00	QQQ	ETF	316.99	320.05	316.8596	319.35	546922.0
2022-05-03 09:00:00	QQQ	ETF	319.33	319.48	315.98	319.44	10645182.0
2022-05-03 10:00:00	QQQ	ETF	319.41	320.43	316.16	317.44	11197062.0
2022-05-03 11:00:00	QQQ	ETF	317.37	320.24	316.75	319.2935	7643752.0
2022-05-03 12:00:00	QQQ	ETF	319.26	320.21	317.36	318.74	5988885.0
2022-05-03 13:00:00	QQQ	ETF	318.77	321.17	318.61	320.06	5483914.0
2022-05-03 14:00:00	QQQ	ETF	320.03	320.11	316.62	319.55	6899323.0
2022-05-03 15:00:00	QQQ	ETF	319.56	320.08	317.19	318.91	10187880.0
2022-05-03 16:00:00	QQQ	ETF	318.92	320.31	318.74	319.65	2171475.0
2022-05-03 17:00:00	QQQ	ETF	319.79	319.9	318.82	319.71	522577.0
2022-05-03 18:00:00	QQQ	ETF	319.71	319.95	319.4	319.42	209449.0
2022-05-03 19:00:00	QQQ	ETF	319.42	319.81	319.28	319.54	130450.0
2022-05-03 04:00:00	IWM	ETF	187.53	188.06	187.01	187.1	9167.0
2022-05-03 05:00:00	IWM	ETF	187.1	187.21	186.77	186.99	15934.0
2022-05-03 06:00:00	IWM	ETF	187.04	187.04	185.7	185.96	11155.0
2022-05-03 07:00:00	IWM	ETF	185.91	186.43	185.82	186.35	22019.0
2022-05-03 08:00:00	IWM	ETF	185.96	187.5	185.8104	186.95	140047.0
2022-05-03 09:00:00	IWM	ETF	186.98	187.69	185.68	187.14	3636090.0
2022-05-03 10:00:00	IWM	ETF	187.15	188.09	186.23	187.05	4256762.0
2022-05-03 11:00:00	IWM	ETF	187.04	188.84	186.72	188.59	2728204.0
2022-05-03 12:00:00	IWM	ETF	188.61	189.03	187.64	188.17	2110711.0
2022-05-03 13:00:00	IWM	ETF	188.155	189.5099	188.12	189.16	1710715.0
2022-05-03 14:00:00	IWM	ETF	189.15	189.16	186.93	189.03	2478632.0
2022-05-03 15:00:00	IWM	ETF	189.05	189.32	187.95	188.5	5375799.0
2022-05-03 16:00:00	IWM	ETF	188.49	189.03	188.2933	188.64	1176319.0
2022-05-03 17:00:00	IWM	ETF	188.46	188.79	188.3	188.59	126204.0
2022-05-03 18:00:00	IWM	ETF	188.51	188.76	188.36	188.61	34317.0
2022-05-03 19:00:00	IWM	ETF	188.6	188.97	188.6	188.89	26398.0
2022-05-03 05:00:00	DIA	ETF	330.75	330.82	330.75	330.82	406.0
2022-05-03 06:00:00	DIA	ETF	329.99	329.99	329.7	329.7	200.0

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

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