PREVIEW / etf_1hour / 2006-05-18

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-05-18.parquet
  size:    44 KB
  rows:    1,375

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-18 04:00:00	SPY	ETF	127.56	127.56	127.51	127.51	5100.0
2006-05-18 05:00:00	SPY	ETF	127.41	127.41	127.38	127.38	5000.0
2006-05-18 06:00:00	SPY	ETF	127.48	127.48	127.38	127.38	77500.0
2006-05-18 07:00:00	SPY	ETF	127.45	127.46	127.15	127.26	544900.0
2006-05-18 08:00:00	SPY	ETF	127.24	127.55	127.15	127.49	3127800.0
2006-05-18 09:00:00	SPY	ETF	127.46	127.75	127.24	127.5	12788200.0
2006-05-18 10:00:00	SPY	ETF	127.51	127.7	127.27	127.38	12331400.0
2006-05-18 11:00:00	SPY	ETF	127.4	127.64	127.04	127.3	15922800.0
2006-05-18 12:00:00	SPY	ETF	127.29	127.59	127.12	127.52	8917100.0
2006-05-18 13:00:00	SPY	ETF	127.52	127.61	127.32	127.52	4335100.0
2006-05-18 14:00:00	SPY	ETF	127.52	127.53	127.12	127.28	5617900.0
2006-05-18 15:00:00	SPY	ETF	127.31	127.33	126.36	126.37	20438800.0
2006-05-18 16:00:00	SPY	ETF	126.36	126.43	126.11	126.3	2091700.0
2006-05-18 17:00:00	SPY	ETF	126.3	126.33	126.22	126.29	75200.0
2006-05-18 18:00:00	SPY	ETF	126.29	126.39	126.29	126.34	18100.0
2006-05-18 19:00:00	SPY	ETF	126.38	126.44	126.33	126.44	13800.0
2006-05-18 09:00:00	QQQ	ETF	39.49	39.66	39.43	39.55	21479500.0
2006-05-18 10:00:00	QQQ	ETF	39.56	39.63	39.41	39.46	17601300.0
2006-05-18 11:00:00	QQQ	ETF	39.47	39.49	39.31	39.42	17809000.0
2006-05-18 12:00:00	QQQ	ETF	39.42	39.53	39.37	39.49	13707300.0
2006-05-18 13:00:00	QQQ	ETF	39.49	39.52	39.43	39.49	4993800.0
2006-05-18 14:00:00	QQQ	ETF	39.49	39.49	39.37	39.41	11138400.0
2006-05-18 15:00:00	QQQ	ETF	39.41	39.41	39.0	39.05	31486700.0
2006-05-18 07:00:00	IWM	ETF	72.1	72.1	72.1	72.1	10000.0
2006-05-18 08:00:00	IWM	ETF	72.2	72.45	71.96	72.42	3076000.0
2006-05-18 09:00:00	IWM	ETF	72.43	72.86	72.35	72.69	7350100.0
2006-05-18 10:00:00	IWM	ETF	72.68	72.81	72.43	72.51	9660200.0
2006-05-18 11:00:00	IWM	ETF	72.52	72.64	72.1	72.36	8154000.0
2006-05-18 12:00:00	IWM	ETF	72.36	72.64	72.27	72.52	2645700.0
2006-05-18 13:00:00	IWM	ETF	72.53	72.56	72.36	72.49	3380700.0
2006-05-18 14:00:00	IWM	ETF	72.51	72.52	72.24	72.31	3929000.0
2006-05-18 15:00:00	IWM	ETF	72.31	72.36	71.34	71.35	13103300.0
2006-05-18 16:00:00	IWM	ETF	71.36	71.45	71.13	71.25	1690100.0
2006-05-18 17:00:00	IWM	ETF	71.2	71.45	71.2	71.32	28300.0
2006-05-18 18:00:00	IWM	ETF	71.25	71.25	71.21	71.22	12200.0
2006-05-18 19:00:00	IWM	ETF	71.21	71.22	71.18	71.18	3300.0
2006-05-18 07:00:00	DIA	ETF	112.35	112.35	112.3	112.3	600.0
2006-05-18 08:00:00	DIA	ETF	112.3	112.69	112.28	112.45	157300.0
2006-05-18 09:00:00	DIA	ETF	112.47	113.61	112.25	112.4	2040600.0
2006-05-18 10:00:00	DIA	ETF	112.39	112.56	112.14	112.35	1704800.0
2006-05-18 11:00:00	DIA	ETF	112.36	112.56	112.05	112.3	1571900.0
2006-05-18 12:00:00	DIA	ETF	112.31	112.52	112.18	112.44	855300.0
2006-05-18 13:00:00	DIA	ETF	112.44	112.5	112.28	112.38	582000.0
2006-05-18 14:00:00	DIA	ETF	112.38	112.3999	112.12	112.24	867500.0
2006-05-18 15:00:00	DIA	ETF	112.24	112.25	111.46	111.52	2629500.0
2006-05-18 16:00:00	DIA	ETF	111.46	111.5	111.3	111.4	97200.0
2006-05-18 17:00:00	DIA	ETF	111.4	111.48	111.3	111.33	2900.0
2006-05-18 06:00:00	GLD	ETF	68.27	68.27	68.27	68.27	400.0
2006-05-18 07:00:00	GLD	ETF	68.4	68.4	68.12	68.16	5800.0
2006-05-18 08:00:00	GLD	ETF	68.17	68.81	68.17	68.52	314300.0

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

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