PREVIEW / etf_1hour / 2007-01-29

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-01-29.parquet
  size:    62 KB
  rows:    1,969

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-29 07:00:00	SPY	ETF	142.05	142.24	142.05	142.15	275400.0
2007-01-29 08:00:00	SPY	ETF	142.17	142.25	142.05	142.13	992700.0
2007-01-29 09:00:00	SPY	ETF	142.14	142.49	142.08	142.37	5875100.0
2007-01-29 10:00:00	SPY	ETF	142.37	142.55	142.1	142.25	11161500.0
2007-01-29 11:00:00	SPY	ETF	142.24	142.8	142.11	142.24	5036400.0
2007-01-29 12:00:00	SPY	ETF	142.24	142.59	142.2	142.55	5860600.0
2007-01-29 13:00:00	SPY	ETF	142.56	142.63	142.01	142.04	10644000.0
2007-01-29 14:00:00	SPY	ETF	142.05	142.06	141.74	141.88	10200600.0
2007-01-29 15:00:00	SPY	ETF	141.88	142.13	141.84	141.96	10330400.0
2007-01-29 16:00:00	SPY	ETF	141.99	142.05	141.91	142.0	597200.0
2007-01-29 17:00:00	SPY	ETF	142.0	142.148	141.98	142.148	2816300.0
2007-01-29 18:00:00	SPY	ETF	142.01	142.04	142.0	142.01	101900.0
2007-01-29 19:00:00	SPY	ETF	142.02	142.05	142.02	142.05	200.0
2007-01-29 05:00:00	QQQ	ETF	43.4	43.4	43.4	43.4	200.0
2007-01-29 07:00:00	QQQ	ETF	43.41	43.5	43.41	43.46	412390.0
2007-01-29 08:00:00	QQQ	ETF	43.47	43.48	43.45	43.47	933163.0
2007-01-29 09:00:00	QQQ	ETF	43.47	43.64	43.43	43.52	15152047.0
2007-01-29 10:00:00	QQQ	ETF	43.52	43.67	43.4	43.55	23961400.0
2007-01-29 11:00:00	QQQ	ETF	43.55	43.62	43.49	43.59	8533200.0
2007-01-29 12:00:00	QQQ	ETF	43.59	43.87	43.55	43.86	9131400.0
2007-01-29 13:00:00	QQQ	ETF	43.85	43.91	43.5	43.51	14218100.0
2007-01-29 14:00:00	QQQ	ETF	43.51	43.56	43.4	43.49	16104400.0
2007-01-29 15:00:00	QQQ	ETF	43.49	43.62	43.48	43.61	9375900.0
2007-01-29 16:00:00	QQQ	ETF	43.62	43.67	43.58	43.61	3534977.0
2007-01-29 17:00:00	QQQ	ETF	43.64	43.65	43.61	43.63	30980.0
2007-01-29 18:00:00	QQQ	ETF	43.63	43.66	43.63	43.66	10354.0
2007-01-29 19:00:00	QQQ	ETF	43.66	43.67	43.65	43.67	10100.0
2007-01-29 07:00:00	IWM	ETF	78.07	78.07	78.07	78.07	300.0
2007-01-29 08:00:00	IWM	ETF	78.03	78.03	77.98	77.98	2200.0
2007-01-29 09:00:00	IWM	ETF	78.0	78.62	77.96	78.53	7635900.0
2007-01-29 10:00:00	IWM	ETF	78.53	78.82	78.51	78.76	16446000.0
2007-01-29 11:00:00	IWM	ETF	78.75	78.92	78.62	78.73	7487700.0
2007-01-29 12:00:00	IWM	ETF	78.72	78.9	78.71	78.85	3332700.0
2007-01-29 13:00:00	IWM	ETF	78.86	78.94	78.37	78.4	5017800.0
2007-01-29 14:00:00	IWM	ETF	78.41	78.49	78.23	78.43	7368600.0
2007-01-29 15:00:00	IWM	ETF	78.43	78.72	78.43	78.69	4934900.0
2007-01-29 16:00:00	IWM	ETF	78.69	78.78	78.69	78.74	371900.0
2007-01-29 17:00:00	IWM	ETF	78.75	78.82	78.72	78.75	35000.0
2007-01-29 08:00:00	DIA	ETF	124.75	124.8	124.75	124.8	10600.0
2007-01-29 09:00:00	DIA	ETF	124.83	125.19	124.79	125.08	762500.0
2007-01-29 10:00:00	DIA	ETF	125.07	125.19	124.82	124.95	1064000.0
2007-01-29 11:00:00	DIA	ETF	124.95	125.13	124.86	125.01	553100.0
2007-01-29 12:00:00	DIA	ETF	125.01	125.3	124.99	125.27	989700.0
2007-01-29 13:00:00	DIA	ETF	125.27	125.31	124.88	124.93	942900.0
2007-01-29 14:00:00	DIA	ETF	124.93	124.93	124.69	124.8	846800.0
2007-01-29 15:00:00	DIA	ETF	124.7976	124.97	124.72	124.8	785200.0
2007-01-29 16:00:00	DIA	ETF	124.8	124.82	124.75	124.82	666200.0
2007-01-29 18:00:00	DIA	ETF	124.84	124.91	124.82	124.91	1000.0
2007-01-29 08:00:00	GLD	ETF	63.65	63.83	63.58	63.6	347700.0
2007-01-29 09:00:00	GLD	ETF	63.68	64.06	63.62	64.02	663600.0

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

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