PREVIEW / etf_1hour / 2001-07-17

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-07-17.parquet
  size:    11 KB
  rows:    217

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-07-17 09:00:00	SPY	ETF	120.2	120.63	119.83	120.1	748200.0
2001-07-17 10:00:00	SPY	ETF	120.1	121.04	119.87	120.75	1212700.0
2001-07-17 11:00:00	SPY	ETF	120.7	120.89	120.35	120.4	831600.0
2001-07-17 12:00:00	SPY	ETF	120.4	120.65	120.16	120.65	460600.0
2001-07-17 13:00:00	SPY	ETF	120.6	121.14	120.42	121.14	621600.0
2001-07-17 14:00:00	SPY	ETF	121.05	121.94	121.05	121.68	1696700.0
2001-07-17 15:00:00	SPY	ETF	121.66	121.93	121.52	121.67	1100100.0
2001-07-17 16:00:00	SPY	ETF	121.75	122.71	121.5	121.8	609500.0
2001-07-17 17:00:00	SPY	ETF	121.65	121.79	121.5	121.79	22000.0
2001-07-17 18:00:00	SPY	ETF	121.79	121.79	121.79	121.79	500.0
2001-07-17 09:00:00	QQQ	ETF	41.82	42.15	41.54	41.76	10435300.0
2001-07-17 10:00:00	QQQ	ETF	41.79	42.6	41.56	42.27	11958600.0
2001-07-17 11:00:00	QQQ	ETF	42.27	42.5	42.06	42.15	5135900.0
2001-07-17 12:00:00	QQQ	ETF	42.15	42.25	41.88	42.2	3199800.0
2001-07-17 13:00:00	QQQ	ETF	42.18	42.67	41.99	42.64	7328500.0
2001-07-17 14:00:00	QQQ	ETF	42.6	43.05	42.55	42.85	7013400.0
2001-07-17 15:00:00	QQQ	ETF	42.87	43.12	42.7	43.08	9101100.0
2001-07-17 16:00:00	QQQ	ETF	43.06	44.0	42.75	42.9	3236200.0
2001-07-17 17:00:00	QQQ	ETF	42.86	43.05	42.86	43.05	235200.0
2001-07-17 18:00:00	QQQ	ETF	43.05	43.14	42.91	42.91	48700.0
2001-07-17 09:00:00	IWM	ETF	48.05	48.24	47.95	48.01	26000.0
2001-07-17 10:00:00	IWM	ETF	48.05	48.25	47.995	48.25	53200.0
2001-07-17 11:00:00	IWM	ETF	48.25	48.29	48.125	48.22	39200.0
2001-07-17 12:00:00	IWM	ETF	48.1	48.2	48.1	48.175	85600.0
2001-07-17 13:00:00	IWM	ETF	48.135	48.36	48.13	48.36	77200.0
2001-07-17 14:00:00	IWM	ETF	48.34	48.625	48.34	48.595	76800.0
2001-07-17 15:00:00	IWM	ETF	48.69	48.905	48.69	48.905	171800.0
2001-07-17 16:00:00	IWM	ETF	48.905	49.025	48.9	49.025	22000.0
2001-07-17 09:00:00	DIA	ETF	104.6	105.0	104.45	104.91	178400.0
2001-07-17 10:00:00	DIA	ETF	104.77	105.62	104.62	105.41	250800.0
2001-07-17 11:00:00	DIA	ETF	105.33	105.49	105.06	105.15	82300.0
2001-07-17 12:00:00	DIA	ETF	105.15	105.44	105.11	105.43	118500.0
2001-07-17 13:00:00	DIA	ETF	105.43	105.71	105.31	105.7	142200.0
2001-07-17 14:00:00	DIA	ETF	105.72	106.49	105.72	106.2	184700.0
2001-07-17 15:00:00	DIA	ETF	106.36	106.46	106.07	106.18	446700.0
2001-07-17 16:00:00	DIA	ETF	106.15	106.2	106.05	106.19	32300.0

> showing 36 of 217 rows — these rows as CSV

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