PREVIEW / etf_1hour / 2010-12-03

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-03.parquet
  size:    174 KB
  rows:    5,321

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
2010-12-03 04:00:00	SPY	ETF	122.61	122.81	122.6	122.81	700.0
2010-12-03 05:00:00	SPY	ETF	122.85	122.85	122.81	122.84	4900.0
2010-12-03 06:00:00	SPY	ETF	122.71	122.8	122.64	122.8	9510.0
2010-12-03 07:00:00	SPY	ETF	122.84	122.9	122.67	122.9	416641.0
2010-12-03 08:00:00	SPY	ETF	122.9	123.21	121.79	121.91	16480940.0
2010-12-03 09:00:00	SPY	ETF	121.91	122.53	121.91	122.35	29323819.0
2010-12-03 10:00:00	SPY	ETF	122.35	122.63	122.13	122.46	25931206.0
2010-12-03 11:00:00	SPY	ETF	122.46	122.52	122.11	122.1899	12495332.0
2010-12-03 12:00:00	SPY	ETF	122.18	122.37	122.17	122.34	6745814.0
2010-12-03 13:00:00	SPY	ETF	122.33	122.47	122.28	122.44	6156781.0
2010-12-03 14:00:00	SPY	ETF	122.435	122.59	122.3	122.59	9124299.0
2010-12-03 15:00:00	SPY	ETF	122.59	123.03	122.47	122.86	34090872.0
2010-12-03 16:00:00	SPY	ETF	122.86	123.05	122.315	123.03	9587104.0
2010-12-03 17:00:00	SPY	ETF	123.03	123.05	122.95	123.0	319562.0
2010-12-03 18:00:00	SPY	ETF	123.02	123.04	122.97	122.97	51758.0
2010-12-03 19:00:00	SPY	ETF	122.99	123.06	122.99	123.01	18771.0
2010-12-03 04:00:00	QQQ	ETF	53.74	53.74	53.74	53.74	100.0
2010-12-03 06:00:00	QQQ	ETF	53.85	53.85	53.85	53.85	5500.0
2010-12-03 07:00:00	QQQ	ETF	53.85	53.88	53.79	53.87	39902.0
2010-12-03 08:00:00	QQQ	ETF	53.86	53.97	53.32	53.38	3679452.0
2010-12-03 09:00:00	QQQ	ETF	53.39	53.81	53.39	53.73	8211198.0
2010-12-03 10:00:00	QQQ	ETF	53.73	53.87	53.63	53.8	8343581.0
2010-12-03 11:00:00	QQQ	ETF	53.8	53.82	53.63	53.651	2854545.0
2010-12-03 12:00:00	QQQ	ETF	53.66	53.74	53.65	53.73	1299950.0
2010-12-03 13:00:00	QQQ	ETF	53.73	53.78	53.68	53.77	1820223.0
2010-12-03 14:00:00	QQQ	ETF	53.77	53.8	53.6901	53.79	1617942.0
2010-12-03 15:00:00	QQQ	ETF	53.79	53.94	53.724	53.86	6786563.0
2010-12-03 16:00:00	QQQ	ETF	53.87	53.89	53.77	53.88	1838986.0
2010-12-03 17:00:00	QQQ	ETF	53.88	53.89	53.88	53.89	11820.0
2010-12-03 18:00:00	QQQ	ETF	53.89	53.9	53.88	53.88	31180.0
2010-12-03 19:00:00	QQQ	ETF	53.88	53.9	53.88	53.88	8000.0
2010-12-03 06:00:00	IWM	ETF	75.38	75.39	75.36	75.39	7900.0
2010-12-03 07:00:00	IWM	ETF	75.36	75.45	75.29	75.45	22850.0
2010-12-03 08:00:00	IWM	ETF	75.45	75.64	74.58	74.65	2507896.0
2010-12-03 09:00:00	IWM	ETF	74.65	75.23	74.65	75.13	4385073.0
2010-12-03 10:00:00	IWM	ETF	75.13	75.34	74.85	75.12	5460300.0
2010-12-03 11:00:00	IWM	ETF	75.12	75.19	74.86	75.06	2075572.0
2010-12-03 12:00:00	IWM	ETF	75.06	75.37	75.04	75.35	4000469.0
2010-12-03 13:00:00	IWM	ETF	75.35	75.53	75.33	75.49	2785045.0
2010-12-03 14:00:00	IWM	ETF	75.5	75.59	75.43	75.59	1631735.0
2010-12-03 15:00:00	IWM	ETF	75.59	75.9	75.56	75.65	8428334.0
2010-12-03 16:00:00	IWM	ETF	75.65	75.8602	75.2212	75.7	2160198.0
2010-12-03 17:00:00	IWM	ETF	75.69	75.75	75.69	75.75	2000.0
2010-12-03 19:00:00	IWM	ETF	75.74	75.76	75.69	75.69	1300.0
2010-12-03 04:00:00	DIA	ETF	113.72	113.87	113.72	113.87	300.0
2010-12-03 06:00:00	DIA	ETF	113.83	113.89	113.83	113.88	538.0
2010-12-03 07:00:00	DIA	ETF	113.91	113.93	113.84	113.92	3975.0
2010-12-03 08:00:00	DIA	ETF	113.99	114.2	113.11	113.22	74562.0
2010-12-03 09:00:00	DIA	ETF	113.22	113.7096	113.22	113.58	670891.0
2010-12-03 10:00:00	DIA	ETF	113.58	113.81	113.45	113.7	804095.0

> showing 50 of 5,321 rows — these rows as CSV

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