PREVIEW / etf_1hour / 2006-02-07

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-02-07.parquet
  size:    41 KB
  rows:    1,248

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
2006-02-07 06:00:00	SPY	ETF	126.42	126.42	126.42	126.42	1500.0
2006-02-07 07:00:00	SPY	ETF	126.4	126.4	126.26	126.32	322800.0
2006-02-07 08:00:00	SPY	ETF	126.34	126.41	126.27	126.38	276700.0
2006-02-07 09:00:00	SPY	ETF	126.38	126.66	126.18	126.37	5469400.0
2006-02-07 10:00:00	SPY	ETF	126.37	126.6	125.8	126.02	16575400.0
2006-02-07 11:00:00	SPY	ETF	126.02	126.41	126.0	126.14	7494900.0
2006-02-07 12:00:00	SPY	ETF	126.14	126.22	125.89	126.01	5458800.0
2006-02-07 13:00:00	SPY	ETF	126.02	126.03	125.5	125.74	9001700.0
2006-02-07 14:00:00	SPY	ETF	125.74	125.92	125.42	125.53	10258600.0
2006-02-07 15:00:00	SPY	ETF	125.53	125.69	125.4	125.57	13696200.0
2006-02-07 16:00:00	SPY	ETF	125.57	125.68	125.48	125.68	804100.0
2006-02-07 17:00:00	SPY	ETF	125.68	125.77	125.64	125.71	486100.0
2006-02-07 18:00:00	SPY	ETF	125.75	125.75	125.69	125.7	17300.0
2006-02-07 19:00:00	SPY	ETF	125.74	125.74	125.73	125.73	3000.0
2006-02-07 09:00:00	QQQ	ETF	40.74	40.93	40.1	40.76	8593400.0
2006-02-07 10:00:00	QQQ	ETF	40.76	40.88	40.53	40.67	15553900.0
2006-02-07 11:00:00	QQQ	ETF	40.67	40.82	40.1	40.69	10183100.0
2006-02-07 12:00:00	QQQ	ETF	40.69	40.72	40.55	40.64	7548800.0
2006-02-07 13:00:00	QQQ	ETF	40.65	40.65	40.44	40.56	11184000.0
2006-02-07 14:00:00	QQQ	ETF	40.55	40.68	40.48	40.55	9885300.0
2006-02-07 15:00:00	QQQ	ETF	40.54	40.67	40.49	40.65	13787600.0
2006-02-07 07:00:00	IWM	ETF	72.29	72.29	72.29	72.29	800.0
2006-02-07 08:00:00	IWM	ETF	72.35	72.35	72.2	72.25	33100.0
2006-02-07 09:00:00	IWM	ETF	72.26	72.59	72.12	72.34	5165200.0
2006-02-07 10:00:00	IWM	ETF	72.34	72.41	71.71	71.8501	4697700.0
2006-02-07 11:00:00	IWM	ETF	71.85	72.09	71.77	71.86	2879400.0
2006-02-07 12:00:00	IWM	ETF	71.86	71.89	71.44	71.52	5394800.0
2006-02-07 13:00:00	IWM	ETF	71.51	71.52	71.15	71.36	6137500.0
2006-02-07 14:00:00	IWM	ETF	71.35	72.3323	71.27	71.35	6979900.0
2006-02-07 15:00:00	IWM	ETF	71.34	72.33	71.18	71.2301	7466700.0
2006-02-07 16:00:00	IWM	ETF	71.25	71.36	71.11	71.33	2274600.0
2006-02-07 17:00:00	IWM	ETF	71.33	71.41	71.33	71.41	322000.0
2006-02-07 08:00:00	DIA	ETF	107.8	107.94	107.8	107.94	27300.0
2006-02-07 09:00:00	DIA	ETF	107.9	108.21	107.82	108.05	598200.0
2006-02-07 10:00:00	DIA	ETF	108.04	108.17	107.57	107.79	1825900.0
2006-02-07 11:00:00	DIA	ETF	107.78	108.17	107.77	108.03	1275200.0
2006-02-07 12:00:00	DIA	ETF	108.0399	108.08	107.7	107.79	1942000.0
2006-02-07 13:00:00	DIA	ETF	107.79	107.8	107.37	107.57	1693300.0
2006-02-07 14:00:00	DIA	ETF	107.59	107.76	107.42	107.42	899500.0
2006-02-07 15:00:00	DIA	ETF	107.43	107.64	107.32	107.5	1424700.0
2006-02-07 16:00:00	DIA	ETF	107.5	107.56	107.48	107.48	1611300.0
2006-02-07 17:00:00	DIA	ETF	107.6	107.6	107.53	107.53	900.0
2006-02-07 18:00:00	DIA	ETF	107.65	107.65	107.65	107.65	300.0
2006-02-07 07:00:00	GLD	ETF	56.49	56.49	56.35	56.37	9400.0
2006-02-07 08:00:00	GLD	ETF	56.41	56.41	55.87	56.0	99500.0
2006-02-07 09:00:00	GLD	ETF	55.98	56.04	55.42	55.63	2138300.0
2006-02-07 10:00:00	GLD	ETF	55.62	55.65	55.23	55.43	1577800.0
2006-02-07 11:00:00	GLD	ETF	55.432	55.5	55.25	55.3499	648500.0
2006-02-07 12:00:00	GLD	ETF	55.32	55.32	54.88	54.93	1751600.0
2006-02-07 13:00:00	GLD	ETF	54.94	54.94	54.72	54.76	1416400.0

> showing 50 of 1,248 rows — these rows as CSV

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