PREVIEW / etf_1hour / 2008-07-22

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-22.parquet
  size:    113 KB
  rows:    3,595

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-07-22 04:00:00	SPY	ETF	125.1	125.13	125.1	125.13	400.0
2008-07-22 05:00:00	SPY	ETF	125.2	125.4	125.2	125.28	1100.0
2008-07-22 06:00:00	SPY	ETF	125.35	125.38	124.9	125.14	721300.0
2008-07-22 07:00:00	SPY	ETF	125.03	125.21	124.8	125.1	1217492.0
2008-07-22 08:00:00	SPY	ETF	125.1	125.35	124.85	125.28	3538155.0
2008-07-22 09:00:00	SPY	ETF	125.28	125.43	124.89	125.4	34119974.0
2008-07-22 10:00:00	SPY	ETF	125.39	126.01	124.85	125.65	51732345.0
2008-07-22 11:00:00	SPY	ETF	125.65	126.34	125.63	125.98	41196534.0
2008-07-22 12:00:00	SPY	ETF	125.97	126.35	125.76	126.03	28069809.0
2008-07-22 13:00:00	SPY	ETF	126.03	126.27	125.86	126.15	26262194.0
2008-07-22 14:00:00	SPY	ETF	126.15	126.5	125.74	126.39	41649762.0
2008-07-22 15:00:00	SPY	ETF	126.39	127.8	126.33	127.69	51519317.0
2008-07-22 16:00:00	SPY	ETF	127.6599	127.8	125.8	127.42	12978554.0
2008-07-22 17:00:00	SPY	ETF	127.4	127.48	127.32	127.41	391631.0
2008-07-22 18:00:00	SPY	ETF	127.41	127.48	127.37	127.4	84468.0
2008-07-22 19:00:00	SPY	ETF	127.43	127.51	127.4	127.48	5970.0
2008-07-22 04:00:00	QQQ	ETF	43.99	44.05	43.99	44.05	1000.0
2008-07-22 05:00:00	QQQ	ETF	44.07	44.08	44.07	44.08	200.0
2008-07-22 06:00:00	QQQ	ETF	44.07	44.07	43.98	44.0	1900.0
2008-07-22 07:00:00	QQQ	ETF	43.96	44.1	43.93	44.03	575767.0
2008-07-22 08:00:00	QQQ	ETF	44.02	44.11	43.96	44.07	1924425.0
2008-07-22 09:00:00	QQQ	ETF	44.08	44.19	43.86	44.1	22112826.0
2008-07-22 10:00:00	QQQ	ETF	44.1	44.41	44.0	44.08	31402939.0
2008-07-22 11:00:00	QQQ	ETF	44.07	44.36	44.04	44.1599	26288081.0
2008-07-22 12:00:00	QQQ	ETF	44.15	44.24	44.1	44.16	10967600.0
2008-07-22 13:00:00	QQQ	ETF	44.162	44.32	44.1	44.26	10300982.0
2008-07-22 14:00:00	QQQ	ETF	44.26	44.42	44.07	44.42	17977515.0
2008-07-22 15:00:00	QQQ	ETF	44.42	44.81	44.3	44.78	22600244.0
2008-07-22 16:00:00	QQQ	ETF	44.78	44.85	44.1	44.79	5659902.0
2008-07-22 17:00:00	QQQ	ETF	44.79	44.82	44.72	44.75	237910.0
2008-07-22 18:00:00	QQQ	ETF	44.74	44.79	44.73	44.78	29514.0
2008-07-22 19:00:00	QQQ	ETF	44.75	44.78	44.75	44.76	12902.0
2008-07-22 06:00:00	IWM	ETF	69.1	69.15	69.1	69.15	1200.0
2008-07-22 07:00:00	IWM	ETF	69.11	69.18	68.98	69.14	104105.0
2008-07-22 08:00:00	IWM	ETF	69.15	69.28	68.71	69.24	728963.0
2008-07-22 09:00:00	IWM	ETF	69.25	69.59	69.02	69.54	14680764.0
2008-07-22 10:00:00	IWM	ETF	69.54	70.01	69.52	69.79	18733082.0
2008-07-22 11:00:00	IWM	ETF	69.79	70.61	69.79	70.41	22422406.0
2008-07-22 12:00:00	IWM	ETF	70.41	70.67	70.36	70.37	11971628.0
2008-07-22 13:00:00	IWM	ETF	70.37	70.47	70.13	70.43	11338702.0
2008-07-22 14:00:00	IWM	ETF	70.42	70.72	70.19	70.7	13251290.0
2008-07-22 15:00:00	IWM	ETF	70.7	71.48	70.68	71.48	26485578.0
2008-07-22 16:00:00	IWM	ETF	71.48	71.61	69.56	71.39	8722080.0
2008-07-22 17:00:00	IWM	ETF	71.35	71.39	71.34	71.34	22509.0
2008-07-22 18:00:00	IWM	ETF	71.39	71.43	71.38	71.38	7940.0
2008-07-22 19:00:00	IWM	ETF	71.39	71.39	71.32	71.32	600.0
2008-07-22 06:00:00	DIA	ETF	113.66	113.66	113.66	113.66	500.0
2008-07-22 07:00:00	DIA	ETF	113.53	113.76	113.46	113.76	6927.0
2008-07-22 08:00:00	DIA	ETF	113.78	114.03	113.64	114.01	79946.0
2008-07-22 09:00:00	DIA	ETF	114.02	114.33	113.75	114.28	2823654.0

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

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