PREVIEW / etf_1hour / 2011-08-19

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-19.parquet
  size:    190 KB
  rows:    5,859

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-08-19 04:00:00	SPY	ETF	113.2	113.26	112.74	113.16	12604.0
2011-08-19 05:00:00	SPY	ETF	113.28	113.47	112.83	112.91	74855.0
2011-08-19 06:00:00	SPY	ETF	112.81	113.17	112.47	112.95	225981.0
2011-08-19 07:00:00	SPY	ETF	113.01	113.65	112.67	113.58	2566768.0
2011-08-19 08:00:00	SPY	ETF	113.58	114.21	113.045	113.27	6441475.0
2011-08-19 09:00:00	SPY	ETF	113.27	114.44	112.77	114.3116	57643441.0
2011-08-19 10:00:00	SPY	ETF	114.31	115.88	114.19	114.85	69365998.0
2011-08-19 11:00:00	SPY	ETF	114.85	115.0	113.75	114.64	49609616.0
2011-08-19 12:00:00	SPY	ETF	114.64	114.7	114.0	114.29	32031435.0
2011-08-19 13:00:00	SPY	ETF	114.29	114.56	113.64	113.85	28462042.0
2011-08-19 14:00:00	SPY	ETF	113.85	114.02	112.87	113.06	54640921.0
2011-08-19 15:00:00	SPY	ETF	113.06	113.36	112.5	112.71	79672257.0
2011-08-19 16:00:00	SPY	ETF	112.71	115.4	112.63	112.68	41835615.0
2011-08-19 17:00:00	SPY	ETF	112.68	112.77	112.55	112.73	3082609.0
2011-08-19 18:00:00	SPY	ETF	112.73	113.07	112.68	113.02	519152.0
2011-08-19 19:00:00	SPY	ETF	113.01	113.01	112.81	112.93	154880.0
2011-08-19 04:00:00	QQQ	ETF	50.38	50.54	50.21	50.31	6195.0
2011-08-19 05:00:00	QQQ	ETF	50.55	50.55	50.37	50.38	1100.0
2011-08-19 06:00:00	QQQ	ETF	50.42	50.49	50.11	50.33	18900.0
2011-08-19 07:00:00	QQQ	ETF	50.32	50.85	50.19	50.8	312378.0
2011-08-19 08:00:00	QQQ	ETF	50.79	51.01	50.39	50.58	2927254.0
2011-08-19 09:00:00	QQQ	ETF	50.57	51.16	50.4	51.09	12478690.0
2011-08-19 10:00:00	QQQ	ETF	51.09	51.67	50.994	51.24	18411480.0
2011-08-19 11:00:00	QQQ	ETF	51.24	51.33	50.77	51.17	9945163.0
2011-08-19 12:00:00	QQQ	ETF	51.16	51.2	50.89	50.98	6937329.0
2011-08-19 13:00:00	QQQ	ETF	50.977	51.07	50.59	50.68	7014827.0
2011-08-19 14:00:00	QQQ	ETF	50.68	50.745	50.22	50.27	12844886.0
2011-08-19 15:00:00	QQQ	ETF	50.28	50.35	49.99	50.05	20054011.0
2011-08-19 16:00:00	QQQ	ETF	50.05	50.25	50.03	50.15	2178142.0
2011-08-19 17:00:00	QQQ	ETF	50.11	50.19	50.05	50.19	89290.0
2011-08-19 18:00:00	QQQ	ETF	50.21	50.23	50.15	50.21	10383.0
2011-08-19 19:00:00	QQQ	ETF	50.19	50.27	50.15	50.23	15236.0
2011-08-19 04:00:00	IWM	ETF	65.82	65.82	65.12	65.39	16517.0
2011-08-19 05:00:00	IWM	ETF	65.72	65.72	65.13	65.13	2936.0
2011-08-19 06:00:00	IWM	ETF	65.17	65.2	65.17	65.2	636.0
2011-08-19 07:00:00	IWM	ETF	65.48	65.77	65.05	65.77	148356.0
2011-08-19 08:00:00	IWM	ETF	65.69	66.23	65.24	65.24	814712.0
2011-08-19 09:00:00	IWM	ETF	65.26	66.85	64.87	66.57	20223183.0
2011-08-19 10:00:00	IWM	ETF	66.57	67.41	66.4	66.67	17997945.0
2011-08-19 11:00:00	IWM	ETF	66.67	66.82	66.14	66.78	8913509.0
2011-08-19 12:00:00	IWM	ETF	66.78	66.86	66.37	66.45	4195073.0
2011-08-19 13:00:00	IWM	ETF	66.45	66.66	65.91	66.03	6684385.0
2011-08-19 14:00:00	IWM	ETF	66.03	66.16	65.23	65.33	9772078.0
2011-08-19 15:00:00	IWM	ETF	65.33	65.6	64.99	65.25	15745109.0
2011-08-19 16:00:00	IWM	ETF	65.24	65.66	65.1731	65.49	3239771.0
2011-08-19 17:00:00	IWM	ETF	65.49	65.49	65.24	65.41	918521.0
2011-08-19 18:00:00	IWM	ETF	65.52	65.65	65.52	65.65	3300.0
2011-08-19 19:00:00	IWM	ETF	65.5	65.59	65.5	65.59	800.0
2011-08-19 04:00:00	DIA	ETF	109.02	109.02	108.53	108.53	610.0
2011-08-19 05:00:00	DIA	ETF	108.66	108.66	108.42	108.42	1000.0

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

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