PREVIEW / etf_1hour / 2006-05-09

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-05-09.parquet
  size:    43 KB
  rows:    1,349

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-05-09 06:00:00	SPY	ETF	132.49	132.49	132.49	132.49	1000.0
2006-05-09 07:00:00	SPY	ETF	132.53	132.53	132.46	132.49	106900.0
2006-05-09 08:00:00	SPY	ETF	132.48	132.52	132.4	132.4	339700.0
2006-05-09 09:00:00	SPY	ETF	132.4	132.48	132.31	132.4	4279200.0
2006-05-09 10:00:00	SPY	ETF	132.4	132.63	132.36	132.56	4655800.0
2006-05-09 11:00:00	SPY	ETF	132.56	132.77	132.55	132.63	3576800.0
2006-05-09 12:00:00	SPY	ETF	132.62	132.7	132.46	132.51	2613000.0
2006-05-09 13:00:00	SPY	ETF	132.51	132.54	132.41	132.46	2466900.0
2006-05-09 14:00:00	SPY	ETF	132.46	132.57	132.39	132.5	1588600.0
2006-05-09 15:00:00	SPY	ETF	132.5	132.63	132.48	132.53	5341900.0
2006-05-09 16:00:00	SPY	ETF	132.53	132.68	132.45	132.64	2159200.0
2006-05-09 17:00:00	SPY	ETF	132.6	132.6	132.5	132.51	109400.0
2006-05-09 18:00:00	SPY	ETF	132.52	132.53	132.51	132.51	800.0
2006-05-09 19:00:00	SPY	ETF	132.52	132.52	132.52	132.52	1200.0
2006-05-09 09:00:00	QQQ	ETF	42.1	42.1	42.0	42.04	6637600.0
2006-05-09 10:00:00	QQQ	ETF	42.03	42.08	42.0	42.05	9318600.0
2006-05-09 11:00:00	QQQ	ETF	42.05	42.18	42.03	42.14	8113200.0
2006-05-09 12:00:00	QQQ	ETF	42.13	42.16	42.02	42.05	4060200.0
2006-05-09 13:00:00	QQQ	ETF	42.04	42.06	41.98	42.02	4118000.0
2006-05-09 14:00:00	QQQ	ETF	42.01	42.04	41.97	42.03	4984500.0
2006-05-09 15:00:00	QQQ	ETF	42.03	42.08	42.01	42.04	6494000.0
2006-05-09 07:00:00	IWM	ETF	77.7	77.7	77.5	77.6	1400.0
2006-05-09 08:00:00	IWM	ETF	77.63	77.63	77.53	77.58	4100.0
2006-05-09 09:00:00	IWM	ETF	77.53	77.63	77.35	77.45	1856500.0
2006-05-09 10:00:00	IWM	ETF	77.45	77.6	77.41	77.56	2541500.0
2006-05-09 11:00:00	IWM	ETF	77.58	77.79	77.56	77.73	2426800.0
2006-05-09 12:00:00	IWM	ETF	77.73	77.77	77.56	77.62	1153500.0
2006-05-09 13:00:00	IWM	ETF	77.62	77.65	77.47	77.52	1906900.0
2006-05-09 14:00:00	IWM	ETF	77.52	77.63	77.48	77.6	1263300.0
2006-05-09 15:00:00	IWM	ETF	77.6	77.67	77.55	77.57	2218000.0
2006-05-09 16:00:00	IWM	ETF	77.57	77.59	77.45	77.58	2621100.0
2006-05-09 17:00:00	IWM	ETF	77.5	77.5	77.45	77.47	4000.0
2006-05-09 18:00:00	IWM	ETF	77.47	77.47	77.47	77.47	700.0
2006-05-09 08:00:00	DIA	ETF	115.8	115.8	115.8	115.8	500.0
2006-05-09 09:00:00	DIA	ETF	115.81	115.91	115.77	115.86	308700.0
2006-05-09 10:00:00	DIA	ETF	115.86	115.97	115.78	115.9524	554900.0
2006-05-09 11:00:00	DIA	ETF	115.97	116.26	115.94	116.16	646300.0
2006-05-09 12:00:00	DIA	ETF	116.16	116.2	116.13	116.16	296000.0
2006-05-09 13:00:00	DIA	ETF	116.16	116.19	116.04	116.09	235200.0
2006-05-09 14:00:00	DIA	ETF	116.09	116.21	116.058	116.16	463100.0
2006-05-09 15:00:00	DIA	ETF	116.17	116.35	116.14	116.33	1107500.0
2006-05-09 16:00:00	DIA	ETF	116.33	116.43	116.29	116.38	252900.0
2006-05-09 17:00:00	DIA	ETF	116.39	116.39	116.37	116.37	3900.0
2006-05-09 18:00:00	DIA	ETF	116.39	116.39	116.39	116.39	1000.0
2006-05-09 07:00:00	GLD	ETF	67.86	67.86	67.84	67.86	3300.0
2006-05-09 08:00:00	GLD	ETF	67.86	68.1	67.8	68.1	119900.0
2006-05-09 09:00:00	GLD	ETF	68.02	68.77	68.02	68.72	1762000.0
2006-05-09 10:00:00	GLD	ETF	68.69	69.35	68.67	69.1	3436500.0
2006-05-09 11:00:00	GLD	ETF	69.0988	69.55	69.09	69.46	1877900.0
2006-05-09 12:00:00	GLD	ETF	69.4612	69.53	69.21	69.47	1141900.0

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

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