PREVIEW / etf_1hour / 2006-06-23

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-06-23.parquet
  size:    46 KB
  rows:    1,426

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-23 07:00:00	SPY	ETF	124.55	124.7	124.51	124.51	128400.0
2006-06-23 08:00:00	SPY	ETF	124.54	124.7	124.24	124.32	2349900.0
2006-06-23 09:00:00	SPY	ETF	124.31	124.45	124.03	124.3425	7023600.0
2006-06-23 10:00:00	SPY	ETF	124.34	124.74	124.25	124.65	9079900.0
2006-06-23 11:00:00	SPY	ETF	124.65	124.7	124.26	124.4	5278900.0
2006-06-23 12:00:00	SPY	ETF	124.4	125.3	124.36	124.9	11889200.0
2006-06-23 13:00:00	SPY	ETF	124.9	125.2	124.85	124.98	4317800.0
2006-06-23 14:00:00	SPY	ETF	124.97	125.0	124.5	124.53	5370000.0
2006-06-23 15:00:00	SPY	ETF	124.53	124.7	124.35	124.4	7030000.0
2006-06-23 16:00:00	SPY	ETF	124.38	124.46	124.27	124.27	656800.0
2006-06-23 17:00:00	SPY	ETF	124.31	124.37	124.3	124.34	4800.0
2006-06-23 18:00:00	SPY	ETF	124.34	124.4	124.34	124.4	1100.0
2006-06-23 09:00:00	QQQ	ETF	38.16	38.61	37.93	38.09	13938100.0
2006-06-23 10:00:00	QQQ	ETF	38.09	38.2	37.97	38.18	16183300.0
2006-06-23 11:00:00	QQQ	ETF	38.18	38.21	38.06	38.12	8506200.0
2006-06-23 12:00:00	QQQ	ETF	38.11	38.53	38.1	38.42	14850800.0
2006-06-23 13:00:00	QQQ	ETF	38.41	38.5	38.38	38.44	4916400.0
2006-06-23 14:00:00	QQQ	ETF	38.44	38.44	38.19	38.2	8992900.0
2006-06-23 15:00:00	QQQ	ETF	38.19	38.4	38.13	38.15	13610400.0
2006-06-23 08:00:00	IWM	ETF	68.34	68.45	68.12	68.17	306600.0
2006-06-23 09:00:00	IWM	ETF	68.13	68.25	67.72	68.12	6732600.0
2006-06-23 10:00:00	IWM	ETF	68.11	68.58	67.99	68.49	11282300.0
2006-06-23 11:00:00	IWM	ETF	68.49	68.54	68.26	68.32	4283700.0
2006-06-23 12:00:00	IWM	ETF	68.34	69.05	68.31	68.86	5671300.0
2006-06-23 13:00:00	IWM	ETF	68.84	68.99	68.77	68.83	3121200.0
2006-06-23 14:00:00	IWM	ETF	68.83	68.86	68.4712	68.5	3581100.0
2006-06-23 15:00:00	IWM	ETF	68.51	68.76	68.42	68.62	5446200.0
2006-06-23 16:00:00	IWM	ETF	68.62	68.75	68.57	68.7	615700.0
2006-06-23 17:00:00	IWM	ETF	68.71	68.71	68.7	68.7	2800.0
2006-06-23 18:00:00	IWM	ETF	68.7	68.7	68.7	68.7	1500.0
2006-06-23 19:00:00	IWM	ETF	68.63	68.63	68.5	68.5	1500.0
2006-06-23 08:00:00	DIA	ETF	110.25	110.25	110.05	110.09	41700.0
2006-06-23 09:00:00	DIA	ETF	109.96	110.11	109.66	110.05	805400.0
2006-06-23 10:00:00	DIA	ETF	110.05	110.38	109.98	110.27	1561100.0
2006-06-23 11:00:00	DIA	ETF	110.26	110.3	109.82	109.92	378700.0
2006-06-23 12:00:00	DIA	ETF	109.91	110.69	109.9	110.45	1244100.0
2006-06-23 13:00:00	DIA	ETF	110.43	110.69	110.41	110.44	295000.0
2006-06-23 14:00:00	DIA	ETF	110.411	110.42	109.96	109.98	589700.0
2006-06-23 15:00:00	DIA	ETF	109.98	110.17	109.89	109.9	1521000.0
2006-06-23 16:00:00	DIA	ETF	109.88	109.93	109.82	109.9	246000.0
2006-06-23 17:00:00	DIA	ETF	109.93	109.93	109.93	109.93	2000.0
2006-06-23 18:00:00	DIA	ETF	109.93	109.93	109.93	109.93	400.0
2006-06-23 07:00:00	GLD	ETF	57.51	57.51	57.17	57.17	1000.0
2006-06-23 08:00:00	GLD	ETF	57.23	57.4	56.91	57.01	207800.0
2006-06-23 09:00:00	GLD	ETF	57.07	57.77	57.05	57.71	973100.0
2006-06-23 10:00:00	GLD	ETF	57.7	57.93	57.35	57.47	1623100.0
2006-06-23 11:00:00	GLD	ETF	57.48	57.64	57.27	57.5	538700.0
2006-06-23 12:00:00	GLD	ETF	57.51	58.2176	57.44	57.96	571600.0
2006-06-23 13:00:00	GLD	ETF	57.94	58.3	57.93	57.96	857200.0
2006-06-23 14:00:00	GLD	ETF	57.96	58.08	57.91	57.95	297500.0

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

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