PREVIEW / etf_1hour / 2008-08-12

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-08-12.parquet
  size:    108 KB
  rows:    3,531

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-12 04:00:00	SPY	ETF	130.19	130.26	130.01	130.26	800.0
2008-08-12 05:00:00	SPY	ETF	130.57	130.57	130.57	130.57	1000.0
2008-08-12 06:00:00	SPY	ETF	130.34	130.6	130.32	130.6	38200.0
2008-08-12 07:00:00	SPY	ETF	130.61	130.91	130.53	130.6	467910.0
2008-08-12 08:00:00	SPY	ETF	130.6	130.65	130.27	130.45	2829707.0
2008-08-12 09:00:00	SPY	ETF	130.46	130.71	129.83	130.08	26793905.0
2008-08-12 10:00:00	SPY	ETF	130.08	130.34	129.59	129.83	34816639.0
2008-08-12 11:00:00	SPY	ETF	129.83	130.335	129.73	130.039	27098234.0
2008-08-12 12:00:00	SPY	ETF	130.03	130.7028	129.87	130.14	19945657.0
2008-08-12 13:00:00	SPY	ETF	130.14	130.22	129.62	129.73	19243945.0
2008-08-12 14:00:00	SPY	ETF	129.73	130.07	129.5	129.52	20236887.0
2008-08-12 15:00:00	SPY	ETF	129.52	129.56	128.73	129.25	52983541.0
2008-08-12 16:00:00	SPY	ETF	129.261	130.0	129.1	129.43	5618833.0
2008-08-12 17:00:00	SPY	ETF	129.4	129.53	129.35	129.5	195015.0
2008-08-12 18:00:00	SPY	ETF	129.46	129.49	129.36	129.37	202999.0
2008-08-12 19:00:00	SPY	ETF	129.39	129.4	129.3	129.3	16723.0
2008-08-12 04:00:00	QQQ	ETF	47.58	47.58	47.52	47.52	700.0
2008-08-12 05:00:00	QQQ	ETF	47.63	47.66	47.63	47.66	1500.0
2008-08-12 06:00:00	QQQ	ETF	47.7	47.78	47.7	47.78	600.0
2008-08-12 07:00:00	QQQ	ETF	47.79	47.93	47.79	47.82	158303.0
2008-08-12 08:00:00	QQQ	ETF	47.83	47.88	47.65	47.75	1530782.0
2008-08-12 09:00:00	QQQ	ETF	47.75	47.82	47.51	47.71	20077938.0
2008-08-12 10:00:00	QQQ	ETF	47.72	48.07	47.64	47.83	31120132.0
2008-08-12 11:00:00	QQQ	ETF	47.83	48.16	47.79	47.93	21946331.0
2008-08-12 12:00:00	QQQ	ETF	47.93	48.0	47.87	48.0	7001704.0
2008-08-12 13:00:00	QQQ	ETF	47.99	48.03	47.78	47.82	12108466.0
2008-08-12 14:00:00	QQQ	ETF	47.81	48.04	47.81	47.83	7624332.0
2008-08-12 15:00:00	QQQ	ETF	47.83	47.86	47.54	47.76	33717636.0
2008-08-12 16:00:00	QQQ	ETF	47.77	47.915	47.6574	47.83	4394909.0
2008-08-12 17:00:00	QQQ	ETF	47.82	47.89	47.81	47.87	297135.0
2008-08-12 18:00:00	QQQ	ETF	47.86	47.87	47.83	47.85	31685.0
2008-08-12 19:00:00	QQQ	ETF	47.85	47.85	47.83	47.85	27615.0
2008-08-12 05:00:00	IWM	ETF	74.83	74.83	74.83	74.83	500.0
2008-08-12 06:00:00	IWM	ETF	74.73	74.98	74.69	74.98	13200.0
2008-08-12 07:00:00	IWM	ETF	74.97	75.13	74.86	74.88	87994.0
2008-08-12 08:00:00	IWM	ETF	74.89	74.92	74.76	74.77	796180.0
2008-08-12 09:00:00	IWM	ETF	74.76	74.78	74.36	74.52	12893610.0
2008-08-12 10:00:00	IWM	ETF	74.53	74.89	74.12	74.38	22014613.0
2008-08-12 11:00:00	IWM	ETF	74.38	74.76	74.25	74.53	13045288.0
2008-08-12 12:00:00	IWM	ETF	74.53	74.58	74.3	74.51	8654515.0
2008-08-12 13:00:00	IWM	ETF	74.52	74.62	74.32	74.37	10838163.0
2008-08-12 14:00:00	IWM	ETF	74.37	74.6	74.26	74.42	13956093.0
2008-08-12 15:00:00	IWM	ETF	74.42	74.44	74.06	74.28	30728619.0
2008-08-12 16:00:00	IWM	ETF	74.31	74.92	74.3	74.92	4900139.0
2008-08-12 17:00:00	IWM	ETF	74.57	74.6	74.55	74.6	3874.0
2008-08-12 18:00:00	IWM	ETF	74.54	74.55	74.52	74.53	2300.0
2008-08-12 19:00:00	IWM	ETF	74.54	74.54	74.51	74.51	277.0
2008-08-12 06:00:00	DIA	ETF	117.78	117.78	117.68	117.68	500.0
2008-08-12 07:00:00	DIA	ETF	117.89	118.02	117.79	117.79	2700.0
2008-08-12 08:00:00	DIA	ETF	117.77	117.82	117.49	117.72	95919.0

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

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