PREVIEW / etf_1hour / 2008-05-15

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-05-15.parquet
  size:    106 KB
  rows:    3,388

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-05-15 05:00:00	SPY	ETF	141.12	141.12	141.12	141.12	6000.0
2008-05-15 06:00:00	SPY	ETF	141.2	141.21	141.07	141.07	341524.0
2008-05-15 07:00:00	SPY	ETF	141.05	141.32	140.98	141.29	679576.0
2008-05-15 08:00:00	SPY	ETF	141.29	141.46	140.85	141.22	3026985.0
2008-05-15 09:00:00	SPY	ETF	141.25	141.33	140.83	141.19	17646191.0
2008-05-15 10:00:00	SPY	ETF	141.191	141.43	140.87	141.32	26700077.0
2008-05-15 11:00:00	SPY	ETF	141.32	141.53	141.03	141.29	15877008.0
2008-05-15 12:00:00	SPY	ETF	141.29	141.92	141.2	141.71	24080692.0
2008-05-15 13:00:00	SPY	ETF	141.71	141.9	141.54	141.69	13099954.0
2008-05-15 14:00:00	SPY	ETF	141.68	142.06	141.61	141.92	20371439.0
2008-05-15 15:00:00	SPY	ETF	141.91	142.63	141.805	142.55	37052418.0
2008-05-15 16:00:00	SPY	ETF	142.55	142.95	141.048	142.4	5475223.0
2008-05-15 17:00:00	SPY	ETF	142.41	142.54	140.9325	142.45	412191.0
2008-05-15 18:00:00	SPY	ETF	142.44	142.46	142.26	142.26	18479.0
2008-05-15 19:00:00	SPY	ETF	142.28	142.33	142.27	142.33	7550.0
2008-05-15 06:00:00	QQQ	ETF	49.22	49.22	49.16	49.16	3800.0
2008-05-15 07:00:00	QQQ	ETF	49.17	49.22	49.13	49.22	179928.0
2008-05-15 08:00:00	QQQ	ETF	49.23	49.26	49.15	49.24	1830155.0
2008-05-15 09:00:00	QQQ	ETF	49.25	49.28	48.98	49.24	15115718.0
2008-05-15 10:00:00	QQQ	ETF	49.24	49.4	49.09	49.3299	21536276.0
2008-05-15 11:00:00	QQQ	ETF	49.33	49.471	49.21	49.41	17919329.0
2008-05-15 12:00:00	QQQ	ETF	49.41	49.78	49.39	49.69	22666410.0
2008-05-15 13:00:00	QQQ	ETF	49.68	49.8	49.63	49.7	12715994.0
2008-05-15 14:00:00	QQQ	ETF	49.71	49.81	49.57	49.712	19884196.0
2008-05-15 15:00:00	QQQ	ETF	49.7125	50.02	49.67	49.98	25911625.0
2008-05-15 16:00:00	QQQ	ETF	49.98	50.08	49.1499	49.99	8655741.0
2008-05-15 17:00:00	QQQ	ETF	49.99	50.01	49.96	50.01	316961.0
2008-05-15 18:00:00	QQQ	ETF	50.0	50.02	49.95	49.95	59392.0
2008-05-15 19:00:00	QQQ	ETF	49.96	49.96	49.94	49.96	26965.0
2008-05-15 07:00:00	IWM	ETF	73.56	73.56	73.56	73.56	7000.0
2008-05-15 08:00:00	IWM	ETF	73.59	73.61	73.49	73.53	121628.0
2008-05-15 09:00:00	IWM	ETF	73.54	73.57	73.1	73.4	4963930.0
2008-05-15 10:00:00	IWM	ETF	73.4	73.68	73.28	73.64	7555442.0
2008-05-15 11:00:00	IWM	ETF	73.64	73.77	73.38	73.56	4112821.0
2008-05-15 12:00:00	IWM	ETF	73.56	73.94	73.53	73.86	5813345.0
2008-05-15 13:00:00	IWM	ETF	73.85	73.93	73.72	73.79	4585031.0
2008-05-15 14:00:00	IWM	ETF	73.8	74.06	73.78	73.94	4875117.0
2008-05-15 15:00:00	IWM	ETF	73.94	74.29	73.92	74.12	11330395.0
2008-05-15 16:00:00	IWM	ETF	74.14	74.27	73.55	74.13	2284809.0
2008-05-15 17:00:00	IWM	ETF	74.13	74.14	74.11	74.11	27044.0
2008-05-15 18:00:00	IWM	ETF	74.11	74.11	74.11	74.11	11956.0
2008-05-15 07:00:00	DIA	ETF	129.32	129.37	129.32	129.37	400.0
2008-05-15 08:00:00	DIA	ETF	129.36	129.44	129.17	129.2	36397.0
2008-05-15 09:00:00	DIA	ETF	129.18	129.22	128.75	129.15	1272640.0
2008-05-15 10:00:00	DIA	ETF	129.15	129.43	128.92	129.31	1730666.0
2008-05-15 11:00:00	DIA	ETF	129.31	129.45	129.01	129.23	1257418.0
2008-05-15 12:00:00	DIA	ETF	129.23	129.67	129.22	129.59	1251495.0
2008-05-15 13:00:00	DIA	ETF	129.57	129.77	129.46	129.57	1131823.0
2008-05-15 14:00:00	DIA	ETF	129.58	129.85	129.47	129.7	857418.0
2008-05-15 15:00:00	DIA	ETF	129.71	130.2	129.6	130.05	1523038.0

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

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