PREVIEW / etf_1hour / 2011-10-21

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-21.parquet
  size:    181 KB
  rows:    5,570

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-10-21 04:00:00	SPY	ETF	121.85	121.89	121.65	121.81	44100.0
2011-10-21 05:00:00	SPY	ETF	121.86	122.11	121.75	121.87	76150.0
2011-10-21 06:00:00	SPY	ETF	121.91	122.1	121.88	122.1	15900.0
2011-10-21 07:00:00	SPY	ETF	122.12	122.91	122.07	122.7	1383695.0
2011-10-21 08:00:00	SPY	ETF	122.7	123.0	121.83	122.77	2036958.0
2011-10-21 09:00:00	SPY	ETF	122.79	123.53	121.96	123.38	29444042.0
2011-10-21 10:00:00	SPY	ETF	123.37	124.12	123.18	123.78	45567101.0
2011-10-21 11:00:00	SPY	ETF	123.77	123.88	123.39	123.72	25043509.0
2011-10-21 12:00:00	SPY	ETF	123.7128	123.74	123.29	123.3	13851553.0
2011-10-21 13:00:00	SPY	ETF	123.29	123.2999	122.72	122.79	28794190.0
2011-10-21 14:00:00	SPY	ETF	122.8	123.51	122.72	123.506	27544548.0
2011-10-21 15:00:00	SPY	ETF	123.5	123.97	123.24	123.95	58609318.0
2011-10-21 16:00:00	SPY	ETF	123.945	124.11	121.6547	124.01	41748733.0
2011-10-21 17:00:00	SPY	ETF	124.03	124.18	123.9825	124.1	742360.0
2011-10-21 18:00:00	SPY	ETF	124.09	124.12	123.91	124.1	355611.0
2011-10-21 19:00:00	SPY	ETF	124.11	124.24	124.07	124.2	93286.0
2011-10-21 04:00:00	QQQ	ETF	56.86	56.86	56.86	56.86	113.0
2011-10-21 05:00:00	QQQ	ETF	56.68	56.77	56.68	56.77	600.0
2011-10-21 06:00:00	QQQ	ETF	56.78	56.84	56.78	56.84	2600.0
2011-10-21 07:00:00	QQQ	ETF	56.85	57.19	56.84	57.07	113298.0
2011-10-21 08:00:00	QQQ	ETF	57.1	57.16	56.97	57.1	408500.0
2011-10-21 09:00:00	QQQ	ETF	57.11	57.47	57.07	57.32	9772782.0
2011-10-21 10:00:00	QQQ	ETF	57.32	57.66	57.26	57.45	9040670.0
2011-10-21 11:00:00	QQQ	ETF	57.45	57.47	57.34	57.36	4214026.0
2011-10-21 12:00:00	QQQ	ETF	57.37	57.37	57.11	57.11	3847038.0
2011-10-21 13:00:00	QQQ	ETF	57.11	57.115	56.78	56.87	8200686.0
2011-10-21 14:00:00	QQQ	ETF	56.87	57.14	56.84	57.1301	7842253.0
2011-10-21 15:00:00	QQQ	ETF	57.14	57.314	56.98	57.31	7365316.0
2011-10-21 16:00:00	QQQ	ETF	57.3	57.43	57.2214	57.31	2242271.0
2011-10-21 17:00:00	QQQ	ETF	57.3	57.39	57.27	57.34	40396.0
2011-10-21 18:00:00	QQQ	ETF	57.33	57.38	57.3	57.35	9277.0
2011-10-21 19:00:00	QQQ	ETF	57.33	57.38	57.33	57.38	19998.0
2011-10-21 04:00:00	IWM	ETF	69.43	69.43	69.43	69.43	400.0
2011-10-21 05:00:00	IWM	ETF	69.69	69.69	69.69	69.69	200.0
2011-10-21 06:00:00	IWM	ETF	69.58	69.7	69.58	69.7	360.0
2011-10-21 07:00:00	IWM	ETF	69.89	70.25	69.82	70.13	240200.0
2011-10-21 08:00:00	IWM	ETF	70.13	70.33	70.12	70.26	370597.0
2011-10-21 09:00:00	IWM	ETF	70.26	70.7571	70.25	70.61	6390115.0
2011-10-21 10:00:00	IWM	ETF	70.61	71.1	70.47	70.91	10900193.0
2011-10-21 11:00:00	IWM	ETF	70.91	71.09	70.72	70.91	4301449.0
2011-10-21 12:00:00	IWM	ETF	70.91	70.93	70.61	70.61	3290376.0
2011-10-21 13:00:00	IWM	ETF	70.6	70.6	70.02	70.11	6152390.0
2011-10-21 14:00:00	IWM	ETF	70.12	70.72	70.05	70.71	7447235.0
2011-10-21 15:00:00	IWM	ETF	70.72	71.16	70.51	71.09	14015015.0
2011-10-21 16:00:00	IWM	ETF	71.1	71.29	70.25	71.22	5849807.0
2011-10-21 17:00:00	IWM	ETF	71.21	71.29	71.18	71.26	12612.0
2011-10-21 18:00:00	IWM	ETF	71.32	71.32	71.23	71.25	5000.0
2011-10-21 19:00:00	IWM	ETF	71.25	71.3	71.22	71.3	3800.0
2011-10-21 06:00:00	DIA	ETF	115.4	115.48	115.4	115.42	25000.0
2011-10-21 07:00:00	DIA	ETF	115.54	116.06	115.54	116.06	3760.0

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

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