PREVIEW / etf_1hour / 2012-06-04

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-04.parquet
  size:    190 KB
  rows:    5,951

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
2012-06-04 04:00:00	SPY	ETF	127.65	127.65	127.36	127.49	8000.0
2012-06-04 05:00:00	SPY	ETF	127.49	127.75	127.49	127.7	19698.0
2012-06-04 06:00:00	SPY	ETF	127.72	128.31	127.69	128.21	316226.0
2012-06-04 07:00:00	SPY	ETF	128.15	128.43	128.1	128.35	876827.0
2012-06-04 08:00:00	SPY	ETF	128.33	128.44	127.19	128.33	3976753.0
2012-06-04 09:00:00	SPY	ETF	128.33	128.74	127.11	127.97	25187295.0
2012-06-04 10:00:00	SPY	ETF	127.98	128.28	127.55	128.1	36380586.0
2012-06-04 11:00:00	SPY	ETF	128.1	128.15	127.62	127.66	14840703.0
2012-06-04 12:00:00	SPY	ETF	127.66	127.76	127.17	127.35	15934652.0
2012-06-04 13:00:00	SPY	ETF	127.35	127.67	127.135	127.558	18886741.0
2012-06-04 14:00:00	SPY	ETF	127.57	128.51	127.45	128.075	24712360.0
2012-06-04 15:00:00	SPY	ETF	128.075	128.4	127.73	128.17	33250830.0
2012-06-04 16:00:00	SPY	ETF	128.18	128.38	127.68	127.99	16161155.0
2012-06-04 17:00:00	SPY	ETF	127.98	127.99	127.8	127.87	207417.0
2012-06-04 18:00:00	SPY	ETF	127.88	128.06	127.88	128.03	129628.0
2012-06-04 19:00:00	SPY	ETF	128.02	128.15	127.99	128.15	101085.0
2012-06-04 04:00:00	QQQ	ETF	60.2	60.2	60.05	60.09	1380.0
2012-06-04 05:00:00	QQQ	ETF	60.19	60.19	60.19	60.19	600.0
2012-06-04 06:00:00	QQQ	ETF	60.35	60.35	60.34	60.34	800.0
2012-06-04 07:00:00	QQQ	ETF	60.44	60.58	60.44	60.5	2005946.0
2012-06-04 08:00:00	QQQ	ETF	60.49	60.6	60.44	60.52	4500422.0
2012-06-04 09:00:00	QQQ	ETF	60.52	60.96	59.8822	60.36	12846168.0
2012-06-04 10:00:00	QQQ	ETF	60.37	60.69	60.04	60.52	11352987.0
2012-06-04 11:00:00	QQQ	ETF	60.52	60.55	60.22	60.22	3473011.0
2012-06-04 12:00:00	QQQ	ETF	60.22	60.3	60.06	60.19	4019172.0
2012-06-04 13:00:00	QQQ	ETF	60.2	60.36	60.05	60.34	4819633.0
2012-06-04 14:00:00	QQQ	ETF	60.34	60.89	60.2684	60.6401	7977868.0
2012-06-04 15:00:00	QQQ	ETF	60.65	60.91	60.46	60.86	10582557.0
2012-06-04 16:00:00	QQQ	ETF	60.85	60.9428	60.61	60.76	2074742.0
2012-06-04 17:00:00	QQQ	ETF	60.76	60.77	60.72	60.76	6167.0
2012-06-04 18:00:00	QQQ	ETF	60.74	60.8	60.74	60.8	16833.0
2012-06-04 19:00:00	QQQ	ETF	60.8	60.84	60.8	60.83	139501.0
2012-06-04 04:00:00	IWM	ETF	73.36	73.36	73.28	73.28	922.0
2012-06-04 06:00:00	IWM	ETF	73.62	73.89	73.62	73.89	3000.0
2012-06-04 07:00:00	IWM	ETF	73.89	74.11	73.7	74.08	250806.0
2012-06-04 08:00:00	IWM	ETF	74.07	74.1	73.87	74.04	225688.0
2012-06-04 09:00:00	IWM	ETF	74.05	74.35	73.535	73.6799	5549480.0
2012-06-04 10:00:00	IWM	ETF	73.69	74.15	73.35	73.94	10939137.0
2012-06-04 11:00:00	IWM	ETF	73.95	74.0099	73.39	73.39	3303087.0
2012-06-04 12:00:00	IWM	ETF	73.39	73.49	73.06	73.17	3926291.0
2012-06-04 13:00:00	IWM	ETF	73.16	73.32	72.94	73.21	4692618.0
2012-06-04 14:00:00	IWM	ETF	73.22	73.88	73.11	73.47	7166386.0
2012-06-04 15:00:00	IWM	ETF	73.47	73.8001	73.3	73.68	7689077.0
2012-06-04 16:00:00	IWM	ETF	73.67	74.0922	73.37	73.46	2932403.0
2012-06-04 17:00:00	IWM	ETF	73.42	73.42	73.36	73.41	89733.0
2012-06-04 18:00:00	IWM	ETF	73.43	73.49	73.43	73.49	8700.0
2012-06-04 19:00:00	IWM	ETF	73.43	73.55	73.43	73.46	1200.0
2012-06-04 04:00:00	DIA	ETF	120.26	120.26	120.26	120.26	200.0
2012-06-04 06:00:00	DIA	ETF	120.9	120.9	120.9	120.9	100.0
2012-06-04 07:00:00	DIA	ETF	120.81	121.05	120.81	121.01	2400.0

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

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