PREVIEW / etf_1hour / 2001-06-18

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-06-18.parquet
  size:    11 KB
  rows:    225

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-18 09:00:00	SPY	ETF	121.65	122.04	121.39	121.4	1313100.0
2001-06-18 10:00:00	SPY	ETF	121.49	122.33	121.38	122.33	1517600.0
2001-06-18 11:00:00	SPY	ETF	122.35	122.44	121.43	121.45	1652700.0
2001-06-18 12:00:00	SPY	ETF	121.49	121.64	121.23	121.43	706500.0
2001-06-18 13:00:00	SPY	ETF	121.36	121.8	121.36	121.67	423400.0
2001-06-18 14:00:00	SPY	ETF	121.69	121.79	121.02	121.15	466900.0
2001-06-18 15:00:00	SPY	ETF	121.06	121.35	120.95	121.08	870900.0
2001-06-18 16:00:00	SPY	ETF	121.02	121.45	120.91	121.25	495500.0
2001-06-18 17:00:00	SPY	ETF	121.04	121.39	121.04	121.39	3209900.0
2001-06-18 18:00:00	SPY	ETF	121.55	121.73	121.5	121.73	7800.0
2001-06-18 09:00:00	QQQ	ETF	42.64	43.17	42.16	42.24	10698800.0
2001-06-18 10:00:00	QQQ	ETF	42.24	42.73	41.89	42.73	12502500.0
2001-06-18 11:00:00	QQQ	ETF	42.73	42.8	42.08	42.2	5658900.0
2001-06-18 12:00:00	QQQ	ETF	42.15	42.26	41.86	41.95	5094200.0
2001-06-18 13:00:00	QQQ	ETF	41.98	42.3	41.83	42.05	5001400.0
2001-06-18 14:00:00	QQQ	ETF	42.05	42.24	41.45	41.52	8784100.0
2001-06-18 15:00:00	QQQ	ETF	41.59	41.76	41.4	41.58	8623200.0
2001-06-18 16:00:00	QQQ	ETF	41.58	42.39	41.46	42.15	3791800.0
2001-06-18 17:00:00	QQQ	ETF	42.13	42.25	42.06	42.25	458700.0
2001-06-18 18:00:00	QQQ	ETF	42.25	42.47	42.2	42.4	206400.0
2001-06-18 09:00:00	IWM	ETF	49.25	49.45	49.185	49.185	42800.0
2001-06-18 10:00:00	IWM	ETF	49.255	49.435	49.255	49.435	197000.0
2001-06-18 11:00:00	IWM	ETF	49.415	49.5	49.28	49.28	65400.0
2001-06-18 12:00:00	IWM	ETF	49.27	49.285	49.12	49.135	77000.0
2001-06-18 13:00:00	IWM	ETF	49.15	49.175	49.13	49.135	35600.0
2001-06-18 14:00:00	IWM	ETF	49.16	49.16	48.9	48.915	74200.0
2001-06-18 15:00:00	IWM	ETF	48.9	49.0	48.75	48.9	136800.0
2001-06-18 16:00:00	IWM	ETF	48.8	49.0	48.8	49.0	20200.0
2001-06-18 09:00:00	DIA	ETF	106.4	106.6	106.2	106.27	417200.0
2001-06-18 10:00:00	DIA	ETF	106.29	107.1	106.26	107.09	654600.0
2001-06-18 11:00:00	DIA	ETF	107.1	107.2	106.51	106.66	272300.0
2001-06-18 12:00:00	DIA	ETF	106.6	106.85	106.42	106.72	417700.0
2001-06-18 13:00:00	DIA	ETF	106.72	107.15	106.7	107.03	163300.0
2001-06-18 14:00:00	DIA	ETF	107.0	107.11	106.38	106.54	272000.0
2001-06-18 15:00:00	DIA	ETF	106.45	106.8	106.4	106.57	102900.0
2001-06-18 16:00:00	DIA	ETF	106.5	107.03	106.47	107.0	64200.0

> showing 36 of 225 rows — these rows as CSV

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