PREVIEW / etf_1hour / 2022-05-27

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-05-27.parquet
  size:    455 KB
  rows:    16,254

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-27 04:00:00	SPY	ETF	405.01	406.79	405.01	406.54	40894.0
2022-05-27 05:00:00	SPY	ETF	406.3	407.37	405.9	407.17	28783.0
2022-05-27 06:00:00	SPY	ETF	406.89	406.89	406.2	406.85	28599.0
2022-05-27 07:00:00	SPY	ETF	406.8	406.8	405.4	405.48	136014.0
2022-05-27 08:00:00	SPY	ETF	406.7001	408.45	404.72	408.25	809475.0
2022-05-27 09:00:00	SPY	ETF	408.24	411.55	407.5999	411.03	8907048.0
2022-05-27 10:00:00	SPY	ETF	411.02	412.29	410.66	410.95	10595577.0
2022-05-27 11:00:00	SPY	ETF	410.96	412.64	410.51	412.5	5819047.0
2022-05-27 12:00:00	SPY	ETF	412.52	412.87	411.8	412.41	4484114.0
2022-05-27 13:00:00	SPY	ETF	412.42	412.82	411.885	412.275	4131856.0
2022-05-27 14:00:00	SPY	ETF	412.28	413.21	411.94	413.14	5295424.0
2022-05-27 15:00:00	SPY	ETF	413.15	415.3801	413.0	415.35	18800234.0
2022-05-27 16:00:00	SPY	ETF	415.35	416.49	414.97	416.46	6716998.0
2022-05-27 17:00:00	SPY	ETF	416.46	416.46	415.26	416.27	201325.0
2022-05-27 18:00:00	SPY	ETF	416.27	416.45	416.2	416.44	54321.0
2022-05-27 19:00:00	SPY	ETF	416.43	416.8	416.36	416.7	39999.0
2022-05-27 04:00:00	QQQ	ETF	299.26	301.05	298.62	300.81	88916.0
2022-05-27 05:00:00	QQQ	ETF	300.59	301.65	300.14	301.38	61658.0
2022-05-27 06:00:00	QQQ	ETF	301.34	301.34	300.46	301.12	104580.0
2022-05-27 07:00:00	QQQ	ETF	301.15	301.24	299.7	299.8	190884.0
2022-05-27 08:00:00	QQQ	ETF	300.8999	303.2	299.05	302.8	1307017.0
2022-05-27 09:00:00	QQQ	ETF	302.78	305.55	301.9	305.275	8845145.0
2022-05-27 10:00:00	QQQ	ETF	305.26	307.0418	304.85	305.55	9530836.0
2022-05-27 11:00:00	QQQ	ETF	305.58	307.17	304.93	307.03	5696457.0
2022-05-27 12:00:00	QQQ	ETF	307.05	307.49	306.22	306.865	3807763.0
2022-05-27 13:00:00	QQQ	ETF	306.85	307.19	306.41	306.925	3242281.0
2022-05-27 14:00:00	QQQ	ETF	306.94	307.67	306.532	307.6	3849533.0
2022-05-27 15:00:00	QQQ	ETF	307.5901	309.25	307.38	309.2321	10954262.0
2022-05-27 16:00:00	QQQ	ETF	309.24	310.11	308.98	310.06	2168454.0
2022-05-27 17:00:00	QQQ	ETF	310.03	310.1	309.1	310.1	180273.0
2022-05-27 18:00:00	QQQ	ETF	310.0	310.2	310.0	310.15	18686.0
2022-05-27 19:00:00	QQQ	ETF	310.2	310.5	310.15	310.45	43312.0
2022-05-27 04:00:00	IWM	ETF	182.62	183.38	182.56	183.19	18029.0
2022-05-27 05:00:00	IWM	ETF	183.24	183.52	182.98	183.49	11987.0
2022-05-27 06:00:00	IWM	ETF	183.43	183.43	183.19	183.38	10808.0
2022-05-27 07:00:00	IWM	ETF	183.39	183.39	182.9	182.92	56969.0
2022-05-27 08:00:00	IWM	ETF	183.1804	184.1	182.83	183.96	175421.0
2022-05-27 09:00:00	IWM	ETF	184.02	185.5271	183.4	185.1999	2767706.0
2022-05-27 10:00:00	IWM	ETF	185.22	185.84	184.941	185.25	2655752.0
2022-05-27 11:00:00	IWM	ETF	185.26	186.405	184.94	186.4	2423171.0
2022-05-27 12:00:00	IWM	ETF	186.39	186.62	186.14	186.54	1345070.0
2022-05-27 13:00:00	IWM	ETF	186.54	186.7	186.355	186.67	1407262.0
2022-05-27 14:00:00	IWM	ETF	186.68	187.09	186.605	187.06	2005079.0
2022-05-27 15:00:00	IWM	ETF	187.07	187.65	186.92	187.63	4358370.0
2022-05-27 16:00:00	IWM	ETF	187.64	188.3	187.25	188.3	942958.0
2022-05-27 17:00:00	IWM	ETF	187.91	188.09	187.72	187.79	34201.0
2022-05-27 18:00:00	IWM	ETF	187.95	188.19	187.75	187.9	5737.0
2022-05-27 19:00:00	IWM	ETF	187.84	188.24	187.84	187.91	6913.0
2022-05-27 04:00:00	DIA	ETF	326.19	326.54	326.19	326.54	1094.0
2022-05-27 05:00:00	DIA	ETF	327.3	327.3	327.19	327.19	400.0

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

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