PREVIEW / etf_1hour / 2009-12-02

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-02.parquet
  size:    146 KB
  rows:    4,544

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-12-02 04:00:00	SPY	ETF	111.22	111.34	111.18	111.34	339.0
2009-12-02 05:00:00	SPY	ETF	111.38	111.42	111.23	111.35	2700.0
2009-12-02 06:00:00	SPY	ETF	111.23	111.23	111.08	111.21	1400.0
2009-12-02 07:00:00	SPY	ETF	111.2	111.4	111.15	111.38	1634354.0
2009-12-02 08:00:00	SPY	ETF	111.35	111.57	111.16	111.21	4304312.0
2009-12-02 09:00:00	SPY	ETF	111.22	111.58	111.16	111.43	16369478.0
2009-12-02 10:00:00	SPY	ETF	111.42	112.01	111.42	111.75	25250211.0
2009-12-02 11:00:00	SPY	ETF	111.745	111.75	111.22	111.38	16957543.0
2009-12-02 12:00:00	SPY	ETF	111.37	111.44	110.92	111.19	11597875.0
2009-12-02 13:00:00	SPY	ETF	111.19	111.4	111.09	111.24	8011027.0
2009-12-02 14:00:00	SPY	ETF	111.24	111.37	110.99	111.185	18034588.0
2009-12-02 15:00:00	SPY	ETF	111.19	111.46	111.09	111.31	19806737.0
2009-12-02 16:00:00	SPY	ETF	111.3	111.88	111.1	111.27	4849183.0
2009-12-02 17:00:00	SPY	ETF	111.27	111.5	111.11	111.46	804319.0
2009-12-02 18:00:00	SPY	ETF	111.44	111.65	111.37	111.56	316064.0
2009-12-02 19:00:00	SPY	ETF	111.55	111.58	111.41	111.56	155531.0
2009-12-02 06:00:00	QQQ	ETF	44.03	44.03	44.03	44.03	300.0
2009-12-02 07:00:00	QQQ	ETF	44.08	44.16	44.04	44.1	1144622.0
2009-12-02 08:00:00	QQQ	ETF	44.08	44.17	44.07	44.08	4743879.0
2009-12-02 09:00:00	QQQ	ETF	44.09	44.31	44.08	44.25	11525875.0
2009-12-02 10:00:00	QQQ	ETF	44.25	44.49	44.15	44.421	16592541.0
2009-12-02 11:00:00	QQQ	ETF	44.42	44.44	44.2	44.21	8420793.0
2009-12-02 12:00:00	QQQ	ETF	44.22	44.25	44.01	44.13	5779348.0
2009-12-02 13:00:00	QQQ	ETF	44.1299	44.16	44.03	44.1299	4772472.0
2009-12-02 14:00:00	QQQ	ETF	44.129	44.19	43.98	44.1	12119938.0
2009-12-02 15:00:00	QQQ	ETF	44.1	44.15	44.0201	44.08	11482340.0
2009-12-02 16:00:00	QQQ	ETF	44.08	44.13	44.07	44.13	2178999.0
2009-12-02 17:00:00	QQQ	ETF	44.13	44.2	44.07	44.19	244964.0
2009-12-02 18:00:00	QQQ	ETF	44.17	44.26	44.1	44.24	106531.0
2009-12-02 19:00:00	QQQ	ETF	44.24	44.25	44.16	44.21	42170.0
2009-12-02 06:00:00	IWM	ETF	58.9	58.9	58.9	58.9	100.0
2009-12-02 07:00:00	IWM	ETF	59.02	59.1	59.02	59.05	3107.0
2009-12-02 08:00:00	IWM	ETF	59.17	59.22	59.0	59.04	632473.0
2009-12-02 09:00:00	IWM	ETF	59.05	59.67	59.0	59.51	9996836.0
2009-12-02 10:00:00	IWM	ETF	59.5	60.21	59.5	60.0	17465255.0
2009-12-02 11:00:00	IWM	ETF	60.0	60.01	59.61	59.69	8364124.0
2009-12-02 12:00:00	IWM	ETF	59.69	59.74	59.3	59.55	6133451.0
2009-12-02 13:00:00	IWM	ETF	59.54	59.72	59.47	59.71	3202693.0
2009-12-02 14:00:00	IWM	ETF	59.71	59.79	59.37	59.63	8651261.0
2009-12-02 15:00:00	IWM	ETF	59.63	59.8	59.47	59.67	7722637.0
2009-12-02 16:00:00	IWM	ETF	59.68	59.78	59.66	59.77	1090606.0
2009-12-02 17:00:00	IWM	ETF	59.76	59.86	59.63	59.86	73079.0
2009-12-02 18:00:00	IWM	ETF	59.87	59.9	59.83	59.87	18076.0
2009-12-02 19:00:00	IWM	ETF	59.88	59.9	59.88	59.9	2000.0
2009-12-02 07:00:00	DIA	ETF	104.75	104.75	104.75	104.75	1000.0
2009-12-02 08:00:00	DIA	ETF	104.7	105.0	104.33	104.75	103670.0
2009-12-02 09:00:00	DIA	ETF	104.74	104.98	104.66	104.85	1028228.0
2009-12-02 10:00:00	DIA	ETF	104.84	105.25	104.84	105.03	1440756.0
2009-12-02 11:00:00	DIA	ETF	105.03	105.03	104.61	104.709	1147536.0
2009-12-02 12:00:00	DIA	ETF	104.71	104.75	104.32	104.5	657669.0

> showing 50 of 4,544 rows — these rows as CSV

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