PREVIEW / etf_1hour / 2006-03-07

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-03-07.parquet
  size:    41 KB
  rows:    1,264

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-03-07 07:00:00	SPY	ETF	127.92	127.92	127.78	127.86	293600.0
2006-03-07 08:00:00	SPY	ETF	127.84	128.0	127.63	127.77	1753400.0
2006-03-07 09:00:00	SPY	ETF	127.78	127.93	127.63	127.73	8356500.0
2006-03-07 10:00:00	SPY	ETF	127.73	128.06	127.71	127.78	10763800.0
2006-03-07 11:00:00	SPY	ETF	127.77	128.05	127.75	127.89	5377900.0
2006-03-07 12:00:00	SPY	ETF	127.91	128.05	127.48	127.51	6956900.0
2006-03-07 13:00:00	SPY	ETF	127.51	127.83	127.4	127.74	7629700.0
2006-03-07 14:00:00	SPY	ETF	127.75	127.85	127.4	127.73	7208300.0
2006-03-07 15:00:00	SPY	ETF	127.76	127.99	127.55	127.86	9657000.0
2006-03-07 16:00:00	SPY	ETF	127.87	128.0	127.84	127.93	1451600.0
2006-03-07 17:00:00	SPY	ETF	127.93	127.94	127.85	127.86	225700.0
2006-03-07 18:00:00	SPY	ETF	127.93	127.93	127.89	127.89	3900.0
2006-03-07 19:00:00	SPY	ETF	127.88	127.98	127.88	127.98	3600.0
2006-03-07 09:00:00	QQQ	ETF	41.03	41.05	40.81	40.87	12623700.0
2006-03-07 10:00:00	QQQ	ETF	40.87	41.07	40.86	40.93	16141100.0
2006-03-07 11:00:00	QQQ	ETF	40.93	41.04	40.88	40.92	8815400.0
2006-03-07 12:00:00	QQQ	ETF	40.92	40.98	40.75	40.76	11792700.0
2006-03-07 13:00:00	QQQ	ETF	40.76	40.87	40.67	40.81	12794200.0
2006-03-07 14:00:00	QQQ	ETF	40.8	40.86	40.65	40.82	13648900.0
2006-03-07 15:00:00	QQQ	ETF	40.83	40.92	40.74	40.86	14196900.0
2006-03-07 08:00:00	IWM	ETF	72.49	72.49	72.28	72.32	202300.0
2006-03-07 09:00:00	IWM	ETF	72.32	72.4	71.83	71.91	5280100.0
2006-03-07 10:00:00	IWM	ETF	71.91	72.19	71.9	71.92	6138600.0
2006-03-07 11:00:00	IWM	ETF	71.94	72.11	71.89	71.95	3220600.0
2006-03-07 12:00:00	IWM	ETF	71.95	72.05	71.62	71.64	4593700.0
2006-03-07 13:00:00	IWM	ETF	71.65	71.77	71.46	71.65	3342000.0
2006-03-07 14:00:00	IWM	ETF	71.65	71.79	71.44	71.63	6412700.0
2006-03-07 15:00:00	IWM	ETF	71.63	71.74	71.53	71.63	6754000.0
2006-03-07 16:00:00	IWM	ETF	71.62	71.69	71.56	71.68	2342400.0
2006-03-07 17:00:00	IWM	ETF	71.63	71.63	71.57	71.57	2100.0
2006-03-07 19:00:00	IWM	ETF	71.64	71.64	71.64	71.64	100.0
2006-03-07 08:00:00	DIA	ETF	109.39	109.43	109.28	109.36	43500.0
2006-03-07 09:00:00	DIA	ETF	109.41	109.58	109.36	109.45	536800.0
2006-03-07 10:00:00	DIA	ETF	109.45	109.91	109.45	109.64	1579200.0
2006-03-07 11:00:00	DIA	ETF	109.64	109.88	109.56	109.71	564000.0
2006-03-07 12:00:00	DIA	ETF	109.72	109.83	109.38	109.38	750900.0
2006-03-07 13:00:00	DIA	ETF	109.37	109.72	109.3	109.63	929100.0
2006-03-07 14:00:00	DIA	ETF	109.64	109.72	109.38	109.67	636600.0
2006-03-07 15:00:00	DIA	ETF	109.69	109.87	109.54	109.77	793200.0
2006-03-07 16:00:00	DIA	ETF	109.75	109.87	109.72	109.83	162500.0
2006-03-07 17:00:00	DIA	ETF	109.83	109.85	109.81	109.85	2900.0
2006-03-07 19:00:00	DIA	ETF	109.8	109.9	109.8	109.9	900.0
2006-03-07 07:00:00	GLD	ETF	55.12	55.12	55.12	55.12	1500.0
2006-03-07 08:00:00	GLD	ETF	55.12	55.27	55.09	55.27	49600.0
2006-03-07 09:00:00	GLD	ETF	55.25	55.34	55.1	55.12	382800.0
2006-03-07 10:00:00	GLD	ETF	55.13	55.17	54.71	54.78	1395200.0
2006-03-07 11:00:00	GLD	ETF	54.79	55.03	54.55	54.96	1161000.0
2006-03-07 12:00:00	GLD	ETF	54.97	55.04	54.83	55.02	410000.0
2006-03-07 13:00:00	GLD	ETF	55.028	55.13	54.91	54.98	442300.0
2006-03-07 14:00:00	GLD	ETF	54.99	55.02	54.95	55.0	183700.0

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

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