PREVIEW / etf_1hour / 2022-05-16

all etf 1-hour files

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

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-16 04:00:00	SPY	ETF	399.98	401.6	399.34	401.13	44856.0
2022-05-16 05:00:00	SPY	ETF	401.08	401.21	399.7	399.72	53518.0
2022-05-16 06:00:00	SPY	ETF	399.8	400.57	399.8	400.23	54617.0
2022-05-16 07:00:00	SPY	ETF	400.19	400.75	400.0	400.52	173399.0
2022-05-16 08:00:00	SPY	ETF	400.25	402.25	398.41	400.78	564336.0
2022-05-16 09:00:00	SPY	ETF	400.81	401.72	397.6	398.7241	8509289.0
2022-05-16 10:00:00	SPY	ETF	398.7026	401.79	397.65	398.52	8681181.0
2022-05-16 11:00:00	SPY	ETF	398.54	401.71	397.98	401.43	7376079.0
2022-05-16 12:00:00	SPY	ETF	401.45	402.079	399.43	399.85	4817861.0
2022-05-16 13:00:00	SPY	ETF	399.79	402.81	399.34	402.0	5398220.0
2022-05-16 14:00:00	SPY	ETF	402.03	403.97	401.49	402.9999	7394962.0
2022-05-16 15:00:00	SPY	ETF	403.0	403.37	399.32	400.23	13634030.0
2022-05-16 16:00:00	SPY	ETF	400.23	400.4	399.0	399.6	3167456.0
2022-05-16 17:00:00	SPY	ETF	399.55	399.72	399.4	399.56	64782.0
2022-05-16 18:00:00	SPY	ETF	399.56	400.26	399.56	400.17	129139.0
2022-05-16 19:00:00	SPY	ETF	400.25	400.59	399.82	400.42	61424.0
2022-05-16 04:00:00	QQQ	ETF	300.36	300.82	299.51	300.8	74796.0
2022-05-16 05:00:00	QQQ	ETF	300.99	301.08	299.69	299.69	62437.0
2022-05-16 06:00:00	QQQ	ETF	299.72	300.5	299.72	300.49	53898.0
2022-05-16 07:00:00	QQQ	ETF	300.36	300.86	300.15	300.61	198031.0
2022-05-16 08:00:00	QQQ	ETF	300.3601	303.82	298.81	301.2	643985.0
2022-05-16 09:00:00	QQQ	ETF	301.2	301.4	297.821	298.65	8918449.0
2022-05-16 10:00:00	QQQ	ETF	298.64	301.63	297.48	297.58	8851842.0
2022-05-16 11:00:00	QQQ	ETF	297.59	300.71	297.13	300.48	6338450.0
2022-05-16 12:00:00	QQQ	ETF	300.49	301.02	298.06	298.32	3712648.0
2022-05-16 13:00:00	QQQ	ETF	298.28	301.07	297.82	300.377	4241984.0
2022-05-16 14:00:00	QQQ	ETF	300.4	302.26	299.79	301.29	4694444.0
2022-05-16 15:00:00	QQQ	ETF	301.29	301.46	297.68	298.55	8134983.0
2022-05-16 16:00:00	QQQ	ETF	298.55	300.766	298.13	298.25	1385651.0
2022-05-16 17:00:00	QQQ	ETF	298.25	298.44	297.95	298.02	74512.0
2022-05-16 18:00:00	QQQ	ETF	298.14	298.97	298.14	298.8	200654.0
2022-05-16 19:00:00	QQQ	ETF	298.79	299.04	298.47	298.95	77227.0
2022-05-16 04:00:00	IWM	ETF	177.18	177.86	176.9	177.86	24485.0
2022-05-16 05:00:00	IWM	ETF	177.87	177.9	177.15	177.15	38308.0
2022-05-16 06:00:00	IWM	ETF	177.3	177.58	177.24	177.4	8777.0
2022-05-16 07:00:00	IWM	ETF	177.4	177.62	177.14	177.46	30779.0
2022-05-16 08:00:00	IWM	ETF	177.52	178.31	177.22	177.68	102200.0
2022-05-16 09:00:00	IWM	ETF	177.64	178.39	176.135	177.05	4226943.0
2022-05-16 10:00:00	IWM	ETF	177.05	179.44	176.42	177.14	4180221.0
2022-05-16 11:00:00	IWM	ETF	177.11	178.705	176.635	178.68	2854709.0
2022-05-16 12:00:00	IWM	ETF	178.68	179.02	176.91	177.16	1828031.0
2022-05-16 13:00:00	IWM	ETF	177.15	178.74	176.91	178.05	1811194.0
2022-05-16 14:00:00	IWM	ETF	178.06	178.81	177.7	178.32	1893239.0
2022-05-16 15:00:00	IWM	ETF	178.31	178.58	176.795	177.23	3466600.0
2022-05-16 16:00:00	IWM	ETF	177.22	177.29	176.9	177.06	685491.0
2022-05-16 17:00:00	IWM	ETF	177.14	177.22	176.83	176.95	10341.0
2022-05-16 18:00:00	IWM	ETF	176.95	177.3	176.94	177.24	41217.0
2022-05-16 19:00:00	IWM	ETF	177.23	177.62	177.16	177.37	20992.0
2022-05-16 04:00:00	DIA	ETF	321.35	322.4	321.35	322.4	2305.0
2022-05-16 05:00:00	DIA	ETF	322.47	322.47	322.24	322.34	1000.0

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

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