PREVIEW / etf_1hour / 2006-09-25

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-09-25.parquet
  size:    54 KB
  rows:    1,656

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-09-25 04:00:00	SPY	ETF	131.74	131.75	131.74	131.75	200.0
2006-09-25 07:00:00	SPY	ETF	131.8	131.83	131.78	131.81	49000.0
2006-09-25 08:00:00	SPY	ETF	131.84	131.95	131.77	131.79	2543900.0
2006-09-25 09:00:00	SPY	ETF	131.81	131.91	131.51	131.52	6721400.0
2006-09-25 10:00:00	SPY	ETF	131.52	131.67	131.05	131.32	15616700.0
2006-09-25 11:00:00	SPY	ETF	131.33	131.63	131.31	131.33	9459300.0
2006-09-25 12:00:00	SPY	ETF	131.32	132.25	131.24	132.2201	14941900.0
2006-09-25 13:00:00	SPY	ETF	132.23	132.37	132.06	132.11	10597800.0
2006-09-25 14:00:00	SPY	ETF	132.11	132.77	132.11	132.69	10735100.0
2006-09-25 15:00:00	SPY	ETF	132.7	132.85	132.52	132.53	15882600.0
2006-09-25 16:00:00	SPY	ETF	132.53	132.57	132.4	132.44	1156700.0
2006-09-25 17:00:00	SPY	ETF	132.45	132.45	132.4	132.4	1500.0
2006-09-25 18:00:00	SPY	ETF	132.45	132.47	132.43	132.47	9800.0
2006-09-25 19:00:00	SPY	ETF	132.47	132.47	132.45	132.45	800.0
2006-09-25 09:00:00	QQQ	ETF	40.04	40.17	39.94	39.94	12479600.0
2006-09-25 10:00:00	QQQ	ETF	39.94	40.03	39.68	39.85	19613800.0
2006-09-25 11:00:00	QQQ	ETF	39.84	40.1	39.84	39.98	18668600.0
2006-09-25 12:00:00	QQQ	ETF	39.98	40.44	39.92	40.43	24616200.0
2006-09-25 13:00:00	QQQ	ETF	40.43	40.52	40.27	40.28	15425600.0
2006-09-25 14:00:00	QQQ	ETF	40.29	40.52	40.28	40.49	11631900.0
2006-09-25 15:00:00	QQQ	ETF	40.49	40.66	40.45	40.56	26745400.0
2006-09-25 07:00:00	IWM	ETF	71.54	71.8	71.54	71.8	10500.0
2006-09-25 08:00:00	IWM	ETF	71.62	71.9	71.55	71.8	1259800.0
2006-09-25 09:00:00	IWM	ETF	71.77	71.83	71.28	71.29	5570500.0
2006-09-25 10:00:00	IWM	ETF	71.28	71.48	71.11	71.36	10421000.0
2006-09-25 11:00:00	IWM	ETF	71.36	71.8	71.36	71.64	11791100.0
2006-09-25 12:00:00	IWM	ETF	71.65	72.25	71.52	72.23	6649400.0
2006-09-25 13:00:00	IWM	ETF	72.23	72.33	71.94	71.99	6635800.0
2006-09-25 14:00:00	IWM	ETF	71.98	72.61	71.95	72.54	9926000.0
2006-09-25 15:00:00	IWM	ETF	72.5401	72.65	72.34	72.4	8852600.0
2006-09-25 16:00:00	IWM	ETF	72.39	72.42	72.27	72.37	210300.0
2006-09-25 17:00:00	IWM	ETF	72.35	72.38	72.35	72.38	1200.0
2006-09-25 07:00:00	DIA	ETF	115.37	115.39	115.37	115.39	1100.0
2006-09-25 08:00:00	DIA	ETF	115.39	115.45	115.21	115.23	47200.0
2006-09-25 09:00:00	DIA	ETF	115.22	115.36	115.08	115.09	436700.0
2006-09-25 10:00:00	DIA	ETF	115.1	115.27	114.77	114.99	989100.0
2006-09-25 11:00:00	DIA	ETF	114.99	115.16	114.91	114.91	778000.0
2006-09-25 12:00:00	DIA	ETF	114.91	115.55	114.83	115.52	737300.0
2006-09-25 13:00:00	DIA	ETF	115.52	115.6	115.29	115.36	1177700.0
2006-09-25 14:00:00	DIA	ETF	115.36	116.01	115.35	115.97	1989000.0
2006-09-25 15:00:00	DIA	ETF	115.97	116.1	115.71	115.72	1534800.0
2006-09-25 16:00:00	DIA	ETF	115.7	115.72	115.56	115.59	128800.0
2006-09-25 07:00:00	GLD	ETF	58.44	58.45	58.44	58.45	6000.0
2006-09-25 08:00:00	GLD	ETF	58.4	58.52	58.19	58.19	40700.0
2006-09-25 09:00:00	GLD	ETF	58.24	58.27	57.79	57.9624	852900.0
2006-09-25 10:00:00	GLD	ETF	57.96	58.1	57.8	58.03	667100.0
2006-09-25 11:00:00	GLD	ETF	58.05	58.15	57.78	57.9289	452100.0
2006-09-25 12:00:00	GLD	ETF	57.93	58.33	57.92	58.3	366300.0
2006-09-25 13:00:00	GLD	ETF	58.31	58.69	58.28	58.52	634900.0
2006-09-25 14:00:00	GLD	ETF	58.53	58.76	58.51	58.51	292000.0

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

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