PREVIEW / etf_1hour / 2006-02-16

all etf 1-hour files

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

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-16 07:00:00	SPY	ETF	128.22	128.31	128.22	128.31	13400.0
2006-02-16 08:00:00	SPY	ETF	128.31	128.36	128.2	128.33	3011400.0
2006-02-16 09:00:00	SPY	ETF	128.33	128.48	128.23	128.24	7622700.0
2006-02-16 10:00:00	SPY	ETF	128.24	128.42	128.18	128.32	8136100.0
2006-02-16 11:00:00	SPY	ETF	128.32	128.65	128.3	128.59	10506700.0
2006-02-16 12:00:00	SPY	ETF	128.59	128.86	128.51	128.76	8499900.0
2006-02-16 13:00:00	SPY	ETF	128.75	128.83	128.47	128.57	6053700.0
2006-02-16 14:00:00	SPY	ETF	128.56	128.7	128.39	128.69	4267000.0
2006-02-16 15:00:00	SPY	ETF	128.69	129.12	128.67	129.08	9123800.0
2006-02-16 16:00:00	SPY	ETF	129.07	129.21	129.06	129.1	2450100.0
2006-02-16 17:00:00	SPY	ETF	129.13	129.13	129.09	129.13	5300.0
2006-02-16 18:00:00	SPY	ETF	129.12	129.14	129.12	129.14	17300.0
2006-02-16 19:00:00	SPY	ETF	129.08	129.08	129.08	129.08	100.0
2006-02-16 09:00:00	QQQ	ETF	41.3	41.45	41.23	41.24	17500800.0
2006-02-16 10:00:00	QQQ	ETF	41.25	41.35	41.23	41.28	7059100.0
2006-02-16 11:00:00	QQQ	ETF	41.27	41.5	41.27	41.45	11442800.0
2006-02-16 12:00:00	QQQ	ETF	41.45	41.55	41.44	41.47	8660800.0
2006-02-16 13:00:00	QQQ	ETF	41.46	41.49	41.2	41.27	10783700.0
2006-02-16 14:00:00	QQQ	ETF	41.27	41.38	41.15	41.36	18447400.0
2006-02-16 15:00:00	QQQ	ETF	41.37	41.54	41.3	41.54	17442800.0
2006-02-16 08:00:00	IWM	ETF	72.28	72.33	72.28	72.3	22600.0
2006-02-16 09:00:00	IWM	ETF	72.3	72.58	72.24	72.25	4472900.0
2006-02-16 10:00:00	IWM	ETF	72.25	72.51	72.12	72.32	5523500.0
2006-02-16 11:00:00	IWM	ETF	72.32	72.58	72.31	72.48	2925500.0
2006-02-16 12:00:00	IWM	ETF	72.49	72.65	72.43	72.58	2429600.0
2006-02-16 13:00:00	IWM	ETF	72.58	72.61	72.36	72.43	4196200.0
2006-02-16 14:00:00	IWM	ETF	72.41	72.52	72.25	72.49	3286800.0
2006-02-16 15:00:00	IWM	ETF	72.5	72.79	72.5	72.74	6459500.0
2006-02-16 16:00:00	IWM	ETF	72.73	72.89	72.68	72.8	408400.0
2006-02-16 17:00:00	IWM	ETF	72.79	72.79	72.79	72.79	9000.0
2006-02-16 18:00:00	IWM	ETF	72.77	72.77	72.77	72.77	500.0
2006-02-16 08:00:00	DIA	ETF	110.82	110.82	110.77	110.8	4200.0
2006-02-16 09:00:00	DIA	ETF	110.8	110.89	110.69	110.71	519400.0
2006-02-16 10:00:00	DIA	ETF	110.72	110.84	110.58	110.65	806700.0
2006-02-16 11:00:00	DIA	ETF	110.65	110.95	110.63	110.86	801600.0
2006-02-16 12:00:00	DIA	ETF	110.87	111.04	110.8	110.87	466500.0
2006-02-16 13:00:00	DIA	ETF	110.87	110.93	110.67	110.75	433600.0
2006-02-16 14:00:00	DIA	ETF	110.74	110.83	110.6	110.8	1152700.0
2006-02-16 15:00:00	DIA	ETF	110.8	111.26	110.8	111.26	1375700.0
2006-02-16 16:00:00	DIA	ETF	111.25	111.3	111.23	111.23	29500.0
2006-02-16 19:00:00	DIA	ETF	111.23	111.23	111.23	111.23	500.0
2006-02-16 07:00:00	GLD	ETF	53.81	53.81	53.72	53.72	6000.0
2006-02-16 08:00:00	GLD	ETF	53.76	53.76	53.41	53.58	49500.0
2006-02-16 09:00:00	GLD	ETF	53.59	53.78	53.42	53.62	647200.0
2006-02-16 10:00:00	GLD	ETF	53.6592	53.74	53.49	53.7	511400.0
2006-02-16 11:00:00	GLD	ETF	53.7	54.12	53.7	54.12	669600.0
2006-02-16 12:00:00	GLD	ETF	54.13	54.29	54.09	54.22	751900.0
2006-02-16 13:00:00	GLD	ETF	54.23	54.39	54.21	54.25	919900.0
2006-02-16 14:00:00	GLD	ETF	54.26	54.44	54.25	54.35	1162800.0
2006-02-16 15:00:00	GLD	ETF	54.359	54.54	54.35	54.54	864900.0

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

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