PREVIEW / etf_1hour / 2007-02-06

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-02-06.parquet
  size:    65 KB
  rows:    2,028

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-02-06 07:00:00	SPY	ETF	145.03	145.08	145.0	145.05	14600.0
2007-02-06 08:00:00	SPY	ETF	145.05	145.1	144.98	145.01	754300.0
2007-02-06 09:00:00	SPY	ETF	145.0	145.03	144.78	144.87	6099600.0
2007-02-06 10:00:00	SPY	ETF	144.86	144.92	144.54	144.56	10098700.0
2007-02-06 11:00:00	SPY	ETF	144.56	144.66	144.33	144.34	16752900.0
2007-02-06 12:00:00	SPY	ETF	144.33	144.52	144.33	144.41	3697700.0
2007-02-06 13:00:00	SPY	ETF	144.42	144.72	144.42	144.67	5480800.0
2007-02-06 14:00:00	SPY	ETF	144.67	144.83	144.53	144.8028	6241900.0
2007-02-06 15:00:00	SPY	ETF	144.81	144.92	144.72	144.79	5868900.0
2007-02-06 16:00:00	SPY	ETF	144.79	145.0	144.75	144.98	1140900.0
2007-02-06 17:00:00	SPY	ETF	144.99	145.01	144.93	144.93	34000.0
2007-02-06 18:00:00	SPY	ETF	144.98	144.98	144.95	144.97	2100.0
2007-02-06 19:00:00	SPY	ETF	144.96	144.97	144.95	144.97	1500.0
2007-02-06 05:00:00	QQQ	ETF	44.2	44.2	44.2	44.2	400.0
2007-02-06 07:00:00	QQQ	ETF	44.2	44.23	44.2	44.22	40069.0
2007-02-06 08:00:00	QQQ	ETF	44.22	44.22	44.17	44.19	361009.0
2007-02-06 09:00:00	QQQ	ETF	44.19	44.23	44.07	44.11	14946673.0
2007-02-06 10:00:00	QQQ	ETF	44.11	44.12	43.71	43.72	24353000.0
2007-02-06 11:00:00	QQQ	ETF	43.72	43.83	43.64	43.64	18788500.0
2007-02-06 12:00:00	QQQ	ETF	43.65	43.78	43.64	43.73	6792500.0
2007-02-06 13:00:00	QQQ	ETF	43.74	43.98	43.73	43.91	16965800.0
2007-02-06 14:00:00	QQQ	ETF	43.91	44.04	43.81	44.04	8159600.0
2007-02-06 15:00:00	QQQ	ETF	44.05	44.12	44.03	44.06	13517600.0
2007-02-06 16:00:00	QQQ	ETF	44.07	44.3	44.01	44.27	8069456.0
2007-02-06 17:00:00	QQQ	ETF	44.27	44.29	44.21	44.25	464489.0
2007-02-06 18:00:00	QQQ	ETF	44.25	44.25	44.21	44.24	37070.0
2007-02-06 19:00:00	QQQ	ETF	44.23	44.25	44.23	44.25	52521.0
2007-02-06 08:00:00	IWM	ETF	80.35	80.36	80.29	80.32	43900.0
2007-02-06 09:00:00	IWM	ETF	80.31	80.39	80.15	80.21	2194900.0
2007-02-06 10:00:00	IWM	ETF	80.2	80.26	79.92	79.94	5759000.0
2007-02-06 11:00:00	IWM	ETF	79.94	80.06	79.8	79.8	4752600.0
2007-02-06 12:00:00	IWM	ETF	79.8	80.0	79.79	79.92	2736700.0
2007-02-06 13:00:00	IWM	ETF	79.93	80.3	79.92	80.22	4087100.0
2007-02-06 14:00:00	IWM	ETF	80.22	80.32	80.12	80.29	4094700.0
2007-02-06 15:00:00	IWM	ETF	80.3	80.42	80.29	80.41	5639700.0
2007-02-06 16:00:00	IWM	ETF	80.41	80.56	80.39	80.55	563700.0
2007-02-06 17:00:00	IWM	ETF	80.55	80.57	80.52	80.53	79700.0
2007-02-06 18:00:00	IWM	ETF	80.53	80.55	80.47	80.47	8000.0
2007-02-06 08:00:00	DIA	ETF	126.77	126.8	126.69	126.69	16500.0
2007-02-06 09:00:00	DIA	ETF	126.71	126.79	126.53	126.59	945900.0
2007-02-06 10:00:00	DIA	ETF	126.59	126.68	126.45	126.46	1039700.0
2007-02-06 11:00:00	DIA	ETF	126.46	126.54	126.31	126.31	863400.0
2007-02-06 12:00:00	DIA	ETF	126.32	126.43	126.3	126.36	525000.0
2007-02-06 13:00:00	DIA	ETF	126.36	126.59	126.36	126.52	634900.0
2007-02-06 14:00:00	DIA	ETF	126.52	126.63	126.41	126.62	542000.0
2007-02-06 15:00:00	DIA	ETF	126.62	126.79	126.52	126.62	730300.0
2007-02-06 16:00:00	DIA	ETF	126.63	126.79	126.6	126.76	1860600.0
2007-02-06 17:00:00	DIA	ETF	126.65	126.65	126.65	126.65	100.0
2007-02-06 18:00:00	DIA	ETF	126.7	126.7	126.7	126.7	900.0
2007-02-06 08:00:00	GLD	ETF	64.87	65.31	64.8	65.19	272500.0

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

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