PREVIEW / etf_1hour / 2011-11-01

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-01.parquet
  size:    194 KB
  rows:    6,012

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-11-01 04:00:00	SPY	ETF	124.35	124.35	123.19	123.38	102780.0
2011-11-01 05:00:00	SPY	ETF	123.43	123.85	123.41	123.48	71708.0
2011-11-01 06:00:00	SPY	ETF	123.44	123.44	122.85	122.9	595362.0
2011-11-01 07:00:00	SPY	ETF	122.94	123.33	121.87	122.53	1761408.0
2011-11-01 08:00:00	SPY	ETF	122.57	125.5	121.42	121.84	12377671.0
2011-11-01 09:00:00	SPY	ETF	121.82	125.45	121.45	122.65	53428215.0
2011-11-01 10:00:00	SPY	ETF	122.65	123.43	122.05	122.82	60439223.0
2011-11-01 11:00:00	SPY	ETF	122.82	123.13	121.83	121.95	39129240.0
2011-11-01 12:00:00	SPY	ETF	121.95	122.5	121.65	121.79	35923422.0
2011-11-01 13:00:00	SPY	ETF	121.79	123.33	121.64	122.61	61624534.0
2011-11-01 14:00:00	SPY	ETF	122.62	123.51	122.44	122.77	40322687.0
2011-11-01 15:00:00	SPY	ETF	122.77	123.08	121.68	122.01	73397578.0
2011-11-01 16:00:00	SPY	ETF	122.02	125.4496	121.6	122.92	24549552.0
2011-11-01 17:00:00	SPY	ETF	122.95	123.2	122.86	123.02	9559329.0
2011-11-01 18:00:00	SPY	ETF	123.04	123.14	122.08	122.61	795372.0
2011-11-01 19:00:00	SPY	ETF	122.63	122.68	122.21	122.49	879816.0
2011-11-01 04:00:00	QQQ	ETF	57.5	57.5	56.99	57.0	2640.0
2011-11-01 06:00:00	QQQ	ETF	57.04	57.04	56.8	56.82	8757.0
2011-11-01 07:00:00	QQQ	ETF	56.85	57.4	56.6	56.77	1306829.0
2011-11-01 08:00:00	QQQ	ETF	56.79	57.23	56.37	56.54	6001364.0
2011-11-01 09:00:00	QQQ	ETF	56.54	56.74	56.341	56.7	13898751.0
2011-11-01 10:00:00	QQQ	ETF	56.71	56.97	56.5	56.78	14785817.0
2011-11-01 11:00:00	QQQ	ETF	56.79	56.85	56.21	56.31	8686613.0
2011-11-01 12:00:00	QQQ	ETF	56.31	56.55	56.12	56.24	9882286.0
2011-11-01 13:00:00	QQQ	ETF	56.24	56.89	56.14	56.64	14584317.0
2011-11-01 14:00:00	QQQ	ETF	56.65	56.96	56.57	56.72	9799295.0
2011-11-01 15:00:00	QQQ	ETF	56.72	56.83	56.28	56.43	14381532.0
2011-11-01 16:00:00	QQQ	ETF	56.43	56.74	56.42	56.69	2622533.0
2011-11-01 17:00:00	QQQ	ETF	56.69	56.78	56.39	56.71	180572.0
2011-11-01 18:00:00	QQQ	ETF	56.73	56.77	56.54	56.55	68867.0
2011-11-01 19:00:00	QQQ	ETF	56.55	56.56	56.4	56.51	62246.0
2011-11-01 04:00:00	IWM	ETF	72.78	72.78	72.22	72.47	2130.0
2011-11-01 05:00:00	IWM	ETF	72.62	72.62	72.5	72.5	200.0
2011-11-01 06:00:00	IWM	ETF	72.1	72.15	72.0	72.0	43440.0
2011-11-01 07:00:00	IWM	ETF	72.16	72.48	71.7	71.96	251852.0
2011-11-01 08:00:00	IWM	ETF	72.03	72.9	70.78	70.95	2413509.0
2011-11-01 09:00:00	IWM	ETF	70.93	72.15	70.78	72.11	13789918.0
2011-11-01 10:00:00	IWM	ETF	72.08	72.97	71.74	72.5	13395588.0
2011-11-01 11:00:00	IWM	ETF	72.48	72.78	71.5	71.59	9213204.0
2011-11-01 12:00:00	IWM	ETF	71.6	71.9095	71.15	71.18	10265244.0
2011-11-01 13:00:00	IWM	ETF	71.17	72.46	71.06	71.91	13778058.0
2011-11-01 14:00:00	IWM	ETF	71.92	72.59	71.68	71.8	8721373.0
2011-11-01 15:00:00	IWM	ETF	71.79	72.02	71.12	71.48	20944936.0
2011-11-01 16:00:00	IWM	ETF	71.48	72.04	71.2621	72.0	5855953.0
2011-11-01 17:00:00	IWM	ETF	72.0	72.11	71.95	72.04	31385.0
2011-11-01 18:00:00	IWM	ETF	72.03	72.07	71.88	71.88	9801.0
2011-11-01 19:00:00	IWM	ETF	71.86	71.86	71.68	71.85	9163.0
2011-11-01 04:00:00	DIA	ETF	119.0	119.0	118.27	118.27	200.0
2011-11-01 07:00:00	DIA	ETF	117.7	117.79	116.87	117.27	49643.0
2011-11-01 08:00:00	DIA	ETF	117.4	117.47	116.73	117.02	261106.0

> showing 50 of 6,012 rows — these rows as CSV

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