PREVIEW / etf_1hour / 2022-03-15

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-15.parquet
  size:    455 KB
  rows:    16,660

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-03-15 04:00:00	SPY	ETF	415.71	417.48	414.0	414.25	59321.0
2022-03-15 05:00:00	SPY	ETF	414.21	416.23	413.61	415.37	90351.0
2022-03-15 06:00:00	SPY	ETF	415.36	417.97	415.36	417.42	169056.0
2022-03-15 07:00:00	SPY	ETF	417.32	418.45	416.9	417.42	448408.0
2022-03-15 08:00:00	SPY	ETF	418.2201	420.05	414.8004	419.26	824643.0
2022-03-15 09:00:00	SPY	ETF	419.27	421.33	418.42	420.37	8659166.0
2022-03-15 10:00:00	SPY	ETF	420.37	422.83	419.12	421.77	11200863.0
2022-03-15 11:00:00	SPY	ETF	421.76	424.25	421.71	422.53	9982497.0
2022-03-15 12:00:00	SPY	ETF	422.5366	424.41	421.56	423.58	6770749.0
2022-03-15 13:00:00	SPY	ETF	423.57	424.13	421.84	423.2	4354591.0
2022-03-15 14:00:00	SPY	ETF	423.2	424.78	421.37	424.62	7022434.0
2022-03-15 15:00:00	SPY	ETF	424.64	426.84	424.38	426.14	22232172.0
2022-03-15 16:00:00	SPY	ETF	426.15	426.2	423.7334	425.55	5280727.0
2022-03-15 17:00:00	SPY	ETF	425.47	426.17	425.3	425.52	116252.0
2022-03-15 18:00:00	SPY	ETF	425.55	425.6	425.1	425.23	98779.0
2022-03-15 19:00:00	SPY	ETF	425.3	426.29	425.11	425.4	147748.0
2022-03-15 04:00:00	QQQ	ETF	318.0	319.05	316.24	316.27	129124.0
2022-03-15 05:00:00	QQQ	ETF	316.41	317.99	315.71	317.13	147579.0
2022-03-15 06:00:00	QQQ	ETF	317.1	319.4	317.1	318.98	270468.0
2022-03-15 07:00:00	QQQ	ETF	318.88	320.04	318.49	319.03	406585.0
2022-03-15 08:00:00	QQQ	ETF	319.39	321.55	315.8804	320.65	1281044.0
2022-03-15 09:00:00	QQQ	ETF	320.66	322.17	319.23	321.49	8871708.0
2022-03-15 10:00:00	QQQ	ETF	321.5296	324.8891	321.0	324.13	9443958.0
2022-03-15 11:00:00	QQQ	ETF	324.13	326.93	323.98	324.895	8432278.0
2022-03-15 12:00:00	QQQ	ETF	324.86	326.45	323.96	325.5099	7419979.0
2022-03-15 13:00:00	QQQ	ETF	325.49	325.99	323.905	325.2199	4224287.0
2022-03-15 14:00:00	QQQ	ETF	325.19	326.33	323.4	326.25	4543687.0
2022-03-15 15:00:00	QQQ	ETF	326.23	328.95	325.97	328.18	10788001.0
2022-03-15 16:00:00	QQQ	ETF	328.19	328.32	327.64	327.86	1486250.0
2022-03-15 17:00:00	QQQ	ETF	327.98	328.15	327.83	328.1	308327.0
2022-03-15 18:00:00	QQQ	ETF	328.06	328.06	327.58	327.7	134855.0
2022-03-15 19:00:00	QQQ	ETF	327.83	328.61	327.65	328.19	86637.0
2022-03-15 04:00:00	IWM	ETF	191.6	192.62	190.66	190.78	23439.0
2022-03-15 05:00:00	IWM	ETF	190.77	191.77	190.5	191.53	9030.0
2022-03-15 06:00:00	IWM	ETF	191.52	192.81	191.46	192.43	12319.0
2022-03-15 07:00:00	IWM	ETF	192.51	192.9	192.32	192.67	153985.0
2022-03-15 08:00:00	IWM	ETF	192.68	194.03	192.28	193.49	207915.0
2022-03-15 09:00:00	IWM	ETF	193.46	194.65	192.88	193.64	3537442.0
2022-03-15 10:00:00	IWM	ETF	193.65	195.23	193.08	194.41	3001009.0
2022-03-15 11:00:00	IWM	ETF	194.46	194.73	193.29	193.95	1719035.0
2022-03-15 12:00:00	IWM	ETF	193.9	194.53	193.35	193.89	1825080.0
2022-03-15 13:00:00	IWM	ETF	193.88	194.46	193.17	194.08	1178581.0
2022-03-15 14:00:00	IWM	ETF	194.05	195.05	193.07	194.91	1808874.0
2022-03-15 15:00:00	IWM	ETF	194.88	195.79	194.65	195.71	3630115.0
2022-03-15 16:00:00	IWM	ETF	195.78	195.86	195.25	195.29	1814876.0
2022-03-15 17:00:00	IWM	ETF	195.45	195.78	195.32	195.55	161355.0
2022-03-15 18:00:00	IWM	ETF	195.43	195.47	195.22	195.42	34878.0
2022-03-15 19:00:00	IWM	ETF	195.45	195.85	195.33	195.41	28691.0
2022-03-15 04:00:00	DIA	ETF	329.0	329.73	328.08	328.14	7399.0
2022-03-15 05:00:00	DIA	ETF	327.97	329.23	327.97	329.07	1500.0

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

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