PREVIEW / etf_1hour / 2011-12-23

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-23.parquet
  size:    173 KB
  rows:    5,413

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
2011-12-23 04:00:00	SPY	ETF	125.7	125.77	125.65	125.77	55350.0
2011-12-23 05:00:00	SPY	ETF	125.85	125.85	125.76	125.82	2270.0
2011-12-23 06:00:00	SPY	ETF	125.82	125.97	125.82	125.89	52931.0
2011-12-23 07:00:00	SPY	ETF	125.89	126.07	125.89	126.0	247730.0
2011-12-23 08:00:00	SPY	ETF	125.99	126.13	125.7	125.78	1684810.0
2011-12-23 09:00:00	SPY	ETF	125.78	125.9	125.41	125.66	13621495.0
2011-12-23 10:00:00	SPY	ETF	125.66	125.8	125.55	125.73	13315411.0
2011-12-23 11:00:00	SPY	ETF	125.72	126.06	125.71	126.04	9117418.0
2011-12-23 12:00:00	SPY	ETF	126.05	126.25	125.97	126.1899	5563080.0
2011-12-23 13:00:00	SPY	ETF	126.19	126.2	126.02	126.1	5090511.0
2011-12-23 14:00:00	SPY	ETF	126.11	126.11	126.01	126.05	6914994.0
2011-12-23 15:00:00	SPY	ETF	126.05	126.43	125.98	126.38	22349099.0
2011-12-23 16:00:00	SPY	ETF	126.38	126.56	125.2588	126.51	12583803.0
2011-12-23 17:00:00	SPY	ETF	126.51	126.63	126.48	126.6	135963.0
2011-12-23 18:00:00	SPY	ETF	126.61	126.62	126.39	126.6	356403.0
2011-12-23 19:00:00	SPY	ETF	126.59	126.62	126.57	126.59	30676.0
2011-12-23 04:00:00	QQQ	ETF	55.7	55.7	55.69	55.69	12100.0
2011-12-23 05:00:00	QQQ	ETF	55.69	55.7	55.69	55.7	4600.0
2011-12-23 07:00:00	QQQ	ETF	55.78	55.79	55.74	55.79	10900.0
2011-12-23 08:00:00	QQQ	ETF	55.78	55.86	55.68	55.69	303539.0
2011-12-23 09:00:00	QQQ	ETF	55.7	55.8	55.655	55.771	2794175.0
2011-12-23 10:00:00	QQQ	ETF	55.78	55.81	55.581	55.6999	2778561.0
2011-12-23 11:00:00	QQQ	ETF	55.698	55.88	55.68	55.88	3590269.0
2011-12-23 12:00:00	QQQ	ETF	55.87	56.01	55.85	56.0	2601316.0
2011-12-23 13:00:00	QQQ	ETF	56.01	56.01	55.92	55.995	1906616.0
2011-12-23 14:00:00	QQQ	ETF	55.995	56.0	55.91	55.93	1605969.0
2011-12-23 15:00:00	QQQ	ETF	55.93	56.08	55.89	56.07	5621576.0
2011-12-23 16:00:00	QQQ	ETF	56.07	56.08	56.0	56.06	1071158.0
2011-12-23 17:00:00	QQQ	ETF	56.06	56.08	56.04	56.08	13100.0
2011-12-23 18:00:00	QQQ	ETF	56.08	56.1	56.05	56.07	7650.0
2011-12-23 19:00:00	QQQ	ETF	56.08	56.08	56.05	56.06	5621.0
2011-12-23 05:00:00	IWM	ETF	74.67	74.67	74.67	74.67	200.0
2011-12-23 06:00:00	IWM	ETF	74.73	74.73	74.73	74.73	100.0
2011-12-23 07:00:00	IWM	ETF	74.75	74.85	74.72	74.74	1500.0
2011-12-23 08:00:00	IWM	ETF	74.76	74.82	74.51	74.54	156347.0
2011-12-23 09:00:00	IWM	ETF	74.54	74.61	74.225	74.42	2271665.0
2011-12-23 10:00:00	IWM	ETF	74.42	74.47	74.0799	74.27	2507417.0
2011-12-23 11:00:00	IWM	ETF	74.27	74.55	74.21	74.549	2255290.0
2011-12-23 12:00:00	IWM	ETF	74.54	74.68	74.49	74.6102	3017514.0
2011-12-23 13:00:00	IWM	ETF	74.62	74.62	74.45	74.54	1279981.0
2011-12-23 14:00:00	IWM	ETF	74.544	74.56	74.46	74.5	1166954.0
2011-12-23 15:00:00	IWM	ETF	74.5	74.56	74.41	74.54	3596991.0
2011-12-23 16:00:00	IWM	ETF	74.55	74.58	74.37	74.58	3233636.0
2011-12-23 17:00:00	IWM	ETF	74.57	74.59	74.55	74.57	11341.0
2011-12-23 18:00:00	IWM	ETF	74.55	74.59	74.54	74.54	2050.0
2011-12-23 19:00:00	IWM	ETF	74.58	74.58	74.5	74.5	3280.0
2011-12-23 04:00:00	DIA	ETF	121.65	121.65	121.65	121.65	100.0
2011-12-23 05:00:00	DIA	ETF	121.85	121.85	121.85	121.85	100.0
2011-12-23 07:00:00	DIA	ETF	122.02	122.02	122.0	122.0	650.0
2011-12-23 08:00:00	DIA	ETF	122.0	122.04	121.75	121.75	7430.0

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

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