PREVIEW / etf_1hour / 2021-12-23

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-12-23.parquet
  size:    440 KB
  rows:    15,559

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
2021-12-23 04:00:00	SPY	ETF	468.2	468.71	468.2	468.34	11862.0
2021-12-23 05:00:00	SPY	ETF	468.37	468.89	468.35	468.87	14274.0
2021-12-23 06:00:00	SPY	ETF	468.9	469.08	468.8	469.06	20818.0
2021-12-23 07:00:00	SPY	ETF	469.01	469.32	468.92	469.23	90841.0
2021-12-23 08:00:00	SPY	ETF	469.2501	469.45	468.2	468.77	346544.0
2021-12-23 09:00:00	SPY	ETF	468.82	470.66	468.64	470.17	5964114.0
2021-12-23 10:00:00	SPY	ETF	470.17	471.1198	470.0	471.09	4845762.0
2021-12-23 11:00:00	SPY	ETF	471.08	471.47	470.79	471.3	3897820.0
2021-12-23 12:00:00	SPY	ETF	471.31	471.31	470.8865	471.075	2385315.0
2021-12-23 13:00:00	SPY	ETF	471.07	471.42	470.72	471.2999	2022324.0
2021-12-23 14:00:00	SPY	ETF	471.31	471.82	471.18	471.79	2869856.0
2021-12-23 15:00:00	SPY	ETF	471.79	472.19	470.54	470.58	12671451.0
2021-12-23 16:00:00	SPY	ETF	470.59	471.5774	470.49	470.81	4187307.0
2021-12-23 17:00:00	SPY	ETF	470.83	470.83	470.65	470.72	37002.0
2021-12-23 18:00:00	SPY	ETF	470.75	470.8	470.56	470.63	39127.0
2021-12-23 19:00:00	SPY	ETF	470.59	470.63	470.51	470.51	12575.0
2021-12-23 04:00:00	QQQ	ETF	394.1	394.28	393.92	394.22	17270.0
2021-12-23 05:00:00	QQQ	ETF	394.12	394.73	394.12	394.73	12521.0
2021-12-23 06:00:00	QQQ	ETF	394.67	394.79	394.5	394.75	18962.0
2021-12-23 07:00:00	QQQ	ETF	394.8	395.01	394.65	395.0	109536.0
2021-12-23 08:00:00	QQQ	ETF	394.8399	395.17	393.99	394.55	234790.0
2021-12-23 09:00:00	QQQ	ETF	394.62	395.72	394.14	395.54	3732819.0
2021-12-23 10:00:00	QQQ	ETF	395.54	396.96	395.29	396.93	3380260.0
2021-12-23 11:00:00	QQQ	ETF	396.95	397.61	396.83	397.5712	2750493.0
2021-12-23 12:00:00	QQQ	ETF	397.58	397.65	397.09	397.5746	1843876.0
2021-12-23 13:00:00	QQQ	ETF	397.57	397.95	397.09	397.75	1699436.0
2021-12-23 14:00:00	QQQ	ETF	397.76	398.0299	397.415	397.98	1668985.0
2021-12-23 15:00:00	QQQ	ETF	397.97	398.425	396.94	397.0	5381798.0
2021-12-23 16:00:00	QQQ	ETF	396.99	397.21	396.77	397.14	1331177.0
2021-12-23 17:00:00	QQQ	ETF	397.0	397.08	397.0	397.06	15178.0
2021-12-23 18:00:00	QQQ	ETF	397.08	397.12	396.91	396.91	10416.0
2021-12-23 19:00:00	QQQ	ETF	396.96	397.09	396.9	397.07	10665.0
2021-12-23 04:00:00	IWM	ETF	221.18	221.55	221.17	221.25	7831.0
2021-12-23 05:00:00	IWM	ETF	221.27	221.7	221.22	221.65	6867.0
2021-12-23 06:00:00	IWM	ETF	221.69	221.91	221.58	221.84	57037.0
2021-12-23 07:00:00	IWM	ETF	221.86	221.98	221.49	221.72	73354.0
2021-12-23 08:00:00	IWM	ETF	221.4901	221.98	221.13	221.33	61704.0
2021-12-23 09:00:00	IWM	ETF	221.36	221.56	220.34	220.83	3254477.0
2021-12-23 10:00:00	IWM	ETF	220.78	221.92	220.38	221.91	2074453.0
2021-12-23 11:00:00	IWM	ETF	221.901	222.14	221.5186	221.92	1587904.0
2021-12-23 12:00:00	IWM	ETF	221.91	222.375	221.77	222.21	1631242.0
2021-12-23 13:00:00	IWM	ETF	222.2085	222.8	222.2085	222.71	1099554.0
2021-12-23 14:00:00	IWM	ETF	222.73	222.77	222.43	222.47	1182931.0
2021-12-23 15:00:00	IWM	ETF	222.46	222.7104	221.99	222.06	3509825.0
2021-12-23 16:00:00	IWM	ETF	222.05	222.2	221.72	221.93	820721.0
2021-12-23 17:00:00	IWM	ETF	221.99	222.11	221.78	221.99	38127.0
2021-12-23 18:00:00	IWM	ETF	221.99	222.03	221.94	222.03	1777.0
2021-12-23 19:00:00	IWM	ETF	221.82	222.02	221.72	221.82	3768.0
2021-12-23 04:00:00	DIA	ETF	358.06	358.22	357.96	358.02	2045.0
2021-12-23 05:00:00	DIA	ETF	358.34	358.34	358.34	358.34	100.0

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

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