PREVIEW / etf_1hour / 2006-02-13

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-02-13.parquet
  size:    39 KB
  rows:    1,194

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-13 05:00:00	SPY	ETF	126.35	126.36	126.32	126.32	400.0
2006-02-13 07:00:00	SPY	ETF	126.45	126.57	126.45	126.48	82900.0
2006-02-13 08:00:00	SPY	ETF	126.46	126.56	126.33	126.5	817800.0
2006-02-13 09:00:00	SPY	ETF	126.52	126.71	126.42	126.62	6123800.0
2006-02-13 10:00:00	SPY	ETF	126.61	126.79	126.46	126.67	5904700.0
2006-02-13 11:00:00	SPY	ETF	126.65	126.77	126.59	126.66	3285400.0
2006-02-13 12:00:00	SPY	ETF	126.66	126.74	126.39	126.52	4253400.0
2006-02-13 13:00:00	SPY	ETF	126.52	126.6	126.1	126.12	8715200.0
2006-02-13 14:00:00	SPY	ETF	126.12	126.27	125.95	126.02	7458400.0
2006-02-13 15:00:00	SPY	ETF	126.02	126.53	125.96	126.46	7091500.0
2006-02-13 16:00:00	SPY	ETF	126.46	128.49	126.41	126.47	2954900.0
2006-02-13 17:00:00	SPY	ETF	126.48	126.48	125.98	126.41	1316400.0
2006-02-13 18:00:00	SPY	ETF	126.4	126.48	126.4	126.48	9500.0
2006-02-13 19:00:00	SPY	ETF	126.51	126.51	126.46	126.46	800.0
2006-02-13 09:00:00	QQQ	ETF	40.72	40.74	40.61	40.64	10049400.0
2006-02-13 10:00:00	QQQ	ETF	40.64	40.71	40.52	40.62	10597100.0
2006-02-13 11:00:00	QQQ	ETF	40.63	40.66	40.55	40.57	4924300.0
2006-02-13 12:00:00	QQQ	ETF	40.58	40.62	40.46	40.53	5671900.0
2006-02-13 13:00:00	QQQ	ETF	40.53	40.55	40.33	40.34	11616400.0
2006-02-13 14:00:00	QQQ	ETF	40.33	40.45	40.31	40.34	9313700.0
2006-02-13 15:00:00	QQQ	ETF	40.34	40.51	40.3	40.5	13814100.0
2006-02-13 07:00:00	IWM	ETF	71.02	71.02	71.02	71.02	200.0
2006-02-13 08:00:00	IWM	ETF	71.07	71.07	70.96	70.96	32300.0
2006-02-13 09:00:00	IWM	ETF	70.93	71.15	70.84	70.98	4762300.0
2006-02-13 10:00:00	IWM	ETF	70.97	71.12	70.69	71.0	4177500.0
2006-02-13 11:00:00	IWM	ETF	70.99	71.1	70.86	70.94	1771000.0
2006-02-13 12:00:00	IWM	ETF	70.93	71.05	70.64	70.7	2016600.0
2006-02-13 13:00:00	IWM	ETF	70.7	70.76	70.42	70.45	5064600.0
2006-02-13 14:00:00	IWM	ETF	70.46	70.64	70.4	70.45	3963500.0
2006-02-13 15:00:00	IWM	ETF	70.44	70.77	70.35	70.7	7580100.0
2006-02-13 16:00:00	IWM	ETF	70.7	70.75	70.61	70.75	73600.0
2006-02-13 19:00:00	IWM	ETF	70.76	70.76	70.76	70.76	200.0
2006-02-13 08:00:00	DIA	ETF	109.03	109.08	108.95	109.0	420500.0
2006-02-13 09:00:00	DIA	ETF	109.04	109.46	109.02	109.33	2408800.0
2006-02-13 10:00:00	DIA	ETF	109.36	109.49	109.14	109.2801	1368100.0
2006-02-13 11:00:00	DIA	ETF	109.29	109.32	109.15	109.21	238000.0
2006-02-13 12:00:00	DIA	ETF	109.21	109.25	108.97	109.07	280700.0
2006-02-13 13:00:00	DIA	ETF	109.06	109.13	108.76	108.77	1276800.0
2006-02-13 14:00:00	DIA	ETF	108.77	108.9	108.56	108.62	2100400.0
2006-02-13 15:00:00	DIA	ETF	108.61	109.09	108.57	109.07	2429900.0
2006-02-13 16:00:00	DIA	ETF	109.05	109.11	109.05	109.1	388800.0
2006-02-13 18:00:00	DIA	ETF	108.89	109.08	108.89	109.05	500.0
2006-02-13 19:00:00	DIA	ETF	109.05	109.05	109.05	109.05	100.0
2006-02-13 08:00:00	GLD	ETF	54.6	54.71	54.52	54.68	116000.0
2006-02-13 09:00:00	GLD	ETF	54.71	54.9	54.57	54.7	499600.0
2006-02-13 10:00:00	GLD	ETF	54.7001	54.71	54.1	54.26	1123000.0
2006-02-13 11:00:00	GLD	ETF	54.25	54.3	54.12	54.29	527700.0
2006-02-13 12:00:00	GLD	ETF	54.3	54.31	53.71	53.82	1131800.0
2006-02-13 13:00:00	GLD	ETF	53.83	53.86	53.55	53.57	630600.0
2006-02-13 14:00:00	GLD	ETF	53.57	53.71	53.56	53.701	467300.0

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

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