PREVIEW / etf_1hour / 2022-12-07

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-12-07.parquet
  size:    459 KB
  rows:    16,959

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-07 04:00:00	SPY	ETF	395.0	395.0	393.02	393.24	74044.0
2022-12-07 05:00:00	SPY	ETF	393.32	393.42	392.77	393.2	41940.0
2022-12-07 06:00:00	SPY	ETF	393.37	393.52	392.26	392.5	69656.0
2022-12-07 07:00:00	SPY	ETF	392.55	392.76	390.99	391.5	381285.0
2022-12-07 08:00:00	SPY	ETF	392.3475	394.5096	391.07	392.8201	577261.0
2022-12-07 09:00:00	SPY	ETF	392.85	395.3	392.34	392.82	6369719.0
2022-12-07 10:00:00	SPY	ETF	392.81	395.45	391.97	395.056	9299666.0
2022-12-07 11:00:00	SPY	ETF	395.06	395.64	392.31	393.39	6671661.0
2022-12-07 12:00:00	SPY	ETF	393.38	394.09	392.68	393.71	3505549.0
2022-12-07 13:00:00	SPY	ETF	393.71	394.59	392.87	393.0425	3429309.0
2022-12-07 14:00:00	SPY	ETF	393.02	393.73	392.3246	392.92	4914234.0
2022-12-07 15:00:00	SPY	ETF	392.91	393.48	392.09	393.15	8865266.0
2022-12-07 16:00:00	SPY	ETF	393.15	393.37	392.92	393.05	3154370.0
2022-12-07 17:00:00	SPY	ETF	393.05	393.16	392.94	393.11	493948.0
2022-12-07 18:00:00	SPY	ETF	393.11	393.39	393.04	393.24	90102.0
2022-12-07 19:00:00	SPY	ETF	393.33	393.34	392.23	392.23	115666.0
2022-12-07 20:00:00	SPY	ETF	392.23	392.23	392.23	392.23	1000.0
2022-12-07 04:00:00	QQQ	ETF	281.82	281.87	280.66	280.86	38793.0
2022-12-07 05:00:00	QQQ	ETF	280.97	281.07	280.6	281.0	30865.0
2022-12-07 06:00:00	QQQ	ETF	281.08	281.22	279.83	280.15	77801.0
2022-12-07 07:00:00	QQQ	ETF	280.15	280.36	278.4	278.94	387247.0
2022-12-07 08:00:00	QQQ	ETF	280.21	282.31	278.47	280.38	865498.0
2022-12-07 09:00:00	QQQ	ETF	280.42	282.57	279.25	279.54	6138596.0
2022-12-07 10:00:00	QQQ	ETF	279.53	281.97	278.7801	281.52	7021772.0
2022-12-07 11:00:00	QQQ	ETF	281.55	282.22	279.23	280.41	4128289.0
2022-12-07 12:00:00	QQQ	ETF	280.38	281.0	279.6	280.7704	2862447.0
2022-12-07 13:00:00	QQQ	ETF	280.8	281.65	280.29	280.42	2457848.0
2022-12-07 14:00:00	QQQ	ETF	280.4	280.96	279.8214	280.24	2844121.0
2022-12-07 15:00:00	QQQ	ETF	280.24	280.79	279.62	280.44	4671533.0
2022-12-07 16:00:00	QQQ	ETF	280.43	280.8	280.16	280.24	1494908.0
2022-12-07 17:00:00	QQQ	ETF	280.28	280.53	280.22	280.38	855903.0
2022-12-07 18:00:00	QQQ	ETF	280.36	280.66	280.34	280.47	63861.0
2022-12-07 19:00:00	QQQ	ETF	280.49	280.52	279.77	279.78	132331.0
2022-12-07 04:00:00	IWM	ETF	180.32	180.5	179.84	179.93	8359.0
2022-12-07 05:00:00	IWM	ETF	179.88	180.02	179.67	179.88	10208.0
2022-12-07 06:00:00	IWM	ETF	179.91	180.0	179.5	179.61	24623.0
2022-12-07 07:00:00	IWM	ETF	179.64	179.73	179.15	179.48	45724.0
2022-12-07 08:00:00	IWM	ETF	179.44	180.15	179.36	179.98	118341.0
2022-12-07 09:00:00	IWM	ETF	179.94	181.22	179.51	179.67	2238623.0
2022-12-07 10:00:00	IWM	ETF	179.67	181.36	179.11	181.02	2417021.0
2022-12-07 11:00:00	IWM	ETF	181.02	181.5	179.93	180.46	1122515.0
2022-12-07 12:00:00	IWM	ETF	180.49	180.65	179.96	180.4901	811317.0
2022-12-07 13:00:00	IWM	ETF	180.51	180.77	179.86	179.895	1024711.0
2022-12-07 14:00:00	IWM	ETF	179.885	180.28	179.485	179.84	1132840.0
2022-12-07 15:00:00	IWM	ETF	179.85	180.05	179.41	179.5407	2277301.0
2022-12-07 16:00:00	IWM	ETF	179.54	179.67	179.43	179.45	1421417.0
2022-12-07 17:00:00	IWM	ETF	179.49	179.54	179.42	179.5	49958.0
2022-12-07 18:00:00	IWM	ETF	179.54	179.69	179.5	179.6	21527.0
2022-12-07 19:00:00	IWM	ETF	179.68	179.71	179.23	179.23	28349.0
2022-12-07 04:00:00	DIA	ETF	336.99	337.08	336.71	336.71	2377.0

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

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