PREVIEW / etf_1hour / 2008-08-11

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-08-11.parquet
  size:    112 KB
  rows:    3,615

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-11 04:00:00	SPY	ETF	129.19	129.19	129.19	129.19	200.0
2008-08-11 05:00:00	SPY	ETF	129.39	129.53	129.39	129.53	10100.0
2008-08-11 06:00:00	SPY	ETF	129.4	129.56	129.38	129.56	21231.0
2008-08-11 07:00:00	SPY	ETF	129.5	129.65	129.47	129.64	228850.0
2008-08-11 08:00:00	SPY	ETF	129.64	129.74	129.39	129.56	1213730.0
2008-08-11 09:00:00	SPY	ETF	129.59	129.9	129.23	129.825	24429507.0
2008-08-11 10:00:00	SPY	ETF	129.82	130.04	129.4	129.94	26892390.0
2008-08-11 11:00:00	SPY	ETF	129.95	130.73	129.89	130.67	30770345.0
2008-08-11 12:00:00	SPY	ETF	130.68	131.23	130.64	130.99	29327721.0
2008-08-11 13:00:00	SPY	ETF	130.99	131.51	130.9	131.11	28049946.0
2008-08-11 14:00:00	SPY	ETF	131.11	131.16	130.19	130.4	48188294.0
2008-08-11 15:00:00	SPY	ETF	130.42	130.84	129.94	130.65	46446236.0
2008-08-11 16:00:00	SPY	ETF	130.64	130.85	129.7667	130.57	3810406.0
2008-08-11 17:00:00	SPY	ETF	130.58	130.67	130.56	130.61	65476.0
2008-08-11 18:00:00	SPY	ETF	130.61	130.71	130.56	130.56	110150.0
2008-08-11 19:00:00	SPY	ETF	130.59	130.59	130.5	130.52	11756.0
2008-08-11 04:00:00	QQQ	ETF	47.22	47.22	47.22	47.22	100.0
2008-08-11 06:00:00	QQQ	ETF	47.31	47.31	47.31	47.31	1200.0
2008-08-11 07:00:00	QQQ	ETF	47.33	47.46	47.31	47.42	1048097.0
2008-08-11 08:00:00	QQQ	ETF	47.42	47.44	47.3	47.33	1868195.0
2008-08-11 09:00:00	QQQ	ETF	47.34	47.56	47.14	47.52	19696348.0
2008-08-11 10:00:00	QQQ	ETF	47.51	47.67	47.45	47.58	15959837.0
2008-08-11 11:00:00	QQQ	ETF	47.59	47.89	47.58	47.8615	16696938.0
2008-08-11 12:00:00	QQQ	ETF	47.86	48.1	47.84	48.0	20755736.0
2008-08-11 13:00:00	QQQ	ETF	48.0	48.28	47.95	48.14	21925327.0
2008-08-11 14:00:00	QQQ	ETF	48.15	48.16	47.56	47.65	26774166.0
2008-08-11 15:00:00	QQQ	ETF	47.66	47.83	47.42	47.74	27543349.0
2008-08-11 16:00:00	QQQ	ETF	47.73	47.8865	47.5729	47.7	3915181.0
2008-08-11 17:00:00	QQQ	ETF	47.7	47.7	47.68	47.69	113115.0
2008-08-11 18:00:00	QQQ	ETF	47.69	47.75	47.68	47.7	30110.0
2008-08-11 19:00:00	QQQ	ETF	47.72	47.72	47.69	47.71	22045.0
2008-08-11 06:00:00	IWM	ETF	73.3	73.3	73.23	73.23	7200.0
2008-08-11 07:00:00	IWM	ETF	73.27	73.34	73.27	73.33	95113.0
2008-08-11 08:00:00	IWM	ETF	73.33	73.34	73.18	73.23	704766.0
2008-08-11 09:00:00	IWM	ETF	73.24	73.5	73.12	73.46	9822572.0
2008-08-11 10:00:00	IWM	ETF	73.46	73.85	73.37	73.8	14883199.0
2008-08-11 11:00:00	IWM	ETF	73.81	74.57	73.79	74.48	17618447.0
2008-08-11 12:00:00	IWM	ETF	74.47	75.01	74.46	74.97	17429694.0
2008-08-11 13:00:00	IWM	ETF	74.98	75.6	74.8	75.37	24059816.0
2008-08-11 14:00:00	IWM	ETF	75.37	75.45	74.71	74.97	38063983.0
2008-08-11 15:00:00	IWM	ETF	74.97	75.2	73.25	74.86	29908244.0
2008-08-11 16:00:00	IWM	ETF	74.86	75.35	73.25	74.85	11320239.0
2008-08-11 17:00:00	IWM	ETF	74.93	74.93	74.88	74.88	36500.0
2008-08-11 06:00:00	DIA	ETF	117.2	117.2	117.2	117.2	100.0
2008-08-11 07:00:00	DIA	ETF	117.14	117.32	117.14	117.25	5503.0
2008-08-11 08:00:00	DIA	ETF	117.25	117.33	117.02	117.14	80943.0
2008-08-11 09:00:00	DIA	ETF	117.16	117.3	116.8	117.26	2238320.0
2008-08-11 10:00:00	DIA	ETF	117.27	117.44	116.94	117.23	2654932.0
2008-08-11 11:00:00	DIA	ETF	117.24	118.01	117.19	117.94	3009659.0
2008-08-11 12:00:00	DIA	ETF	117.94	118.36	117.84	118.14	2724121.0

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

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