PREVIEW / etf_1hour / 2010-03-02

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-02.parquet
  size:    155 KB
  rows:    4,869

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
2010-03-02 04:00:00	SPY	ETF	111.81	111.93	111.81	111.93	5800.0
2010-03-02 05:00:00	SPY	ETF	111.98	111.98	111.98	111.98	3800.0
2010-03-02 06:00:00	SPY	ETF	112.18	112.68	112.18	112.41	138445.0
2010-03-02 07:00:00	SPY	ETF	112.45	112.58	112.39	112.53	684179.0
2010-03-02 08:00:00	SPY	ETF	112.53	112.65	112.38	112.5	1622467.0
2010-03-02 09:00:00	SPY	ETF	112.5	112.54	112.21	112.38	20211912.0
2010-03-02 10:00:00	SPY	ETF	112.38	112.57	112.1	112.46	25177924.0
2010-03-02 11:00:00	SPY	ETF	112.46	112.66	112.45	112.58	18593425.0
2010-03-02 12:00:00	SPY	ETF	112.58	112.64	112.35	112.48	10912628.0
2010-03-02 13:00:00	SPY	ETF	112.48	112.74	112.41	112.67	10333066.0
2010-03-02 14:00:00	SPY	ETF	112.67	112.74	112.19	112.23	24661157.0
2010-03-02 15:00:00	SPY	ETF	112.23	112.715	112.0	112.17	36895450.0
2010-03-02 16:00:00	SPY	ETF	112.16	112.51	112.16	112.3	11060874.0
2010-03-02 17:00:00	SPY	ETF	112.31	112.34	112.23	112.24	248849.0
2010-03-02 18:00:00	SPY	ETF	112.25	112.31	112.19	112.25	34378.0
2010-03-02 19:00:00	SPY	ETF	112.24	112.3	112.24	112.24	37299.0
2010-03-02 04:00:00	QQQ	ETF	45.43	45.43	45.39	45.39	2793.0
2010-03-02 05:00:00	QQQ	ETF	45.47	45.49	45.47	45.49	8000.0
2010-03-02 06:00:00	QQQ	ETF	45.5	45.63	45.5	45.54	56544.0
2010-03-02 07:00:00	QQQ	ETF	45.57	45.62	45.55	45.6	128318.0
2010-03-02 08:00:00	QQQ	ETF	45.59	45.63	45.56	45.61	728997.0
2010-03-02 09:00:00	QQQ	ETF	45.61	45.71	45.53	45.66	16694558.0
2010-03-02 10:00:00	QQQ	ETF	45.66	45.71	45.53	45.64	11522578.0
2010-03-02 11:00:00	QQQ	ETF	45.64	45.76	45.63	45.73	6580398.0
2010-03-02 12:00:00	QQQ	ETF	45.73	45.7475	45.61	45.69	6018234.0
2010-03-02 13:00:00	QQQ	ETF	45.69	45.83	45.67	45.82	4394174.0
2010-03-02 14:00:00	QQQ	ETF	45.82	45.85	45.55	45.55	7876410.0
2010-03-02 15:00:00	QQQ	ETF	45.56	45.63	45.45	45.54	13032536.0
2010-03-02 16:00:00	QQQ	ETF	45.55	45.62	45.54	45.6	4921622.0
2010-03-02 17:00:00	QQQ	ETF	45.62	45.62	45.55	45.58	49817.0
2010-03-02 18:00:00	QQQ	ETF	45.59	45.61	45.58	45.6	31685.0
2010-03-02 19:00:00	QQQ	ETF	45.6	45.6	45.58	45.6	35605.0
2010-03-02 06:00:00	IWM	ETF	64.55	64.57	64.52	64.52	1200.0
2010-03-02 07:00:00	IWM	ETF	64.54	64.62	64.47	64.62	101600.0
2010-03-02 08:00:00	IWM	ETF	64.6	64.63	64.54	64.58	163184.0
2010-03-02 09:00:00	IWM	ETF	64.59	64.73	64.4	64.66	6656928.0
2010-03-02 10:00:00	IWM	ETF	64.67	64.86	64.48	64.75	8676659.0
2010-03-02 11:00:00	IWM	ETF	64.75	64.99	64.745	64.96	5622090.0
2010-03-02 12:00:00	IWM	ETF	64.97	64.98	64.75	64.86	4008818.0
2010-03-02 13:00:00	IWM	ETF	64.859	65.1	64.75	65.08	3583526.0
2010-03-02 14:00:00	IWM	ETF	65.07	65.15	64.78	64.84	7704254.0
2010-03-02 15:00:00	IWM	ETF	64.84	64.96	64.68	64.75	11096689.0
2010-03-02 16:00:00	IWM	ETF	64.75	64.96	64.3163	64.91	5547256.0
2010-03-02 17:00:00	IWM	ETF	64.93	64.95	64.91	64.94	6514.0
2010-03-02 18:00:00	IWM	ETF	64.91	64.95	64.83	64.83	35170.0
2010-03-02 19:00:00	IWM	ETF	64.89	64.96	64.89	64.89	7600.0
2010-03-02 06:00:00	DIA	ETF	104.25	104.5	104.25	104.5	200.0
2010-03-02 07:00:00	DIA	ETF	104.51	104.54	104.47	104.54	5200.0
2010-03-02 08:00:00	DIA	ETF	104.53	104.59	104.46	104.52	30157.0
2010-03-02 09:00:00	DIA	ETF	104.52	104.64	104.32	104.3999	826871.0

> showing 50 of 4,869 rows — these rows as CSV

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