PREVIEW / etf_1hour / 2008-06-16

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-06-16.parquet
  size:    105 KB
  rows:    3,371

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
2008-06-16 04:00:00	SPY	ETF	136.29	136.36	136.29	136.36	900.0
2008-06-16 05:00:00	SPY	ETF	136.5	136.59	136.5	136.59	300.0
2008-06-16 06:00:00	SPY	ETF	136.59	136.6	136.5	136.57	54500.0
2008-06-16 07:00:00	SPY	ETF	136.36	136.41	136.0	136.07	982900.0
2008-06-16 08:00:00	SPY	ETF	136.57	136.57	135.59	135.73	4362560.0
2008-06-16 09:00:00	SPY	ETF	135.75	135.97	135.38	135.82	24456346.0
2008-06-16 10:00:00	SPY	ETF	135.82	136.57	135.63	136.52	33341320.0
2008-06-16 11:00:00	SPY	ETF	136.52	136.55	136.03	136.22	21331961.0
2008-06-16 12:00:00	SPY	ETF	136.23	136.46	135.93	136.27	15534748.0
2008-06-16 13:00:00	SPY	ETF	136.28	136.93	135.96	136.73	29620053.0
2008-06-16 14:00:00	SPY	ETF	136.73	136.87	136.44	136.79	16033411.0
2008-06-16 15:00:00	SPY	ETF	136.8	136.87	136.295	136.44	30162150.0
2008-06-16 16:00:00	SPY	ETF	136.37	136.46	136.0	136.14	5658083.0
2008-06-16 17:00:00	SPY	ETF	136.13	136.15	136.04	136.1	132305.0
2008-06-16 18:00:00	SPY	ETF	136.1	136.21	136.1	136.18	14227.0
2008-06-16 19:00:00	SPY	ETF	136.18	136.23	136.13	136.23	3158.0
2008-06-16 05:00:00	QQQ	ETF	48.35	48.35	48.35	48.35	100.0
2008-06-16 06:00:00	QQQ	ETF	48.4	48.42	48.38	48.42	2900.0
2008-06-16 07:00:00	QQQ	ETF	48.38	48.38	48.21	48.21	72656.0
2008-06-16 08:00:00	QQQ	ETF	48.21	48.31	48.1	48.11	1515497.0
2008-06-16 09:00:00	QQQ	ETF	48.11	48.33	48.05	48.22	17496844.0
2008-06-16 10:00:00	QQQ	ETF	48.22	48.73	48.16	48.65	23130375.0
2008-06-16 11:00:00	QQQ	ETF	48.66	48.78	48.53	48.6	15065511.0
2008-06-16 12:00:00	QQQ	ETF	48.61	48.66	48.45	48.5889	8024079.0
2008-06-16 13:00:00	QQQ	ETF	48.59	49.02	48.49	48.93	23143323.0
2008-06-16 14:00:00	QQQ	ETF	48.94	48.96	48.74	48.9201	11626824.0
2008-06-16 15:00:00	QQQ	ETF	48.93	48.93	48.73	48.8	14173044.0
2008-06-16 16:00:00	QQQ	ETF	48.81	48.84	48.3858	48.65	11484857.0
2008-06-16 17:00:00	QQQ	ETF	48.65	48.68	48.65	48.68	17990.0
2008-06-16 18:00:00	QQQ	ETF	48.65	48.72	48.65	48.72	25420.0
2008-06-16 19:00:00	QQQ	ETF	48.72	48.72	48.7	48.71	15650.0
2008-06-16 07:00:00	IWM	ETF	73.5	73.5	73.36	73.4	176923.0
2008-06-16 08:00:00	IWM	ETF	73.71	73.71	73.06	73.12	1052257.0
2008-06-16 09:00:00	IWM	ETF	73.12	73.41	72.95	73.13	8556177.0
2008-06-16 10:00:00	IWM	ETF	73.12	73.76	72.98	73.65	12032758.0
2008-06-16 11:00:00	IWM	ETF	73.64	73.71	73.43	73.63	6876135.0
2008-06-16 12:00:00	IWM	ETF	73.64	73.78	73.45	73.67	5344387.0
2008-06-16 13:00:00	IWM	ETF	73.67	73.98	73.38	73.81	10121426.0
2008-06-16 14:00:00	IWM	ETF	73.81	74.06	73.58	74.01	5134941.0
2008-06-16 15:00:00	IWM	ETF	74.01	74.09	73.83	73.96	8197197.0
2008-06-16 16:00:00	IWM	ETF	73.96	73.98	73.62	73.7	6173245.0
2008-06-16 17:00:00	IWM	ETF	73.69	73.74	73.32	73.32	1536444.0
2008-06-16 18:00:00	IWM	ETF	73.7	73.7	73.7	73.7	1000.0
2008-06-16 19:00:00	IWM	ETF	73.69	73.69	73.66	73.66	8000.0
2008-06-16 07:00:00	DIA	ETF	123.14	123.14	123.01	123.01	930.0
2008-06-16 08:00:00	DIA	ETF	123.06	123.33	122.61	122.72	86168.0
2008-06-16 09:00:00	DIA	ETF	122.68	122.69	122.25	122.47	1901261.0
2008-06-16 10:00:00	DIA	ETF	122.47	123.11	122.34	123.07	2414595.0
2008-06-16 11:00:00	DIA	ETF	123.07	123.1	122.57	122.76	1577501.0
2008-06-16 12:00:00	DIA	ETF	122.77	122.86	122.5	122.69	1035178.0

> showing 50 of 3,371 rows — these rows as CSV

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