PREVIEW / etf_1hour / 2007-03-02

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-03-02.parquet
  size:    69 KB
  rows:    2,132

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
2007-03-02 04:00:00	SPY	ETF	140.67	140.67	140.55	140.55	29600.0
2007-03-02 05:00:00	SPY	ETF	140.79	140.83	140.65	140.65	44800.0
2007-03-02 06:00:00	SPY	ETF	140.63	140.65	140.09	140.16	63100.0
2007-03-02 07:00:00	SPY	ETF	140.16	140.41	139.8	140.17	1515100.0
2007-03-02 08:00:00	SPY	ETF	140.16	140.6	139.48	139.9	9177900.0
2007-03-02 09:00:00	SPY	ETF	139.87	140.45	139.84	140.08	15155700.0
2007-03-02 10:00:00	SPY	ETF	140.07	140.58	139.84	140.42	18357500.0
2007-03-02 11:00:00	SPY	ETF	140.42	140.66	140.0	140.11	12198600.0
2007-03-02 12:00:00	SPY	ETF	140.11	140.26	139.37	139.8	27538700.0
2007-03-02 13:00:00	SPY	ETF	139.8	139.84	138.96	139.33	24398000.0
2007-03-02 14:00:00	SPY	ETF	139.33	140.32	138.9	139.38	16703600.0
2007-03-02 15:00:00	SPY	ETF	139.38	139.72	138.93	138.98	21208300.0
2007-03-02 16:00:00	SPY	ETF	138.97	140.606	138.66	138.86	11410300.0
2007-03-02 17:00:00	SPY	ETF	138.86	138.91	138.85	138.85	252200.0
2007-03-02 18:00:00	SPY	ETF	138.85	138.95	138.85	138.9	23800.0
2007-03-02 19:00:00	SPY	ETF	138.9	138.95	138.87	138.87	9000.0
2007-03-02 20:00:00	SPY	ETF	138.87	138.87	138.87	138.87	100.0
2007-03-02 04:00:00	QQQ	ETF	43.02	43.02	43.02	43.02	200.0
2007-03-02 06:00:00	QQQ	ETF	43.01	43.01	42.93	42.93	12000.0
2007-03-02 07:00:00	QQQ	ETF	42.89	42.96	42.77	42.86	405504.0
2007-03-02 08:00:00	QQQ	ETF	42.89	42.89	42.56	42.77	7651675.0
2007-03-02 09:00:00	QQQ	ETF	42.77	43.11	42.75	42.95	20938233.0
2007-03-02 10:00:00	QQQ	ETF	42.94	43.14	42.86	43.05	32338100.0
2007-03-02 11:00:00	QQQ	ETF	43.06	43.12	42.86	42.94	15010800.0
2007-03-02 12:00:00	QQQ	ETF	42.94	43.0	42.6	42.75	31289000.0
2007-03-02 13:00:00	QQQ	ETF	42.75	42.78	42.51	42.61	24653100.0
2007-03-02 14:00:00	QQQ	ETF	42.6	42.82	42.52	42.68	20888200.0
2007-03-02 15:00:00	QQQ	ETF	42.67	43.54	42.47	42.48	23467300.0
2007-03-02 16:00:00	QQQ	ETF	42.48	42.49	42.34	42.44	4143658.0
2007-03-02 17:00:00	QQQ	ETF	42.44	42.5	42.44	42.48	145803.0
2007-03-02 18:00:00	QQQ	ETF	42.45	42.47	42.39	42.44	26833.0
2007-03-02 19:00:00	QQQ	ETF	42.45	42.49	42.43	42.43	33711.0
2007-03-02 06:00:00	IWM	ETF	78.32	78.32	78.32	78.32	200.0
2007-03-02 07:00:00	IWM	ETF	78.0	78.0	78.0	78.0	5000.0
2007-03-02 08:00:00	IWM	ETF	78.05	78.23	77.57	77.87	2394200.0
2007-03-02 09:00:00	IWM	ETF	77.89	78.38	77.85	77.99	8882400.0
2007-03-02 10:00:00	IWM	ETF	77.99	78.29	77.86	78.17	9506400.0
2007-03-02 11:00:00	IWM	ETF	78.17	78.36	77.96	78.07	7149800.0
2007-03-02 12:00:00	IWM	ETF	78.07	78.11	77.28	77.57	24375900.0
2007-03-02 13:00:00	IWM	ETF	77.57	77.57	77.12	77.39	12054700.0
2007-03-02 14:00:00	IWM	ETF	77.4	77.62	77.1	77.36	11759200.0
2007-03-02 15:00:00	IWM	ETF	77.37	77.59	76.9	76.9	15280400.0
2007-03-02 16:00:00	IWM	ETF	76.89	77.33	76.75	76.87	531600.0
2007-03-02 17:00:00	IWM	ETF	76.8	76.89	76.8	76.86	4200.0
2007-03-02 18:00:00	IWM	ETF	76.81	76.81	76.8	76.8	1000.0
2007-03-02 19:00:00	IWM	ETF	76.8	76.8	76.8	76.8	1500.0
2007-03-02 07:00:00	DIA	ETF	121.98	122.2	121.75	122.11	11300.0
2007-03-02 08:00:00	DIA	ETF	122.13	122.19	121.57	121.85	105600.0
2007-03-02 09:00:00	DIA	ETF	121.82	122.35	121.78	122.05	1807800.0
2007-03-02 10:00:00	DIA	ETF	122.02	122.47	121.83	122.32	1703700.0

> showing 50 of 2,132 rows — these rows as CSV

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