PREVIEW / etf_1hour / 2022-09-06

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-09-06.parquet
  size:    443 KB
  rows:    16,517

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-09-06 04:00:00	SPY	ETF	394.83	394.97	393.9	394.8	102274.0
2022-09-06 05:00:00	SPY	ETF	394.75	394.76	393.76	394.59	51277.0
2022-09-06 06:00:00	SPY	ETF	394.66	395.98	394.61	394.92	94263.0
2022-09-06 07:00:00	SPY	ETF	394.92	395.08	393.87	394.66	311093.0
2022-09-06 08:00:00	SPY	ETF	394.95	395.8404	393.73	394.46	397801.0
2022-09-06 09:00:00	SPY	ETF	394.45	394.85	390.52	391.64	6916403.0
2022-09-06 10:00:00	SPY	ETF	391.65	393.74	388.42	393.11	12776312.0
2022-09-06 11:00:00	SPY	ETF	393.1	394.05	391.82	393.38	7080672.0
2022-09-06 12:00:00	SPY	ETF	393.36	393.72	390.42	391.6301	5930838.0
2022-09-06 13:00:00	SPY	ETF	391.63	391.69	389.14	390.38	6106050.0
2022-09-06 14:00:00	SPY	ETF	390.362	391.75	389.94	390.413	5357907.0
2022-09-06 15:00:00	SPY	ETF	390.43	391.79	389.71	390.79	12965785.0
2022-09-06 16:00:00	SPY	ETF	390.79	390.9	390.16	390.58	1955382.0
2022-09-06 17:00:00	SPY	ETF	390.56	390.76	390.35	390.76	512414.0
2022-09-06 18:00:00	SPY	ETF	390.44	390.84	390.34	390.73	112525.0
2022-09-06 19:00:00	SPY	ETF	390.7	390.76	390.21	390.36	35863.0
2022-09-06 04:00:00	QQQ	ETF	297.2	297.66	296.5	297.64	62304.0
2022-09-06 05:00:00	QQQ	ETF	297.65	297.65	296.73	297.25	54008.0
2022-09-06 06:00:00	QQQ	ETF	297.26	298.2	297.07	297.31	80856.0
2022-09-06 07:00:00	QQQ	ETF	297.29	297.37	296.05	296.91	239473.0
2022-09-06 08:00:00	QQQ	ETF	296.69	298.0	296.06	296.65	334982.0
2022-09-06 09:00:00	QQQ	ETF	296.63	297.09	293.03	293.689	6063260.0
2022-09-06 10:00:00	QQQ	ETF	293.66	295.59	290.87	295.0959	9180168.0
2022-09-06 11:00:00	QQQ	ETF	295.07	296.04	293.97	295.51	5753230.0
2022-09-06 12:00:00	QQQ	ETF	295.5	295.94	292.86	293.95	4803269.0
2022-09-06 13:00:00	QQQ	ETF	293.96	294.0364	291.68	292.74	4902026.0
2022-09-06 14:00:00	QQQ	ETF	292.735	294.04	292.56	292.93	3836998.0
2022-09-06 15:00:00	QQQ	ETF	292.94	294.18	292.32	293.06	7321719.0
2022-09-06 16:00:00	QQQ	ETF	293.06	293.18	292.63	293.03	1112978.0
2022-09-06 17:00:00	QQQ	ETF	292.96	293.14	292.91	293.0	446825.0
2022-09-06 18:00:00	QQQ	ETF	292.96	293.39	292.9	293.07	63465.0
2022-09-06 19:00:00	QQQ	ETF	293.09	293.12	292.59	292.75	70581.0
2022-09-06 04:00:00	IWM	ETF	181.8	181.82	181.28	181.56	14130.0
2022-09-06 05:00:00	IWM	ETF	181.3	181.64	181.02	181.5	15735.0
2022-09-06 06:00:00	IWM	ETF	181.56	182.12	181.45	181.64	10629.0
2022-09-06 07:00:00	IWM	ETF	181.6	181.75	181.18	181.52	28852.0
2022-09-06 08:00:00	IWM	ETF	181.6	181.77	181.04	181.29	37378.0
2022-09-06 09:00:00	IWM	ETF	181.25	181.41	178.56	179.06	2326479.0
2022-09-06 10:00:00	IWM	ETF	179.06	179.39	177.5	179.11	3286680.0
2022-09-06 11:00:00	IWM	ETF	179.1	179.88	178.67	179.67	2320610.0
2022-09-06 12:00:00	IWM	ETF	179.68	179.94	178.53	178.96	1655401.0
2022-09-06 13:00:00	IWM	ETF	178.95	178.98	177.85	178.37	1680062.0
2022-09-06 14:00:00	IWM	ETF	178.365	179.04	178.24	178.42	1547093.0
2022-09-06 15:00:00	IWM	ETF	178.43	178.65	177.77	178.38	4609239.0
2022-09-06 16:00:00	IWM	ETF	178.31	178.4	178.08	178.31	1136687.0
2022-09-06 17:00:00	IWM	ETF	178.31	178.37	178.12	178.17	314870.0
2022-09-06 18:00:00	IWM	ETF	178.25	178.4	178.13	178.33	38288.0
2022-09-06 19:00:00	IWM	ETF	178.33	178.33	178.03	178.12	35087.0
2022-09-06 04:00:00	DIA	ETF	315.68	315.68	315.0	315.0	5227.0
2022-09-06 05:00:00	DIA	ETF	315.51	315.51	315.51	315.51	100.0

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

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