PREVIEW / etf_1hour / 2009-02-11

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-02-11.parquet
  size:    124 KB
  rows:    3,915

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
2009-02-11 04:00:00	SPY	ETF	83.34	83.55	83.32	83.51	8700.0
2009-02-11 05:00:00	SPY	ETF	83.36	83.57	83.36	83.57	7000.0
2009-02-11 06:00:00	SPY	ETF	83.56	83.66	83.12	83.12	10600.0
2009-02-11 07:00:00	SPY	ETF	83.14	83.25	82.77	82.88	1135468.0
2009-02-11 08:00:00	SPY	ETF	83.67	83.67	82.79	83.42	3154348.0
2009-02-11 09:00:00	SPY	ETF	83.4	83.97	83.26	83.7	30997096.0
2009-02-11 10:00:00	SPY	ETF	83.69	83.87	82.88	83.57	56481956.0
2009-02-11 11:00:00	SPY	ETF	83.57	84.05	83.31	83.56	38552740.0
2009-02-11 12:00:00	SPY	ETF	83.56	83.78	83.27	83.36	23554747.0
2009-02-11 13:00:00	SPY	ETF	83.37	83.65	82.58	82.735	36533310.0
2009-02-11 14:00:00	SPY	ETF	82.72	83.85	82.4	83.73	56368577.0
2009-02-11 15:00:00	SPY	ETF	83.73	84.0	83.08	83.67	59677404.0
2009-02-11 16:00:00	SPY	ETF	83.65	83.79	82.66	83.71	11207640.0
2009-02-11 17:00:00	SPY	ETF	83.72	83.75	83.68	83.69	45802.0
2009-02-11 18:00:00	SPY	ETF	83.68	83.71	83.46	83.48	95502.0
2009-02-11 19:00:00	SPY	ETF	83.49	83.62	83.27	83.61	162986.0
2009-02-11 06:00:00	QQQ	ETF	30.37	30.37	30.36	30.36	1000.0
2009-02-11 07:00:00	QQQ	ETF	30.31	30.41	30.13	30.17	482591.0
2009-02-11 08:00:00	QQQ	ETF	30.17	30.41	30.16	30.35	5198773.0
2009-02-11 09:00:00	QQQ	ETF	30.35	30.53	30.26	30.41	18252288.0
2009-02-11 10:00:00	QQQ	ETF	30.4	30.49	29.9	30.2	33175579.0
2009-02-11 11:00:00	QQQ	ETF	30.2	30.46	30.1	30.23	19112729.0
2009-02-11 12:00:00	QQQ	ETF	30.2299	30.31	30.1	30.15	11622394.0
2009-02-11 13:00:00	QQQ	ETF	30.15	30.24	29.81	29.86	21370084.0
2009-02-11 14:00:00	QQQ	ETF	29.8595	30.36	29.73	30.29	30262325.0
2009-02-11 15:00:00	QQQ	ETF	30.28	30.37	30.0	30.22	24496470.0
2009-02-11 16:00:00	QQQ	ETF	30.22	30.24	30.11	30.2	2980241.0
2009-02-11 17:00:00	QQQ	ETF	30.17	30.19	30.15	30.15	13894.0
2009-02-11 18:00:00	QQQ	ETF	30.16	30.18	30.14	30.14	17204.0
2009-02-11 19:00:00	QQQ	ETF	30.14	30.17	30.09	30.15	41921.0
2009-02-11 07:00:00	IWM	ETF	44.76	44.83	44.54	44.59	108977.0
2009-02-11 08:00:00	IWM	ETF	45.15	45.15	44.57	44.93	90047.0
2009-02-11 09:00:00	IWM	ETF	44.81	45.19	44.72	45.0425	3993277.0
2009-02-11 10:00:00	IWM	ETF	45.03	45.1325	44.46	44.8974	7907327.0
2009-02-11 11:00:00	IWM	ETF	44.89	45.15	44.72	44.88	5107477.0
2009-02-11 12:00:00	IWM	ETF	44.88	45.05	44.73	44.79	3481046.0
2009-02-11 13:00:00	IWM	ETF	44.78	44.91	44.18	44.23	10633214.0
2009-02-11 14:00:00	IWM	ETF	44.23	44.93	44.09	44.8	9167778.0
2009-02-11 15:00:00	IWM	ETF	44.81	45.0	44.47	44.83	9248933.0
2009-02-11 16:00:00	IWM	ETF	44.84	45.022	44.4787	44.89	6264146.0
2009-02-11 17:00:00	IWM	ETF	44.9	44.9	44.88	44.88	3234.0
2009-02-11 18:00:00	IWM	ETF	44.88	44.88	44.88	44.88	3125.0
2009-02-11 19:00:00	IWM	ETF	44.88	44.88	44.76	44.88	3824.0
2009-02-11 06:00:00	DIA	ETF	79.74	79.74	79.74	79.74	100.0
2009-02-11 07:00:00	DIA	ETF	79.44	79.47	79.11	79.17	17775.0
2009-02-11 08:00:00	DIA	ETF	79.16	79.69	79.15	79.57	54853.0
2009-02-11 09:00:00	DIA	ETF	79.53	79.94	79.39	79.69	3128424.0
2009-02-11 10:00:00	DIA	ETF	79.69	79.839	79.0	79.58	5694352.0
2009-02-11 11:00:00	DIA	ETF	79.58	80.01	79.37	79.65	4127195.0
2009-02-11 12:00:00	DIA	ETF	79.65	79.78	79.35	79.43	3329726.0

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

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