PREVIEW / etf_1hour / 2006-07-03

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-07-03.parquet
  size:    33 KB
  rows:    943

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-07-03 07:00:00	SPY	ETF	127.35	127.4	127.32	127.32	3200.0
2006-07-03 08:00:00	SPY	ETF	127.32	127.37	127.27	127.28	155900.0
2006-07-03 09:00:00	SPY	ETF	127.37	127.55	127.28	127.38	4824900.0
2006-07-03 10:00:00	SPY	ETF	127.38	127.57	127.33	127.51	4059500.0
2006-07-03 11:00:00	SPY	ETF	127.52	127.91	127.52	127.84	6770200.0
2006-07-03 12:00:00	SPY	ETF	127.84	128.01	127.84	127.97	5774900.0
2006-07-03 13:00:00	SPY	ETF	127.97	127.97	127.8	127.8	1966500.0
2006-07-03 09:00:00	QQQ	ETF	38.88	38.92	38.81	38.86	6002300.0
2006-07-03 10:00:00	QQQ	ETF	38.86	38.87	38.82	38.84	3251900.0
2006-07-03 11:00:00	QQQ	ETF	38.84	38.95	38.84	38.92	4183100.0
2006-07-03 12:00:00	QQQ	ETF	38.92	39.0	38.91	38.99	5385700.0
2006-07-03 08:00:00	IWM	ETF	71.85	71.9	71.73	71.9	35400.0
2006-07-03 09:00:00	IWM	ETF	71.83	72.14	71.76	71.96	8787900.0
2006-07-03 10:00:00	IWM	ETF	71.95	72.27	71.87	72.23	5315200.0
2006-07-03 11:00:00	IWM	ETF	72.24	72.47	72.23	72.32	3398400.0
2006-07-03 12:00:00	IWM	ETF	72.33	72.59	72.3	72.57	4409100.0
2006-07-03 13:00:00	IWM	ETF	72.56	72.63	72.47	72.63	138200.0
2006-07-03 08:00:00	DIA	ETF	111.84	111.87	111.79	111.79	3100.0
2006-07-03 09:00:00	DIA	ETF	111.9	112.08	111.86	112.01	202900.0
2006-07-03 10:00:00	DIA	ETF	112.0	112.03	111.87	111.87	245800.0
2006-07-03 11:00:00	DIA	ETF	111.87	112.17	111.87	112.15	258000.0
2006-07-03 12:00:00	DIA	ETF	112.17	112.25	112.15	112.2	324100.0
2006-07-03 13:00:00	DIA	ETF	112.2	112.21	112.17	112.2	10200.0
2006-07-03 07:00:00	GLD	ETF	61.97	62.01	61.97	62.01	1100.0
2006-07-03 08:00:00	GLD	ETF	62.0	62.25	61.17	61.95	109800.0
2006-07-03 09:00:00	GLD	ETF	61.97	62.1	61.83	62.06	911200.0
2006-07-03 10:00:00	GLD	ETF	62.06	62.21	61.88	62.18	970100.0
2006-07-03 11:00:00	GLD	ETF	62.19	62.26	62.11	62.2	436900.0
2006-07-03 12:00:00	GLD	ETF	62.18	62.37	62.171	62.29	516600.0
2006-07-03 13:00:00	GLD	ETF	62.28	62.32	62.16	62.18	116600.0
2006-07-03 08:00:00	TLT	ETF	84.03	84.03	83.84	83.84	1000.0
2006-07-03 09:00:00	TLT	ETF	83.89	83.9	83.73	83.9	295000.0
2006-07-03 10:00:00	TLT	ETF	83.9	83.96	83.82	83.85	278800.0
2006-07-03 11:00:00	TLT	ETF	83.85	83.86	83.75	83.79	72200.0
2006-07-03 12:00:00	TLT	ETF	83.8	83.96	83.79	83.96	66600.0
2006-07-03 13:00:00	TLT	ETF	83.88	83.91	83.88	83.91	3200.0

> showing 36 of 943 rows — these rows as CSV

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