PREVIEW / etf_1hour / 2022-11-08

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-11-08.parquet
  size:    465 KB
  rows:    17,053

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-11-08 04:00:00	SPY	ETF	379.39	380.68	379.03	380.64	50197.0
2022-11-08 05:00:00	SPY	ETF	380.64	381.08	380.07	380.07	15897.0
2022-11-08 06:00:00	SPY	ETF	380.24	381.54	380.17	381.54	65640.0
2022-11-08 07:00:00	SPY	ETF	381.43	381.46	380.29	380.88	187150.0
2022-11-08 08:00:00	SPY	ETF	381.21	381.49	378.86	381.14	384071.0
2022-11-08 09:00:00	SPY	ETF	381.1101	381.81	379.53	380.39	5321521.0
2022-11-08 10:00:00	SPY	ETF	380.38	383.32	380.32	383.06	8972760.0
2022-11-08 11:00:00	SPY	ETF	383.11	385.12	382.51	384.54	7970600.0
2022-11-08 12:00:00	SPY	ETF	384.54	384.775	383.93	384.47	4566094.0
2022-11-08 13:00:00	SPY	ETF	384.48	385.0	380.46	380.75	9048444.0
2022-11-08 14:00:00	SPY	ETF	380.74	381.34	377.72	380.6	11020372.0
2022-11-08 15:00:00	SPY	ETF	380.61	384.05	380.52	381.97	14927489.0
2022-11-08 16:00:00	SPY	ETF	381.98	382.548	380.98	381.71	6426610.0
2022-11-08 17:00:00	SPY	ETF	381.73	381.85	381.58	381.7	114753.0
2022-11-08 18:00:00	SPY	ETF	381.7	382.81	381.48	382.7	136755.0
2022-11-08 19:00:00	SPY	ETF	382.54	382.54	381.55	381.8	105443.0
2022-11-08 04:00:00	QQQ	ETF	267.49	268.62	267.09	268.55	40893.0
2022-11-08 05:00:00	QQQ	ETF	268.59	269.03	268.1	268.22	31017.0
2022-11-08 06:00:00	QQQ	ETF	268.15	269.49	268.15	269.39	58106.0
2022-11-08 07:00:00	QQQ	ETF	269.29	269.35	268.55	269.02	245582.0
2022-11-08 08:00:00	QQQ	ETF	269.08	269.49	266.8	269.23	406563.0
2022-11-08 09:00:00	QQQ	ETF	269.23	269.77	267.4183	268.68	5510041.0
2022-11-08 10:00:00	QQQ	ETF	268.7	270.59	268.24	270.365	7028031.0
2022-11-08 11:00:00	QQQ	ETF	270.37	272.85	269.942	272.06	5492161.0
2022-11-08 12:00:00	QQQ	ETF	272.07	272.49	271.54	272.11	3763450.0
2022-11-08 13:00:00	QQQ	ETF	272.12	272.57	267.97	268.29	7308244.0
2022-11-08 14:00:00	QQQ	ETF	268.2399	268.8001	265.52	267.78	9494669.0
2022-11-08 15:00:00	QQQ	ETF	267.785	271.09	267.68	269.54	9171188.0
2022-11-08 16:00:00	QQQ	ETF	269.53	269.9623	268.83	269.51	2366975.0
2022-11-08 17:00:00	QQQ	ETF	269.46	269.54	269.23	269.4	74924.0
2022-11-08 18:00:00	QQQ	ETF	269.44	270.4	269.35	270.32	145805.0
2022-11-08 19:00:00	QQQ	ETF	270.25	270.25	269.5	269.75	91956.0
2022-11-08 04:00:00	IWM	ETF	179.16	180.14	179.14	180.05	12185.0
2022-11-08 05:00:00	IWM	ETF	180.08	180.28	179.9	179.92	23436.0
2022-11-08 06:00:00	IWM	ETF	179.92	180.59	179.9	180.59	38563.0
2022-11-08 07:00:00	IWM	ETF	180.47	180.47	179.87	180.19	26786.0
2022-11-08 08:00:00	IWM	ETF	180.1375	180.46	179.5796	180.15	61917.0
2022-11-08 09:00:00	IWM	ETF	180.16	180.51	178.51	179.16	1506974.0
2022-11-08 10:00:00	IWM	ETF	179.13	180.96	179.07	180.84	2503001.0
2022-11-08 11:00:00	IWM	ETF	180.88	181.95	180.61	181.5	2174175.0
2022-11-08 12:00:00	IWM	ETF	181.51	181.66	180.81	180.9	1198003.0
2022-11-08 13:00:00	IWM	ETF	180.89	181.21	178.88	179.07	1997747.0
2022-11-08 14:00:00	IWM	ETF	179.03	179.2	177.36	178.75	2369317.0
2022-11-08 15:00:00	IWM	ETF	178.75	180.29	178.65	179.55	3392852.0
2022-11-08 16:00:00	IWM	ETF	179.56	179.61	179.03	179.49	907102.0
2022-11-08 17:00:00	IWM	ETF	179.46	179.58	179.39	179.49	22871.0
2022-11-08 18:00:00	IWM	ETF	179.45	180.05	179.41	179.95	42315.0
2022-11-08 19:00:00	IWM	ETF	179.9	179.9	179.29	179.36	28475.0
2022-11-08 04:00:00	DIA	ETF	327.79	328.98	327.79	328.98	1100.0
2022-11-08 05:00:00	DIA	ETF	328.92	328.92	328.67	328.67	4412.0

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

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