PREVIEW / etf_1hour / 2011-10-31

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-31.parquet
  size:    187 KB
  rows:    5,752

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-31 04:00:00	SPY	ETF	128.1	128.1	127.4	127.46	14853.0
2011-10-31 05:00:00	SPY	ETF	127.4	127.48	127.21	127.3	34258.0
2011-10-31 06:00:00	SPY	ETF	127.39	127.56	127.3	127.53	104590.0
2011-10-31 07:00:00	SPY	ETF	127.55	127.61	127.14	127.37	1011690.0
2011-10-31 08:00:00	SPY	ETF	127.38	127.45	126.98	127.1	1437452.0
2011-10-31 09:00:00	SPY	ETF	127.1	127.32	126.7	126.87	31077765.0
2011-10-31 10:00:00	SPY	ETF	126.85	127.26	126.72	126.98	24788596.0
2011-10-31 11:00:00	SPY	ETF	126.99	127.2	126.69	126.9	20742487.0
2011-10-31 12:00:00	SPY	ETF	126.91	127.02	126.42	126.679	19610446.0
2011-10-31 13:00:00	SPY	ETF	126.67	128.6239	126.62	127.1	18377825.0
2011-10-31 14:00:00	SPY	ETF	127.1	127.15	126.66	126.901	18634170.0
2011-10-31 15:00:00	SPY	ETF	126.9	126.91	125.36	125.37	65105750.0
2011-10-31 16:00:00	SPY	ETF	125.37	128.6239	124.77	124.84	22100590.0
2011-10-31 17:00:00	SPY	ETF	124.84	125.465	124.68	124.74	769659.0
2011-10-31 18:00:00	SPY	ETF	124.75	125.45	124.74	124.9	451148.0
2011-10-31 19:00:00	SPY	ETF	124.87	125.04	124.82	124.87	231261.0
2011-10-31 05:00:00	QQQ	ETF	58.38	58.38	58.38	58.38	500.0
2011-10-31 06:00:00	QQQ	ETF	58.45	58.48	58.4	58.48	700.0
2011-10-31 07:00:00	QQQ	ETF	58.56	58.56	58.33	58.38	100078.0
2011-10-31 08:00:00	QQQ	ETF	58.41	58.45	58.29	58.33	376349.0
2011-10-31 09:00:00	QQQ	ETF	58.33	58.44	58.11	58.24	5053231.0
2011-10-31 10:00:00	QQQ	ETF	58.24	58.64	58.17	58.42	7344087.0
2011-10-31 11:00:00	QQQ	ETF	58.43	58.52	58.28	58.38	6208300.0
2011-10-31 12:00:00	QQQ	ETF	58.36	58.38	58.14	58.28	5964422.0
2011-10-31 13:00:00	QQQ	ETF	58.28	58.54	58.26	58.495	3778569.0
2011-10-31 14:00:00	QQQ	ETF	58.49	58.51	58.24	58.39	4506983.0
2011-10-31 15:00:00	QQQ	ETF	58.39	58.399	57.91	57.92	14276693.0
2011-10-31 16:00:00	QQQ	ETF	57.91	58.02	57.69	57.7	3562117.0
2011-10-31 17:00:00	QQQ	ETF	57.69	58.9167	57.64	57.66	318717.0
2011-10-31 18:00:00	QQQ	ETF	57.66	57.73	57.65	57.71	41448.0
2011-10-31 19:00:00	QQQ	ETF	57.72	57.76	57.68	57.7	29202.0
2011-10-31 04:00:00	IWM	ETF	75.5	75.5	75.0	75.0	5549.0
2011-10-31 05:00:00	IWM	ETF	74.91	74.91	74.88	74.9	600.0
2011-10-31 06:00:00	IWM	ETF	75.08	75.08	75.08	75.08	1000.0
2011-10-31 07:00:00	IWM	ETF	75.06	75.06	74.78	74.88	19750.0
2011-10-31 08:00:00	IWM	ETF	74.93	74.96	74.56	74.71	402193.0
2011-10-31 09:00:00	IWM	ETF	74.72	74.93	74.25	74.46	10961899.0
2011-10-31 10:00:00	IWM	ETF	74.45	74.99	74.35	74.88	7841289.0
2011-10-31 11:00:00	IWM	ETF	74.88	75.15	74.75	74.89	6184841.0
2011-10-31 12:00:00	IWM	ETF	74.89	75.0	74.55	74.83	5379754.0
2011-10-31 13:00:00	IWM	ETF	74.83	75.44	74.8	75.35	6297705.0
2011-10-31 14:00:00	IWM	ETF	75.33	75.4	75.02	75.23	4298006.0
2011-10-31 15:00:00	IWM	ETF	75.22	75.22	73.97	73.99	16418763.0
2011-10-31 16:00:00	IWM	ETF	73.97	74.1667	73.39	73.4	1761728.0
2011-10-31 17:00:00	IWM	ETF	73.43	73.52	73.4	73.52	32980.0
2011-10-31 18:00:00	IWM	ETF	73.62	73.63	73.47	73.61	9800.0
2011-10-31 19:00:00	IWM	ETF	73.62	73.7	73.62	73.62	15900.0
2011-10-31 04:00:00	DIA	ETF	121.15	121.15	121.03	121.03	6500.0
2011-10-31 05:00:00	DIA	ETF	121.01	121.01	120.92	120.92	6700.0
2011-10-31 06:00:00	DIA	ETF	121.15	121.15	121.15	121.15	7500.0

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

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