PREVIEW / etf_1hour / 2001-11-02

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-11-02.parquet
  size:    12 KB
  rows:    255

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-11-02 09:00:00	SPY	ETF	108.44	108.65	107.99	108.32	1981800.0
2001-11-02 10:00:00	SPY	ETF	108.2	108.66	107.87	108.32	4120600.0
2001-11-02 11:00:00	SPY	ETF	108.28	108.95	108.07	108.85	2555600.0
2001-11-02 12:00:00	SPY	ETF	108.85	109.35	108.81	109.27	2347000.0
2001-11-02 13:00:00	SPY	ETF	109.3	109.38	108.82	108.86	1331200.0
2001-11-02 14:00:00	SPY	ETF	108.89	109.29	108.76	109.1	1267300.0
2001-11-02 15:00:00	SPY	ETF	109.1	109.37	108.9	109.06	2006700.0
2001-11-02 16:00:00	SPY	ETF	109.07	109.25	108.92	109.25	1659200.0
2001-11-02 17:00:00	SPY	ETF	109.2	109.25	109.2	109.25	2000.0
2001-11-02 09:00:00	QQQ	ETF	35.27	35.75	35.1	35.5	10707500.0
2001-11-02 10:00:00	QQQ	ETF	35.5	35.57	34.89	35.06	14553800.0
2001-11-02 11:00:00	QQQ	ETF	35.05	35.61	34.92	35.59	11141100.0
2001-11-02 12:00:00	QQQ	ETF	35.6	35.85	35.5	35.71	6431200.0
2001-11-02 13:00:00	QQQ	ETF	35.73	35.8	35.38	35.41	6092600.0
2001-11-02 14:00:00	QQQ	ETF	35.4	35.65	35.3	35.51	6498700.0
2001-11-02 15:00:00	QQQ	ETF	35.46	35.67	35.3	35.5	6661400.0
2001-11-02 16:00:00	QQQ	ETF	35.49	35.61	35.35	35.6	1940100.0
2001-11-02 17:00:00	QQQ	ETF	35.59	35.62	35.5	35.6	19100.0
2001-11-02 18:00:00	QQQ	ETF	35.6	35.6	35.57	35.59	4600.0
2001-11-02 09:00:00	IWM	ETF	43.225	43.3	43.1	43.135	46200.0
2001-11-02 10:00:00	IWM	ETF	43.055	43.105	42.98	43.07	72000.0
2001-11-02 11:00:00	IWM	ETF	43.095	43.245	43.095	43.245	23200.0
2001-11-02 12:00:00	IWM	ETF	43.275	43.325	43.225	43.32	4600.0
2001-11-02 13:00:00	IWM	ETF	43.35	43.35	43.225	43.225	13600.0
2001-11-02 14:00:00	IWM	ETF	43.195	43.265	43.155	43.165	29400.0
2001-11-02 15:00:00	IWM	ETF	43.165	43.305	43.0	43.0	115000.0
2001-11-02 16:00:00	IWM	ETF	43.24	43.24	42.925	43.0	64600.0
2001-11-02 09:00:00	DIA	ETF	92.5	92.74	92.12	92.38	587900.0
2001-11-02 10:00:00	DIA	ETF	92.36	92.91	92.15	92.72	311400.0
2001-11-02 11:00:00	DIA	ETF	92.7	93.32	92.54	93.15	355300.0
2001-11-02 12:00:00	DIA	ETF	93.21	93.51	93.11	93.48	341900.0
2001-11-02 13:00:00	DIA	ETF	93.48	93.54	92.93	93.03	355400.0
2001-11-02 14:00:00	DIA	ETF	93.02	93.44	92.86	93.32	291500.0
2001-11-02 15:00:00	DIA	ETF	93.24	93.57	93.13	93.33	344800.0
2001-11-02 16:00:00	DIA	ETF	93.3	93.45	93.2	93.41	55400.0

> showing 35 of 255 rows — these rows as CSV

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