PREVIEW / etf_1hour / 2022-12-08

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-12-08.parquet
  size:    461 KB
  rows:    16,737

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-12-08 04:00:00	SPY	ETF	393.9	394.31	393.51	393.76	47705.0
2022-12-08 05:00:00	SPY	ETF	393.8	394.07	393.46	393.78	29258.0
2022-12-08 06:00:00	SPY	ETF	393.75	394.6	393.47	394.34	34976.0
2022-12-08 07:00:00	SPY	ETF	394.4	394.97	394.05	394.89	342876.0
2022-12-08 08:00:00	SPY	ETF	394.1496	396.57	393.08	395.47	801184.0
2022-12-08 09:00:00	SPY	ETF	395.56	396.2501	393.45	396.18	5425490.0
2022-12-08 10:00:00	SPY	ETF	396.18	397.36	396.0618	396.6279	6471796.0
2022-12-08 11:00:00	SPY	ETF	396.63	396.895	395.01	396.1376	4621696.0
2022-12-08 12:00:00	SPY	ETF	396.14	396.36	395.065	395.84	3203925.0
2022-12-08 13:00:00	SPY	ETF	395.8536	397.27	395.64	396.47	4062194.0
2022-12-08 14:00:00	SPY	ETF	396.47	396.47	394.5	395.53	6627396.0
2022-12-08 15:00:00	SPY	ETF	395.54	396.58	394.87	396.21	10282796.0
2022-12-08 16:00:00	SPY	ETF	396.22	396.68	396.03	396.1	4606285.0
2022-12-08 17:00:00	SPY	ETF	396.06	396.3	396.01	396.24	84678.0
2022-12-08 18:00:00	SPY	ETF	396.22	396.52	395.96	395.96	77877.0
2022-12-08 19:00:00	SPY	ETF	395.91	396.09	395.7	395.9	56925.0
2022-12-08 04:00:00	QQQ	ETF	280.8	281.54	280.8	281.07	65943.0
2022-12-08 05:00:00	QQQ	ETF	281.12	281.34	280.97	281.19	19908.0
2022-12-08 06:00:00	QQQ	ETF	281.2	281.51	280.89	281.3	49192.0
2022-12-08 07:00:00	QQQ	ETF	281.26	281.75	281.0	281.7	227251.0
2022-12-08 08:00:00	QQQ	ETF	281.69	282.7	280.25	282.18	627261.0
2022-12-08 09:00:00	QQQ	ETF	282.18	282.87	279.79	282.81	5241929.0
2022-12-08 10:00:00	QQQ	ETF	282.8	284.49	282.67	283.86	5640028.0
2022-12-08 11:00:00	QQQ	ETF	283.84	284.16	282.34	283.6	4581524.0
2022-12-08 12:00:00	QQQ	ETF	283.6	283.85	282.7	283.46	2742566.0
2022-12-08 13:00:00	QQQ	ETF	283.45	284.84	283.2242	283.95	3699879.0
2022-12-08 14:00:00	QQQ	ETF	283.95	283.95	282.23	283.42	3841248.0
2022-12-08 15:00:00	QQQ	ETF	283.42	284.51	282.89	283.89	4821102.0
2022-12-08 16:00:00	QQQ	ETF	283.88	284.18	283.7	283.7	3301914.0
2022-12-08 17:00:00	QQQ	ETF	283.71	283.99	283.6851	283.8	49574.0
2022-12-08 18:00:00	QQQ	ETF	283.82	284.14	283.71	283.71	39152.0
2022-12-08 19:00:00	QQQ	ETF	283.69	283.7	283.4	283.5	78021.0
2022-12-08 04:00:00	IWM	ETF	179.81	180.13	179.8	179.92	21068.0
2022-12-08 05:00:00	IWM	ETF	179.95	180.03	179.73	179.81	7924.0
2022-12-08 06:00:00	IWM	ETF	179.75	180.22	179.72	180.1	17824.0
2022-12-08 07:00:00	IWM	ETF	180.05	180.42	179.97	180.42	42177.0
2022-12-08 08:00:00	IWM	ETF	179.98	181.13	179.7	180.71	361110.0
2022-12-08 09:00:00	IWM	ETF	180.77	181.62	179.51	181.6	2368145.0
2022-12-08 10:00:00	IWM	ETF	181.6	182.625	181.4	181.79	2228913.0
2022-12-08 11:00:00	IWM	ETF	181.78	182.0	180.85	181.2	1315068.0
2022-12-08 12:00:00	IWM	ETF	181.2	181.36	180.51	180.94	769326.0
2022-12-08 13:00:00	IWM	ETF	180.93	181.67	180.835	181.125	977330.0
2022-12-08 14:00:00	IWM	ETF	181.1	181.1	180.1	180.415	1469532.0
2022-12-08 15:00:00	IWM	ETF	180.405	180.83	180.09	180.83	2421341.0
2022-12-08 16:00:00	IWM	ETF	180.84	180.95	180.5	180.67	3501059.0
2022-12-08 17:00:00	IWM	ETF	180.44	180.84	180.44	180.76	41051.0
2022-12-08 18:00:00	IWM	ETF	180.79	180.91	180.52	180.65	43793.0
2022-12-08 19:00:00	IWM	ETF	180.56	180.72	180.48	180.51	18962.0
2022-12-08 04:00:00	DIA	ETF	336.92	336.99	336.92	336.99	411.0
2022-12-08 05:00:00	DIA	ETF	336.75	336.75	336.55	336.55	440.0

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

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