PREVIEW / etf_1hour / 2001-06-15

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-06-15.parquet
  size:    12 KB
  rows:    235

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
2001-06-15 09:00:00	SPY	ETF	120.91	121.47	120.7	120.7	1952100.0
2001-06-15 10:00:00	SPY	ETF	120.7	122.18	120.4	121.8	2542100.0
2001-06-15 11:00:00	SPY	ETF	121.72	122.36	121.56	121.72	1442800.0
2001-06-15 12:00:00	SPY	ETF	121.63	122.4	121.61	122.31	889000.0
2001-06-15 13:00:00	SPY	ETF	122.34	122.36	121.85	122.3	725200.0
2001-06-15 14:00:00	SPY	ETF	122.3	122.3	121.5	121.73	489200.0
2001-06-15 15:00:00	SPY	ETF	121.75	122.21	121.32	121.62	1662000.0
2001-06-15 16:00:00	SPY	ETF	121.62	122.01	121.56	121.91	389100.0
2001-06-15 17:00:00	SPY	ETF	121.35	121.35	121.35	121.35	200.0
2001-06-15 09:00:00	QQQ	ETF	41.8	42.3	41.5	41.5	12532200.0
2001-06-15 10:00:00	QQQ	ETF	41.56	42.44	41.28	42.17	16988500.0
2001-06-15 11:00:00	QQQ	ETF	42.16	43.07	42.13	42.37	17868200.0
2001-06-15 12:00:00	QQQ	ETF	42.39	43.0	42.3	42.89	7426500.0
2001-06-15 13:00:00	QQQ	ETF	42.85	42.89	42.4	42.75	5919300.0
2001-06-15 14:00:00	QQQ	ETF	42.75	42.79	42.0	42.3	7390200.0
2001-06-15 15:00:00	QQQ	ETF	42.29	42.64	42.1	42.49	10139000.0
2001-06-15 16:00:00	QQQ	ETF	42.46	42.78	42.44	42.57	1679700.0
2001-06-15 17:00:00	QQQ	ETF	42.59	42.7	42.56	42.7	23700.0
2001-06-15 18:00:00	QQQ	ETF	42.59	42.64	42.56	42.64	5500.0
2001-06-15 09:00:00	IWM	ETF	49.0	49.275	48.925	49.105	81200.0
2001-06-15 10:00:00	IWM	ETF	49.175	49.325	48.965	49.325	59400.0
2001-06-15 11:00:00	IWM	ETF	49.305	49.515	49.305	49.38	143200.0
2001-06-15 12:00:00	IWM	ETF	49.41	49.52	49.37	49.5	21200.0
2001-06-15 13:00:00	IWM	ETF	49.5	49.575	49.45	49.45	81200.0
2001-06-15 14:00:00	IWM	ETF	49.455	49.5	49.345	49.345	76400.0
2001-06-15 15:00:00	IWM	ETF	49.35	49.425	49.25	49.285	339400.0
2001-06-15 16:00:00	IWM	ETF	49.28	49.375	49.28	49.375	6800.0
2001-06-15 09:00:00	DIA	ETF	106.4	106.8	106.0	106.0	947700.0
2001-06-15 10:00:00	DIA	ETF	106.0	107.03	105.65	106.8	1048100.0
2001-06-15 11:00:00	DIA	ETF	106.8	107.15	106.46	106.53	585500.0
2001-06-15 12:00:00	DIA	ETF	106.64	107.29	106.64	107.29	387000.0
2001-06-15 13:00:00	DIA	ETF	107.2	107.27	106.82	107.11	503100.0
2001-06-15 14:00:00	DIA	ETF	107.1	107.1	106.5	106.62	203200.0
2001-06-15 15:00:00	DIA	ETF	106.65	106.99	106.09	106.35	283700.0
2001-06-15 16:00:00	DIA	ETF	106.34	106.7	106.29	106.6	44700.0

> showing 35 of 235 rows — these rows as CSV

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