PREVIEW / etf_1hour / 2007-01-04

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-01-04.parquet
  size:    60 KB
  rows:    1,885

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
2007-01-04 06:00:00	SPY	ETF	141.09	141.09	141.09	141.09	1000.0
2007-01-04 07:00:00	SPY	ETF	141.06	141.16	141.03	141.15	171100.0
2007-01-04 08:00:00	SPY	ETF	141.17	141.27	141.03	141.21	747000.0
2007-01-04 09:00:00	SPY	ETF	141.22	141.5	140.94	141.27	9356300.0
2007-01-04 10:00:00	SPY	ETF	141.27	141.57	140.61	141.41	17593600.0
2007-01-04 11:00:00	SPY	ETF	141.4	141.66	141.32	141.47	9201600.0
2007-01-04 12:00:00	SPY	ETF	141.46	141.55	141.35	141.42	3191300.0
2007-01-04 13:00:00	SPY	ETF	141.425	141.49	141.1	141.3	4625500.0
2007-01-04 14:00:00	SPY	ETF	141.3	141.79	141.16	141.76	8413800.0
2007-01-04 15:00:00	SPY	ETF	141.76	142.05	141.62	141.67	11726900.0
2007-01-04 16:00:00	SPY	ETF	141.67	141.75	141.4982	141.73	2036600.0
2007-01-04 17:00:00	SPY	ETF	141.75	141.77	141.75	141.75	257200.0
2007-01-04 18:00:00	SPY	ETF	141.76	141.77	141.71	141.77	14000.0
2007-01-04 19:00:00	SPY	ETF	141.72	141.78	141.69	141.78	4300.0
2007-01-04 07:00:00	QQQ	ETF	43.17	43.2	43.1	43.16	141016.0
2007-01-04 08:00:00	QQQ	ETF	43.17	43.3	43.16	43.25	616369.0
2007-01-04 09:00:00	QQQ	ETF	43.27	43.45	43.17	43.39	17291920.0
2007-01-04 10:00:00	QQQ	ETF	43.39	43.78	43.15	43.74	33774900.0
2007-01-04 11:00:00	QQQ	ETF	43.75	43.87	43.68	43.77	18935400.0
2007-01-04 12:00:00	QQQ	ETF	43.76	43.82	43.7	43.77	4906300.0
2007-01-04 13:00:00	QQQ	ETF	43.78	43.81	43.62	43.71	10749500.0
2007-01-04 14:00:00	QQQ	ETF	43.72	44.02	43.68	44.0	16764800.0
2007-01-04 15:00:00	QQQ	ETF	44.01	44.21	43.97	44.07	21142000.0
2007-01-04 16:00:00	QQQ	ETF	44.06	44.17	44.04	44.16	2386930.0
2007-01-04 17:00:00	QQQ	ETF	44.16	44.2	44.15	44.15	533428.0
2007-01-04 18:00:00	QQQ	ETF	44.15	44.17	44.14	44.16	37889.0
2007-01-04 19:00:00	QQQ	ETF	44.16	44.16	44.14	44.16	45685.0
2007-01-04 08:00:00	IWM	ETF	77.93	78.03	77.93	77.96	122200.0
2007-01-04 09:00:00	IWM	ETF	77.97	78.1	77.47	77.74	5543900.0
2007-01-04 10:00:00	IWM	ETF	77.73	78.02	77.28	77.94	11291900.0
2007-01-04 11:00:00	IWM	ETF	77.95	78.17	77.85	77.99	4694800.0
2007-01-04 12:00:00	IWM	ETF	77.99	78.05	77.74	77.88	4477500.0
2007-01-04 13:00:00	IWM	ETF	77.88	78.02	77.64	77.84	3491400.0
2007-01-04 14:00:00	IWM	ETF	77.84	78.39	77.82	78.34	6042000.0
2007-01-04 15:00:00	IWM	ETF	78.34	78.59	78.3	78.32	8888700.0
2007-01-04 16:00:00	IWM	ETF	78.33	78.37	78.28	78.35	290100.0
2007-01-04 17:00:00	IWM	ETF	78.35	78.37	78.35	78.37	2800.0
2007-01-04 19:00:00	IWM	ETF	78.32	78.32	78.32	78.32	900.0
2007-01-04 08:00:00	DIA	ETF	124.33	124.45	124.3	124.43	7600.0
2007-01-04 09:00:00	DIA	ETF	124.5	124.75	124.32	124.45	1200700.0
2007-01-04 10:00:00	DIA	ETF	124.45	124.51	123.89	124.4175	3306700.0
2007-01-04 11:00:00	DIA	ETF	124.41	124.59	124.34	124.43	1205400.0
2007-01-04 12:00:00	DIA	ETF	124.42	124.53	124.36	124.47	430700.0
2007-01-04 13:00:00	DIA	ETF	124.46	124.5	124.13	124.34	1113600.0
2007-01-04 14:00:00	DIA	ETF	124.33	124.75	124.19	124.72	1189400.0
2007-01-04 15:00:00	DIA	ETF	124.72	124.95	124.64	124.68	1566000.0
2007-01-04 16:00:00	DIA	ETF	124.69	124.75	124.65	124.7	67100.0
2007-01-04 17:00:00	DIA	ETF	124.7	124.7	124.7	124.7	181000.0
2007-01-04 18:00:00	DIA	ETF	124.75	124.75	124.75	124.75	100.0
2007-01-04 07:00:00	GLD	ETF	62.32	62.32	62.3	62.3	2500.0

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

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