PREVIEW / etf_1hour / 2006-02-10

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-02-10.parquet
  size:    40 KB
  rows:    1,211

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-10 07:00:00	SPY	ETF	126.51	126.57	126.51	126.57	3000.0
2006-02-10 08:00:00	SPY	ETF	126.55	126.67	126.37	126.42	683400.0
2006-02-10 09:00:00	SPY	ETF	126.42	126.6	126.28	126.5	6089500.0
2006-02-10 10:00:00	SPY	ETF	126.5	126.56	125.58	125.74	12431700.0
2006-02-10 11:00:00	SPY	ETF	125.73	126.1	125.63	125.95	8025200.0
2006-02-10 12:00:00	SPY	ETF	125.95	126.34	125.89	126.06	8799800.0
2006-02-10 13:00:00	SPY	ETF	126.05	126.3	125.9	126.28	3916600.0
2006-02-10 14:00:00	SPY	ETF	126.27	126.84	126.2	126.74	10237000.0
2006-02-10 15:00:00	SPY	ETF	126.74	127.13	126.73	126.82	9620600.0
2006-02-10 16:00:00	SPY	ETF	126.82	126.87	126.15	126.65	2267700.0
2006-02-10 17:00:00	SPY	ETF	126.64	126.66	126.59	126.59	8200.0
2006-02-10 18:00:00	SPY	ETF	126.57	126.57	126.57	126.57	400.0
2006-02-10 19:00:00	SPY	ETF	126.56	126.56	126.56	126.56	200.0
2006-02-10 09:00:00	QQQ	ETF	40.68	40.72	40.46	40.56	13928600.0
2006-02-10 10:00:00	QQQ	ETF	40.55	40.56	40.26	40.37	21555000.0
2006-02-10 11:00:00	QQQ	ETF	40.37	40.53	40.33	40.47	12456300.0
2006-02-10 12:00:00	QQQ	ETF	40.47	40.6	40.44	40.48	8131400.0
2006-02-10 13:00:00	QQQ	ETF	40.48	40.58	40.45	40.55	5518600.0
2006-02-10 14:00:00	QQQ	ETF	40.56	40.92	40.5	40.86	18332500.0
2006-02-10 15:00:00	QQQ	ETF	40.86	41.06	40.84	40.95	17597800.0
2006-02-10 08:00:00	IWM	ETF	71.32	71.32	71.25	71.25	148000.0
2006-02-10 09:00:00	IWM	ETF	71.27	71.27	70.67	70.93	3287400.0
2006-02-10 10:00:00	IWM	ETF	70.93	70.93	70.37	70.52	7684400.0
2006-02-10 11:00:00	IWM	ETF	70.51	70.72	70.43	70.66	5045400.0
2006-02-10 12:00:00	IWM	ETF	70.66	70.93	70.63	70.64	1908000.0
2006-02-10 13:00:00	IWM	ETF	70.64	70.87	70.59	70.86	2647900.0
2006-02-10 14:00:00	IWM	ETF	70.88	71.28	70.76	71.27	3089800.0
2006-02-10 15:00:00	IWM	ETF	71.26	71.43	71.2	71.27	6575900.0
2006-02-10 16:00:00	IWM	ETF	71.26	71.31	71.14	71.15	278200.0
2006-02-10 17:00:00	IWM	ETF	71.22	71.22	71.22	71.22	1800.0
2006-02-10 18:00:00	IWM	ETF	71.16	71.16	71.16	71.16	200.0
2006-02-10 19:00:00	IWM	ETF	71.13	71.13	71.13	71.13	100.0
2006-02-10 08:00:00	DIA	ETF	109.0	109.0	108.84	108.89	108300.0
2006-02-10 09:00:00	DIA	ETF	108.81	108.97	108.74	108.94	592500.0
2006-02-10 10:00:00	DIA	ETF	108.93	108.96	108.23	108.32	1644000.0
2006-02-10 11:00:00	DIA	ETF	108.3	108.56	108.22	108.46	821600.0
2006-02-10 12:00:00	DIA	ETF	108.47	108.85	108.44	108.66	751600.0
2006-02-10 13:00:00	DIA	ETF	108.64	108.87	108.55	108.83	753500.0
2006-02-10 14:00:00	DIA	ETF	108.81	109.31	108.75	109.22	1560000.0
2006-02-10 15:00:00	DIA	ETF	109.24	109.51	109.16	109.27	1145600.0
2006-02-10 16:00:00	DIA	ETF	109.28	109.28	109.09	109.11	202300.0
2006-02-10 08:00:00	GLD	ETF	55.77	55.8	55.57	55.68	48700.0
2006-02-10 09:00:00	GLD	ETF	55.65	55.78	55.531	55.61	496800.0
2006-02-10 10:00:00	GLD	ETF	55.61	55.62	54.77	54.83	1177000.0
2006-02-10 11:00:00	GLD	ETF	54.81	54.84	54.46	54.6	883500.0
2006-02-10 12:00:00	GLD	ETF	54.62	54.83	54.42	54.63	697100.0
2006-02-10 13:00:00	GLD	ETF	54.64	54.869	54.6	54.8	202900.0
2006-02-10 14:00:00	GLD	ETF	54.8	54.94	54.79	54.84	282500.0
2006-02-10 15:00:00	GLD	ETF	54.85	54.9	54.78	54.79	332000.0
2006-02-10 16:00:00	GLD	ETF	54.83	54.83	54.7	54.7	3100.0

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

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