PREVIEW / etf_1hour / 2023-03-20

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-20.parquet
  size:    468 KB
  rows:    17,256

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
2023-03-20 04:00:00	SPY	ETF	387.49	389.0	385.18	388.28	186501.0
2023-03-20 05:00:00	SPY	ETF	388.41	390.08	388.0	389.86	186962.0
2023-03-20 06:00:00	SPY	ETF	389.86	390.81	389.3	390.61	266611.0
2023-03-20 07:00:00	SPY	ETF	390.56	390.79	389.11	389.9	347392.0
2023-03-20 08:00:00	SPY	ETF	389.9099	391.9	385.68	391.31	984645.0
2023-03-20 09:00:00	SPY	ETF	391.33	392.13	390.07	391.68	9275835.0
2023-03-20 10:00:00	SPY	ETF	391.68	393.18	390.9	393.04	10648547.0
2023-03-20 11:00:00	SPY	ETF	393.04	394.17	392.365	392.45	9205233.0
2023-03-20 12:00:00	SPY	ETF	392.45	393.22	390.73	392.9	9820467.0
2023-03-20 13:00:00	SPY	ETF	392.9	393.84	392.77	393.02	6576955.0
2023-03-20 14:00:00	SPY	ETF	393.01	393.35	391.95	392.71	7559064.0
2023-03-20 15:00:00	SPY	ETF	392.7	394.1278	392.255	393.66	14643504.0
2023-03-20 16:00:00	SPY	ETF	393.66	394.01	393.54	393.93	3009927.0
2023-03-20 17:00:00	SPY	ETF	393.97	394.07	393.74	393.96	396368.0
2023-03-20 18:00:00	SPY	ETF	393.97	394.09	393.61	393.94	105070.0
2023-03-20 19:00:00	SPY	ETF	393.9	393.9	393.5	393.68	99560.0
2023-03-20 04:00:00	QQQ	ETF	304.0	304.14	301.58	304.03	101283.0
2023-03-20 05:00:00	QQQ	ETF	304.23	305.19	303.92	304.91	68001.0
2023-03-20 06:00:00	QQQ	ETF	304.91	305.7	304.66	305.16	124403.0
2023-03-20 07:00:00	QQQ	ETF	305.13	305.27	304.09	304.65	226124.0
2023-03-20 08:00:00	QQQ	ETF	304.49	305.86	302.1596	305.4698	583023.0
2023-03-20 09:00:00	QQQ	ETF	305.5	305.52	302.01	302.81	7599587.0
2023-03-20 10:00:00	QQQ	ETF	302.82	304.93	302.59	304.77	7111231.0
2023-03-20 11:00:00	QQQ	ETF	304.77	306.0494	304.03	304.09	5063358.0
2023-03-20 12:00:00	QQQ	ETF	304.09	304.94	302.85	304.5749	4760431.0
2023-03-20 13:00:00	QQQ	ETF	304.61	305.44	304.492	305.18	3317833.0
2023-03-20 14:00:00	QQQ	ETF	305.16	305.74	304.48	305.17	3714351.0
2023-03-20 15:00:00	QQQ	ETF	305.15	306.3	304.73	305.91	6259705.0
2023-03-20 16:00:00	QQQ	ETF	305.93	306.19	305.78	306.08	2603662.0
2023-03-20 17:00:00	QQQ	ETF	306.1	306.3	306.07	306.11	30926.0
2023-03-20 18:00:00	QQQ	ETF	306.11	306.13	305.78	306.04	54771.0
2023-03-20 19:00:00	QQQ	ETF	306.0	306.0	305.68	305.89	37224.0
2023-03-20 04:00:00	IWM	ETF	170.3	170.64	168.45	170.43	78233.0
2023-03-20 05:00:00	IWM	ETF	170.52	171.65	170.45	171.44	53536.0
2023-03-20 06:00:00	IWM	ETF	171.42	172.37	171.22	172.37	225869.0
2023-03-20 07:00:00	IWM	ETF	172.31	172.43	171.47	172.13	80629.0
2023-03-20 08:00:00	IWM	ETF	172.3	173.44	168.9596	173.24	322371.0
2023-03-20 09:00:00	IWM	ETF	173.2	174.105	172.525	173.91	5152042.0
2023-03-20 10:00:00	IWM	ETF	173.94	175.06	173.4	174.84	5244288.0
2023-03-20 11:00:00	IWM	ETF	174.83	175.37	173.81	173.925	3595215.0
2023-03-20 12:00:00	IWM	ETF	173.92	174.17	172.53	173.93	4132690.0
2023-03-20 13:00:00	IWM	ETF	173.94	174.62	173.53	173.68	2739500.0
2023-03-20 14:00:00	IWM	ETF	173.68	173.82	173.06	173.37	3037816.0
2023-03-20 15:00:00	IWM	ETF	173.35	173.945	173.17	173.51	4700748.0
2023-03-20 16:00:00	IWM	ETF	173.45	173.83	173.4188	173.83	1803835.0
2023-03-20 17:00:00	IWM	ETF	173.7	173.99	173.67	173.9	46026.0
2023-03-20 18:00:00	IWM	ETF	173.9	174.13	173.77	173.95	47507.0
2023-03-20 19:00:00	IWM	ETF	173.8	173.8	173.63	173.77	12649.0
2023-03-20 04:00:00	DIA	ETF	317.01	317.01	314.4	316.57	9803.0
2023-03-20 05:00:00	DIA	ETF	317.04	318.04	316.65	318.04	2561.0

> showing 50 of 17,256 rows — these rows as CSV

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