PREVIEW / etf_1hour / 2008-04-18

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-18.parquet
  size:    107 KB
  rows:    3,478

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-04-18 05:00:00	SPY	ETF	137.28	137.28	137.28	137.28	100.0
2008-04-18 06:00:00	SPY	ETF	137.45	138.17	137.45	138.17	404654.0
2008-04-18 07:00:00	SPY	ETF	138.12	138.77	138.12	138.62	3027164.0
2008-04-18 08:00:00	SPY	ETF	138.56	138.95	138.0239	138.94	5712744.0
2008-04-18 09:00:00	SPY	ETF	138.94	138.98	138.41	138.51	24589177.0
2008-04-18 10:00:00	SPY	ETF	138.51	139.01	138.26	138.85	36301793.0
2008-04-18 11:00:00	SPY	ETF	138.85	139.33	138.65	139.23	30155005.0
2008-04-18 12:00:00	SPY	ETF	139.22	139.44	139.09	139.21	19380744.0
2008-04-18 13:00:00	SPY	ETF	139.2	139.56	139.18	139.29	18504815.0
2008-04-18 14:00:00	SPY	ETF	139.3	139.4	138.86	139.0	22106640.0
2008-04-18 15:00:00	SPY	ETF	139.0	139.07	138.51	138.93	35144846.0
2008-04-18 16:00:00	SPY	ETF	138.9399	138.96	138.48	138.55	14683394.0
2008-04-18 17:00:00	SPY	ETF	138.55	138.8228	138.47	138.6	1354120.0
2008-04-18 18:00:00	SPY	ETF	138.6	138.62	138.54	138.54	19591.0
2008-04-18 19:00:00	SPY	ETF	138.54	138.58	138.45	138.58	12980.0
2008-04-18 04:00:00	QQQ	ETF	45.97	45.97	45.9	45.9	300.0
2008-04-18 05:00:00	QQQ	ETF	45.92	46.0	45.92	46.0	1400.0
2008-04-18 06:00:00	QQQ	ETF	46.0	46.17	46.0	46.13	133700.0
2008-04-18 07:00:00	QQQ	ETF	46.13	46.24	46.13	46.23	1057541.0
2008-04-18 08:00:00	QQQ	ETF	46.23	46.43	46.0	46.42	2744599.0
2008-04-18 09:00:00	QQQ	ETF	46.42	46.55	46.25	46.28	25126042.0
2008-04-18 10:00:00	QQQ	ETF	46.28	46.56	46.22	46.53	16130819.0
2008-04-18 11:00:00	QQQ	ETF	46.53	46.78	46.5	46.77	15664255.0
2008-04-18 12:00:00	QQQ	ETF	46.76	46.9	46.74	46.8	12908895.0
2008-04-18 13:00:00	QQQ	ETF	46.8001	46.93	46.79	46.8699	8569907.0
2008-04-18 14:00:00	QQQ	ETF	46.87	46.88	46.72	46.78	15059965.0
2008-04-18 15:00:00	QQQ	ETF	46.7705	46.81	46.59	46.7	27267923.0
2008-04-18 16:00:00	QQQ	ETF	46.71	46.82	46.5	46.76	6757074.0
2008-04-18 17:00:00	QQQ	ETF	46.76	46.77	46.66	46.71	98166.0
2008-04-18 18:00:00	QQQ	ETF	46.72	46.74	46.66	46.66	20205.0
2008-04-18 19:00:00	QQQ	ETF	46.67	46.71	46.66	46.71	34125.0
2008-04-18 07:00:00	IWM	ETF	71.65	71.86	71.58	71.82	218779.0
2008-04-18 08:00:00	IWM	ETF	71.77	71.96	71.7	71.96	709799.0
2008-04-18 09:00:00	IWM	ETF	71.96	72.1	71.59	71.6	9708303.0
2008-04-18 10:00:00	IWM	ETF	71.59	72.02	71.47	71.91	12139572.0
2008-04-18 11:00:00	IWM	ETF	71.91	72.18	71.81	72.12	6033094.0
2008-04-18 12:00:00	IWM	ETF	72.11	72.27	71.93	71.94	5906562.0
2008-04-18 13:00:00	IWM	ETF	71.94	72.22	71.93	72.14	4290555.0
2008-04-18 14:00:00	IWM	ETF	72.14	72.15	71.7	71.73	6614218.0
2008-04-18 15:00:00	IWM	ETF	71.74	71.92	71.57	71.66	12903493.0
2008-04-18 16:00:00	IWM	ETF	71.66	71.92	71.5	71.61	8939969.0
2008-04-18 17:00:00	IWM	ETF	71.61	71.61	71.58	71.6	1682.0
2008-04-18 18:00:00	IWM	ETF	71.56	71.56	71.55	71.55	792.0
2008-04-18 19:00:00	IWM	ETF	71.55	71.55	71.55	71.55	182.0
2008-04-18 06:00:00	DIA	ETF	126.66	126.66	126.66	126.66	100.0
2008-04-18 07:00:00	DIA	ETF	127.28	127.99	127.28	127.79	52300.0
2008-04-18 08:00:00	DIA	ETF	127.77	127.94	127.61	127.94	93561.0
2008-04-18 09:00:00	DIA	ETF	127.95	128.15	127.81	127.85	3345758.0
2008-04-18 10:00:00	DIA	ETF	127.84	128.34	127.76	128.21	3276836.0
2008-04-18 11:00:00	DIA	ETF	128.22	128.6	128.01	128.53	2380129.0

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

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