PREVIEW / etf_1hour / 2006-02-09

all etf 1-hour files

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

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-09 06:00:00	SPY	ETF	126.83	126.83	126.83	126.83	300.0
2006-02-09 07:00:00	SPY	ETF	126.84	126.84	126.78	126.83	77200.0
2006-02-09 08:00:00	SPY	ETF	126.81	126.92	126.5	126.9	1028500.0
2006-02-09 09:00:00	SPY	ETF	126.9	127.24	126.81	127.18	6915500.0
2006-02-09 10:00:00	SPY	ETF	127.2	127.43	127.14	127.29	11596100.0
2006-02-09 11:00:00	SPY	ETF	127.29	127.34	127.1	127.26	6469100.0
2006-02-09 12:00:00	SPY	ETF	127.26	127.55	127.18	127.33	3748400.0
2006-02-09 13:00:00	SPY	ETF	127.34	127.6	127.11	127.26	7232100.0
2006-02-09 14:00:00	SPY	ETF	127.26	127.29	126.91	126.92	7349700.0
2006-02-09 15:00:00	SPY	ETF	126.93	126.95	126.37	126.5	13473100.0
2006-02-09 16:00:00	SPY	ETF	126.5	126.6	126.37	126.55	689200.0
2006-02-09 17:00:00	SPY	ETF	126.5	126.55	126.43	126.49	20800.0
2006-02-09 18:00:00	SPY	ETF	126.5	126.5	126.5	126.5	1000.0
2006-02-09 19:00:00	SPY	ETF	126.54	126.55	126.54	126.55	500.0
2006-02-09 09:00:00	QQQ	ETF	41.2	41.33	41.12	41.3	9097600.0
2006-02-09 10:00:00	QQQ	ETF	41.31	41.37	41.23	41.28	10657000.0
2006-02-09 11:00:00	QQQ	ETF	41.28	41.3	41.14	41.22	8043000.0
2006-02-09 12:00:00	QQQ	ETF	41.22	41.31	41.2	41.21	6142700.0
2006-02-09 13:00:00	QQQ	ETF	41.21	41.31	41.1	41.14	11194300.0
2006-02-09 14:00:00	QQQ	ETF	41.14	41.16	40.93	40.94	11640200.0
2006-02-09 15:00:00	QQQ	ETF	40.94	40.96	40.63	40.7	16301900.0
2006-02-09 08:00:00	IWM	ETF	71.74	71.82	71.74	71.82	116300.0
2006-02-09 09:00:00	IWM	ETF	71.82	72.07	71.66	72.05	2792900.0
2006-02-09 10:00:00	IWM	ETF	72.05	72.23	72.0	72.18	5693600.0
2006-02-09 11:00:00	IWM	ETF	72.18	72.25	71.93	72.09	3235700.0
2006-02-09 12:00:00	IWM	ETF	72.09	72.33	71.99	72.22	2500600.0
2006-02-09 13:00:00	IWM	ETF	72.23	72.34	72.04	72.13	3855800.0
2006-02-09 14:00:00	IWM	ETF	72.14	72.15	71.74	71.84	3562800.0
2006-02-09 15:00:00	IWM	ETF	71.83	71.85	71.24	71.3	9331600.0
2006-02-09 16:00:00	IWM	ETF	71.3	71.36	71.28	71.36	104900.0
2006-02-09 17:00:00	IWM	ETF	71.41	71.41	71.33	71.33	800.0
2006-02-09 07:00:00	DIA	ETF	108.73	108.73	108.72	108.72	9500.0
2006-02-09 08:00:00	DIA	ETF	108.73	108.83	108.73	108.83	39100.0
2006-02-09 09:00:00	DIA	ETF	108.85	108.9	108.67	108.88	709000.0
2006-02-09 10:00:00	DIA	ETF	108.88	109.43	108.84	109.26	1661900.0
2006-02-09 11:00:00	DIA	ETF	109.28	109.4	109.14	109.29	1037900.0
2006-02-09 12:00:00	DIA	ETF	109.29	109.48	109.23	109.35	416700.0
2006-02-09 13:00:00	DIA	ETF	109.35	109.56	109.14	109.32	542000.0
2006-02-09 14:00:00	DIA	ETF	109.35	109.35	109.07	109.15	977600.0
2006-02-09 15:00:00	DIA	ETF	109.17	109.19	108.75	108.87	1612300.0
2006-02-09 16:00:00	DIA	ETF	108.86	108.95	108.81	108.95	87000.0
2006-02-09 17:00:00	DIA	ETF	108.87	108.87	108.87	108.87	100.0
2006-02-09 19:00:00	DIA	ETF	108.91	108.91	108.91	108.91	300.0
2006-02-09 06:00:00	GLD	ETF	55.5	55.5	55.5	55.5	100.0
2006-02-09 07:00:00	GLD	ETF	55.32	55.32	55.32	55.32	100.0
2006-02-09 08:00:00	GLD	ETF	55.55	55.66	55.31	55.52	22600.0
2006-02-09 09:00:00	GLD	ETF	55.49	55.79	55.49	55.68	846300.0
2006-02-09 10:00:00	GLD	ETF	55.68	55.82	55.65	55.6601	860100.0
2006-02-09 11:00:00	GLD	ETF	55.67	55.73	55.55	55.6	680000.0
2006-02-09 12:00:00	GLD	ETF	55.61	56.12	55.61	56.1099	839400.0

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

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