PREVIEW / etf_1hour / 2006-06-07

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-06-07.parquet
  size:    45 KB
  rows:    1,379

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-06-07 04:00:00	SPY	ETF	126.74	126.74	126.74	126.74	2000.0
2006-06-07 06:00:00	SPY	ETF	126.95	126.99	126.95	126.99	2200.0
2006-06-07 07:00:00	SPY	ETF	127.05	127.11	127.01	127.08	44300.0
2006-06-07 08:00:00	SPY	ETF	127.07	127.2	126.6	127.02	1628400.0
2006-06-07 09:00:00	SPY	ETF	127.02	127.05	126.44	126.7	10987200.0
2006-06-07 10:00:00	SPY	ETF	126.7	127.38	126.69	127.05	22368800.0
2006-06-07 11:00:00	SPY	ETF	127.05	127.56	126.96	127.5109	7275700.0
2006-06-07 12:00:00	SPY	ETF	127.52	127.65	127.19	127.24	9732400.0
2006-06-07 13:00:00	SPY	ETF	127.24	127.37	126.92	127.11	13187300.0
2006-06-07 14:00:00	SPY	ETF	127.09	127.5	126.65	126.87	13281000.0
2006-06-07 15:00:00	SPY	ETF	126.86	127.5	125.9	125.9	23569900.0
2006-06-07 16:00:00	SPY	ETF	125.89	126.0367	125.65	125.67	3523800.0
2006-06-07 17:00:00	SPY	ETF	125.72	125.77	125.66	125.75	1072600.0
2006-06-07 18:00:00	SPY	ETF	125.75	125.84	125.73	125.73	109200.0
2006-06-07 19:00:00	SPY	ETF	125.8	125.82	125.7	125.78	9400.0
2006-06-07 09:00:00	QQQ	ETF	38.8	38.83	38.64	38.75	13222000.0
2006-06-07 10:00:00	QQQ	ETF	38.76	39.06	38.75	38.92	26645900.0
2006-06-07 11:00:00	QQQ	ETF	38.92	39.11	38.87	39.09	13248200.0
2006-06-07 12:00:00	QQQ	ETF	39.1	39.17	38.9	38.93	11166000.0
2006-06-07 13:00:00	QQQ	ETF	38.92	39.07	38.85	38.89	9557700.0
2006-06-07 14:00:00	QQQ	ETF	38.89	38.89	38.67	38.76	17391400.0
2006-06-07 15:00:00	QQQ	ETF	38.76	38.81	38.45	38.45	24132400.0
2006-06-07 08:00:00	IWM	ETF	71.05	71.13	70.99	71.02	42100.0
2006-06-07 09:00:00	IWM	ETF	71.01	71.01	70.17	70.51	6720600.0
2006-06-07 10:00:00	IWM	ETF	70.52	71.55	70.51	71.21	16141000.0
2006-06-07 11:00:00	IWM	ETF	71.2	71.66	71.12	71.66	7431800.0
2006-06-07 12:00:00	IWM	ETF	71.66	71.82	71.35	71.38	8119800.0
2006-06-07 13:00:00	IWM	ETF	71.38	71.51	70.93	71.03	7801400.0
2006-06-07 14:00:00	IWM	ETF	71.02	71.12	70.51	70.69	9284700.0
2006-06-07 15:00:00	IWM	ETF	70.69	70.83	70.2	70.21	17038800.0
2006-06-07 16:00:00	IWM	ETF	70.21	70.3	70.01	70.01	1059200.0
2006-06-07 17:00:00	IWM	ETF	70.04	70.04	70.0	70.04	83700.0
2006-06-07 18:00:00	IWM	ETF	70.04	70.07	70.01	70.01	6400.0
2006-06-07 19:00:00	IWM	ETF	70.04	70.04	70.04	70.04	2000.0
2006-06-07 07:00:00	DIA	ETF	110.2	110.26	110.2	110.26	700.0
2006-06-07 08:00:00	DIA	ETF	110.19	110.32	110.11	110.19	36600.0
2006-06-07 09:00:00	DIA	ETF	110.16	110.16	109.72	109.99	965100.0
2006-06-07 10:00:00	DIA	ETF	110.01	110.49	109.99	110.22	2194500.0
2006-06-07 11:00:00	DIA	ETF	110.22	110.66	110.18	110.61	785200.0
2006-06-07 12:00:00	DIA	ETF	110.63	110.73	110.32	110.34	1144000.0
2006-06-07 13:00:00	DIA	ETF	110.33	110.6	110.12	110.27	697600.0
2006-06-07 14:00:00	DIA	ETF	110.25	110.25	109.81	110.02	1570000.0
2006-06-07 15:00:00	DIA	ETF	110.04	110.14	109.22	109.23	1392800.0
2006-06-07 16:00:00	DIA	ETF	109.23	109.29	109.16	109.19	152700.0
2006-06-07 17:00:00	DIA	ETF	109.19	109.19	109.06	109.06	7300.0
2006-06-07 18:00:00	DIA	ETF	109.2	109.2	109.18	109.2	2700.0
2006-06-07 19:00:00	DIA	ETF	109.24	109.24	109.24	109.24	400.0
2006-06-07 07:00:00	GLD	ETF	61.8	61.8	61.45	61.53	17000.0
2006-06-07 08:00:00	GLD	ETF	61.52	62.49	61.49	61.68	217600.0
2006-06-07 09:00:00	GLD	ETF	61.72	61.81	61.35	61.46	2224700.0

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

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