PREVIEW / etf_1hour / 2008-08-19

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-08-19.parquet
  size:    109 KB
  rows:    3,561

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-08-19 04:00:00	SPY	ETF	128.13	128.13	128.13	128.13	600.0
2008-08-19 05:00:00	SPY	ETF	128.2	128.2	128.18	128.2	104000.0
2008-08-19 06:00:00	SPY	ETF	128.18	128.35	127.95	127.95	303800.0
2008-08-19 07:00:00	SPY	ETF	128.0	128.03	127.71	127.75	747638.0
2008-08-19 08:00:00	SPY	ETF	127.74	127.99	127.1	127.21	6585636.0
2008-08-19 09:00:00	SPY	ETF	127.2	128.39	126.98	127.28	30186466.0
2008-08-19 10:00:00	SPY	ETF	127.28	127.35	126.83	126.99	29623121.0
2008-08-19 11:00:00	SPY	ETF	126.99	127.04	126.58	126.64	21668437.0
2008-08-19 12:00:00	SPY	ETF	126.64	128.1181	126.55	127.04	20390881.0
2008-08-19 13:00:00	SPY	ETF	127.05	127.43	126.94	126.975	16882536.0
2008-08-19 14:00:00	SPY	ETF	126.99	127.14	126.65	126.93	18163909.0
2008-08-19 15:00:00	SPY	ETF	126.93	127.15	126.53	127.02	34511379.0
2008-08-19 16:00:00	SPY	ETF	126.9901	128.1184	126.91	126.99	5467370.0
2008-08-19 17:00:00	SPY	ETF	127.0	127.13	126.99	127.07	3102739.0
2008-08-19 18:00:00	SPY	ETF	127.06	127.09	127.02	127.09	41619.0
2008-08-19 19:00:00	SPY	ETF	127.09	127.19	127.05	127.19	16167.0
2008-08-19 06:00:00	QQQ	ETF	47.66	47.66	47.57	47.57	4400.0
2008-08-19 07:00:00	QQQ	ETF	47.6	47.6	47.41	47.43	950452.0
2008-08-19 08:00:00	QQQ	ETF	47.43	47.49	47.3	47.34	4058962.0
2008-08-19 09:00:00	QQQ	ETF	47.35	47.59	47.24	47.38	31395890.0
2008-08-19 10:00:00	QQQ	ETF	47.38	47.38	47.14	47.2	18943026.0
2008-08-19 11:00:00	QQQ	ETF	47.2	47.33	47.11	47.12	13406877.0
2008-08-19 12:00:00	QQQ	ETF	47.12	47.21	46.98	47.11	15350437.0
2008-08-19 13:00:00	QQQ	ETF	47.11	47.39	47.07	47.11	13160692.0
2008-08-19 14:00:00	QQQ	ETF	47.1	47.208	46.92	47.01	14042211.0
2008-08-19 15:00:00	QQQ	ETF	47.01	47.01	46.75	46.99	24957984.0
2008-08-19 16:00:00	QQQ	ETF	47.0	47.5529	46.9308	47.13	11180693.0
2008-08-19 17:00:00	QQQ	ETF	47.13	47.18	47.12	47.13	268704.0
2008-08-19 18:00:00	QQQ	ETF	47.16	47.17	47.11	47.13	38949.0
2008-08-19 19:00:00	QQQ	ETF	47.15	47.15	47.14	47.15	5450.0
2008-08-19 05:00:00	IWM	ETF	74.1	74.1	74.07	74.07	5000.0
2008-08-19 06:00:00	IWM	ETF	74.17	74.17	74.0	74.0	34000.0
2008-08-19 07:00:00	IWM	ETF	73.99	74.05	73.89	73.9	253066.0
2008-08-19 08:00:00	IWM	ETF	73.95	73.95	73.49	73.56	1466573.0
2008-08-19 09:00:00	IWM	ETF	73.58	74.13	72.95	73.34	18068905.0
2008-08-19 10:00:00	IWM	ETF	73.34	73.4	73.0	73.17	16319028.0
2008-08-19 11:00:00	IWM	ETF	73.18	73.23	72.8	72.8	11269820.0
2008-08-19 12:00:00	IWM	ETF	72.81	73.11	72.71	72.91	9365228.0
2008-08-19 13:00:00	IWM	ETF	72.91	73.29	72.79	72.91	7703812.0
2008-08-19 14:00:00	IWM	ETF	72.91	73.16	72.68	72.86	14021692.0
2008-08-19 15:00:00	IWM	ETF	72.86	72.88	72.44	72.82	20228696.0
2008-08-19 16:00:00	IWM	ETF	72.82	74.05	72.75	72.88	3293388.0
2008-08-19 17:00:00	IWM	ETF	72.87	72.91	72.85	72.86	55889.0
2008-08-19 18:00:00	IWM	ETF	72.87	72.87	72.86	72.86	7800.0
2008-08-19 19:00:00	IWM	ETF	72.9	72.9	72.9	72.9	800.0
2008-08-19 04:00:00	DIA	ETF	114.87	114.87	114.87	114.87	100.0
2008-08-19 06:00:00	DIA	ETF	114.7	114.7	114.51	114.51	1600.0
2008-08-19 07:00:00	DIA	ETF	114.54	114.54	114.42	114.44	12400.0
2008-08-19 08:00:00	DIA	ETF	114.43	114.47	113.85	113.92	187144.0
2008-08-19 09:00:00	DIA	ETF	113.94	114.21	113.62	113.91	1910272.0

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

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