PREVIEW / etf_1hour / 2022-07-08

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-07-08.parquet
  size:    436 KB
  rows:    15,846

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-07-08 04:00:00	SPY	ETF	387.93	388.29	387.13	387.54	45289.0
2022-07-08 05:00:00	SPY	ETF	387.06	387.98	386.78	387.9	24246.0
2022-07-08 06:00:00	SPY	ETF	387.87	389.3	387.79	387.89	100169.0
2022-07-08 07:00:00	SPY	ETF	387.97	388.7	387.88	388.33	96950.0
2022-07-08 08:00:00	SPY	ETF	388.41	389.2404	385.35	386.84	2106476.0
2022-07-08 09:00:00	SPY	ETF	386.86	388.54	385.8738	386.3	6351634.0
2022-07-08 10:00:00	SPY	ETF	386.33	389.83	385.66	389.51	8917640.0
2022-07-08 11:00:00	SPY	ETF	389.52	390.64	389.0429	389.9425	5606207.0
2022-07-08 12:00:00	SPY	ETF	389.95	390.0	387.04	387.16	6005877.0
2022-07-08 13:00:00	SPY	ETF	387.18	389.06	386.66	388.48	4732537.0
2022-07-08 14:00:00	SPY	ETF	388.48	390.23	388.1	390.02	5430085.0
2022-07-08 15:00:00	SPY	ETF	390.0299	390.35	388.42	388.68	10031222.0
2022-07-08 16:00:00	SPY	ETF	388.68	389.08	388.42	389.02	3974279.0
2022-07-08 17:00:00	SPY	ETF	388.86	389.07	388.5	388.6	136833.0
2022-07-08 18:00:00	SPY	ETF	388.6	388.88	388.4	388.58	47517.0
2022-07-08 19:00:00	SPY	ETF	388.59	388.8	388.53	388.69	16004.0
2022-07-08 04:00:00	QQQ	ETF	294.0	294.25	293.42	293.66	51670.0
2022-07-08 05:00:00	QQQ	ETF	293.37	293.75	292.91	293.68	33454.0
2022-07-08 06:00:00	QQQ	ETF	293.7	294.63	293.2	293.25	94009.0
2022-07-08 07:00:00	QQQ	ETF	293.34	294.02	293.31	293.65	126846.0
2022-07-08 08:00:00	QQQ	ETF	293.7001	295.201	290.5	291.9	2847037.0
2022-07-08 09:00:00	QQQ	ETF	291.94	293.87	291.12	291.78	7995264.0
2022-07-08 10:00:00	QQQ	ETF	291.8	295.4513	291.28	295.18	8012780.0
2022-07-08 11:00:00	QQQ	ETF	295.19	296.75	295.0	296.2	6360536.0
2022-07-08 12:00:00	QQQ	ETF	296.21	296.24	292.72	293.089	6024946.0
2022-07-08 13:00:00	QQQ	ETF	293.1	295.27	292.5807	294.68	4354955.0
2022-07-08 14:00:00	QQQ	ETF	294.7	296.22	294.32	295.93	3705585.0
2022-07-08 15:00:00	QQQ	ETF	295.95	296.1	295.0	295.38	6001421.0
2022-07-08 16:00:00	QQQ	ETF	295.4	295.7265	295.15	295.47	1457475.0
2022-07-08 17:00:00	QQQ	ETF	295.57	295.57	295.16	295.26	41995.0
2022-07-08 18:00:00	QQQ	ETF	295.29	295.42	294.0	295.34	37188.0
2022-07-08 19:00:00	QQQ	ETF	295.34	295.58	295.34	295.58	26269.0
2022-07-08 04:00:00	IWM	ETF	174.97	175.15	174.72	174.97	8399.0
2022-07-08 05:00:00	IWM	ETF	174.68	175.22	174.62	175.19	9610.0
2022-07-08 06:00:00	IWM	ETF	175.18	176.02	175.15	175.29	16568.0
2022-07-08 07:00:00	IWM	ETF	175.43	175.67	175.3	175.43	34728.0
2022-07-08 08:00:00	IWM	ETF	175.3001	175.7	174.18	174.97	272916.0
2022-07-08 09:00:00	IWM	ETF	174.94	175.68	173.74	173.93	1923358.0
2022-07-08 10:00:00	IWM	ETF	173.93	176.99	173.65	176.63	2118446.0
2022-07-08 11:00:00	IWM	ETF	176.64	176.88	175.64	176.12	1633546.0
2022-07-08 12:00:00	IWM	ETF	176.14	176.15	173.98	174.25	1833054.0
2022-07-08 13:00:00	IWM	ETF	174.27	175.23	174.01	174.87	1215688.0
2022-07-08 14:00:00	IWM	ETF	174.85	176.035	174.75	176.015	1247499.0
2022-07-08 15:00:00	IWM	ETF	176.015	176.1	175.39	175.59	2717822.0
2022-07-08 16:00:00	IWM	ETF	175.59	175.85	175.53	175.7	2290986.0
2022-07-08 17:00:00	IWM	ETF	175.69	175.8899	175.69	175.69	2929.0
2022-07-08 18:00:00	IWM	ETF	175.69	175.7	175.4	175.67	18953.0
2022-07-08 19:00:00	IWM	ETF	175.59	175.85	175.59	175.83	18160.0
2022-07-08 04:00:00	DIA	ETF	313.18	313.52	312.8	312.87	1300.0
2022-07-08 06:00:00	DIA	ETF	314.29	314.69	313.72	313.72	2098.0

> showing 50 of 15,846 rows — these rows as CSV

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