PREVIEW / etf_1hour / 2022-04-27

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-04-27.parquet
  size:    461 KB
  rows:    16,882

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-04-27 04:00:00	SPY	ETF	419.0	421.0	419.0	419.8	249223.0
2022-04-27 05:00:00	SPY	ETF	419.77	420.49	419.62	420.41	145778.0
2022-04-27 06:00:00	SPY	ETF	420.46	420.76	419.4	420.46	220060.0
2022-04-27 07:00:00	SPY	ETF	420.49	420.49	417.45	417.89	409594.0
2022-04-27 08:00:00	SPY	ETF	419.6999	420.75	416.1	417.82	574744.0
2022-04-27 09:00:00	SPY	ETF	418.0	422.02	416.78	420.75	12024935.0
2022-04-27 10:00:00	SPY	ETF	420.75	421.77	415.01	418.0262	16817937.0
2022-04-27 11:00:00	SPY	ETF	418.04	421.0	417.71	419.69	11140122.0
2022-04-27 12:00:00	SPY	ETF	419.68	422.92	418.73	422.055	8922380.0
2022-04-27 13:00:00	SPY	ETF	422.06	422.35	419.65	421.93	9897092.0
2022-04-27 14:00:00	SPY	ETF	421.9242	421.96	418.29	418.71	7028446.0
2022-04-27 15:00:00	SPY	ETF	418.71	419.0	416.53	417.26	20592385.0
2022-04-27 16:00:00	SPY	ETF	417.25	420.87	416.84	420.44	4653015.0
2022-04-27 17:00:00	SPY	ETF	420.46	420.57	420.08	420.5	258443.0
2022-04-27 18:00:00	SPY	ETF	420.6	420.99	420.21	420.38	211198.0
2022-04-27 19:00:00	SPY	ETF	420.35	420.85	420.07	420.57	102650.0
2022-04-27 04:00:00	QQQ	ETF	318.76	321.05	318.76	319.8	453421.0
2022-04-27 05:00:00	QQQ	ETF	319.66	320.37	319.48	320.14	126546.0
2022-04-27 06:00:00	QQQ	ETF	320.23	320.56	319.5	320.2	184769.0
2022-04-27 07:00:00	QQQ	ETF	320.18	320.25	317.07	317.58	717490.0
2022-04-27 08:00:00	QQQ	ETF	318.13	320.53	317.11	317.67	986877.0
2022-04-27 09:00:00	QQQ	ETF	317.72	322.88	316.52	320.94	11585732.0
2022-04-27 10:00:00	QQQ	ETF	320.93	322.06	315.0	317.84	20210398.0
2022-04-27 11:00:00	QQQ	ETF	317.84	320.7	317.8	318.7579	10194601.0
2022-04-27 12:00:00	QQQ	ETF	318.79	322.29	317.64	321.28	7526616.0
2022-04-27 13:00:00	QQQ	ETF	321.29	321.69	318.73	320.79	13138905.0
2022-04-27 14:00:00	QQQ	ETF	320.77	320.96	317.48	317.85	7024668.0
2022-04-27 15:00:00	QQQ	ETF	317.84	318.23	316.11	316.73	14624642.0
2022-04-27 16:00:00	QQQ	ETF	316.74	321.27	316.33	320.83	4146866.0
2022-04-27 17:00:00	QQQ	ETF	320.75	321.58	320.42	321.49	556559.0
2022-04-27 18:00:00	QQQ	ETF	321.49	321.5	320.51	320.58	405105.0
2022-04-27 19:00:00	QQQ	ETF	320.74	321.12	320.51	320.91	180793.0
2022-04-27 04:00:00	IWM	ETF	189.02	189.56	188.6	188.92	44836.0
2022-04-27 05:00:00	IWM	ETF	189.0	189.1	188.6	189.06	8960.0
2022-04-27 06:00:00	IWM	ETF	189.15	189.25	188.79	189.08	15439.0
2022-04-27 07:00:00	IWM	ETF	189.07	189.07	187.77	188.0	60442.0
2022-04-27 08:00:00	IWM	ETF	188.5599	188.82	187.55	188.25	445852.0
2022-04-27 09:00:00	IWM	ETF	188.35	189.39	187.35	189.31	3933256.0
2022-04-27 10:00:00	IWM	ETF	189.315	189.78	186.26	187.49	5205523.0
2022-04-27 11:00:00	IWM	ETF	187.51	188.47	187.04	187.88	3201649.0
2022-04-27 12:00:00	IWM	ETF	187.89	189.14	187.52	188.68	2230721.0
2022-04-27 13:00:00	IWM	ETF	188.7	188.98	187.2	188.81	3229180.0
2022-04-27 14:00:00	IWM	ETF	188.82	189.03	187.285	187.46	3028142.0
2022-04-27 15:00:00	IWM	ETF	187.46	187.6	186.52	186.92	6018736.0
2022-04-27 16:00:00	IWM	ETF	186.96	188.23	186.86	188.03	781943.0
2022-04-27 17:00:00	IWM	ETF	187.79	188.4	187.76	188.15	29257.0
2022-04-27 18:00:00	IWM	ETF	188.15	188.15	187.58	187.7	52853.0
2022-04-27 19:00:00	IWM	ETF	187.7	187.99	187.59	187.79	28460.0
2022-04-27 04:00:00	DIA	ETF	335.72	336.27	335.21	335.24	4132.0
2022-04-27 05:00:00	DIA	ETF	335.8	335.96	335.8	335.96	1100.0

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

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