PREVIEW / etf_1hour / 2006-03-09

all etf 1-hour files

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

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-09 05:00:00	SPY	ETF	128.54	128.56	128.54	128.56	28000.0
2006-03-09 06:00:00	SPY	ETF	128.54	128.54	128.54	128.54	30000.0
2006-03-09 07:00:00	SPY	ETF	128.5	128.64	128.5	128.55	152900.0
2006-03-09 08:00:00	SPY	ETF	128.55	128.62	128.4	128.46	778700.0
2006-03-09 09:00:00	SPY	ETF	128.41	128.64	128.27	128.62	6414800.0
2006-03-09 10:00:00	SPY	ETF	128.62	128.68	128.36	128.39	8203800.0
2006-03-09 11:00:00	SPY	ETF	128.41	128.52	128.32	128.42	3998800.0
2006-03-09 12:00:00	SPY	ETF	128.41	128.42	128.02	128.12	6713700.0
2006-03-09 13:00:00	SPY	ETF	128.13	128.13	127.75	127.96	7791800.0
2006-03-09 14:00:00	SPY	ETF	127.97	128.17	127.8	127.87	6144700.0
2006-03-09 15:00:00	SPY	ETF	127.87	127.88	127.57	127.57	9976700.0
2006-03-09 16:00:00	SPY	ETF	127.58	127.64	127.38	127.42	3261000.0
2006-03-09 17:00:00	SPY	ETF	127.43	127.58	127.4	127.41	305900.0
2006-03-09 18:00:00	SPY	ETF	127.4	127.42	127.36	127.36	9000.0
2006-03-09 19:00:00	SPY	ETF	127.39	127.5	127.39	127.5	60400.0
2006-03-09 09:00:00	QQQ	ETF	41.0	41.13	40.88	41.12	10583900.0
2006-03-09 10:00:00	QQQ	ETF	41.12	41.15	40.9	40.93	23886100.0
2006-03-09 11:00:00	QQQ	ETF	40.93	41.01	40.85	40.91	13567500.0
2006-03-09 12:00:00	QQQ	ETF	40.91	40.92	40.67	40.75	11576900.0
2006-03-09 13:00:00	QQQ	ETF	40.74	40.75	40.59	40.68	12819900.0
2006-03-09 14:00:00	QQQ	ETF	40.68	40.82	40.64	40.65	11070800.0
2006-03-09 15:00:00	QQQ	ETF	40.66	40.66	40.47	40.48	16991200.0
2006-03-09 08:00:00	IWM	ETF	71.97	71.98	71.89	71.93	13100.0
2006-03-09 09:00:00	IWM	ETF	71.88	72.39	71.78	72.21	4173100.0
2006-03-09 10:00:00	IWM	ETF	72.21	72.27	71.96	71.96	3939900.0
2006-03-09 11:00:00	IWM	ETF	71.97	72.02	71.86	71.9	2657000.0
2006-03-09 12:00:00	IWM	ETF	71.89	71.89	71.54	71.6	3884500.0
2006-03-09 13:00:00	IWM	ETF	71.61	71.61	71.28	71.48	4657200.0
2006-03-09 14:00:00	IWM	ETF	71.48	71.73	71.42	71.51	4162400.0
2006-03-09 15:00:00	IWM	ETF	71.52	71.59	71.34	71.42	6079000.0
2006-03-09 16:00:00	IWM	ETF	71.42	71.46	71.2	71.2	577300.0
2006-03-09 19:00:00	IWM	ETF	71.26	71.26	71.26	71.26	300.0
2006-03-09 08:00:00	DIA	ETF	110.3	110.31	110.18	110.26	13800.0
2006-03-09 09:00:00	DIA	ETF	110.22	110.46	110.06	110.43	704200.0
2006-03-09 10:00:00	DIA	ETF	110.44	110.55	110.24	110.36	1047800.0
2006-03-09 11:00:00	DIA	ETF	110.36	110.48	110.27	110.36	411100.0
2006-03-09 12:00:00	DIA	ETF	110.33	110.35	110.07	110.12	722500.0
2006-03-09 13:00:00	DIA	ETF	110.12	110.12	109.77	109.94	761500.0
2006-03-09 14:00:00	DIA	ETF	109.95	110.13	109.74	109.9	1098400.0
2006-03-09 15:00:00	DIA	ETF	109.91	109.92	109.68	109.84	1228800.0
2006-03-09 16:00:00	DIA	ETF	109.83	109.83	109.7	109.73	36800.0
2006-03-09 19:00:00	DIA	ETF	109.75	109.75	109.75	109.75	100.0
2006-03-09 07:00:00	GLD	ETF	54.35	54.35	54.33	54.34	14000.0
2006-03-09 08:00:00	GLD	ETF	54.35	54.42	54.31	54.35	64600.0
2006-03-09 09:00:00	GLD	ETF	54.35	54.6	54.32	54.55	729300.0
2006-03-09 10:00:00	GLD	ETF	54.55	54.78	54.43	54.44	751000.0
2006-03-09 11:00:00	GLD	ETF	54.44	54.52	54.22	54.49	518600.0
2006-03-09 12:00:00	GLD	ETF	54.49	54.55	54.21	54.29	756400.0
2006-03-09 13:00:00	GLD	ETF	54.29	54.38	54.13	54.28	436500.0
2006-03-09 14:00:00	GLD	ETF	54.29	54.39	54.27	54.38	172000.0

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

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