PREVIEW / stock_1hour / 2011-02-18

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-02-18.parquet
  size:    948 KB
  rows:    44,518
  symbols: 3,539

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-02-18 04:00:00	AAPL	Stock	12.675	12.6918	12.6357	12.6786	143640.0
2011-02-18 05:00:00	AAPL	Stock	12.6829	12.6829	12.6357	12.6714	127960.0
2011-02-18 06:00:00	AAPL	Stock	12.6696	12.7086	12.6461	12.6964	88900.0
2011-02-18 07:00:00	AAPL	Stock	12.7061	12.7936	12.7061	12.7861	1030876.0
2011-02-18 08:00:00	AAPL	Stock	12.7861	12.8464	12.7829	12.8432	3461976.0
2011-02-18 09:00:00	AAPL	Stock	12.8461	12.8536	12.7554	12.77	64748656.0
2011-02-18 10:00:00	AAPL	Stock	12.77	12.7818	12.6232	12.6232	130320148.0
2011-02-18 11:00:00	AAPL	Stock	12.6234	12.6871	12.5818	12.6575	133256144.0
2011-02-18 12:00:00	AAPL	Stock	12.6564	12.6732	12.6129	12.6293	46623332.0
2011-02-18 13:00:00	AAPL	Stock	12.6286	12.6296	12.525	12.5807	106397060.0
2011-02-18 14:00:00	AAPL	Stock	12.5793	12.5814	12.4889	12.5336	117267416.0
2011-02-18 15:00:00	AAPL	Stock	12.5336	12.5377	12.4829	12.52	144503996.0
2011-02-18 16:00:00	AAPL	Stock	12.5175	12.7876	12.5004	12.5039	17115672.0
2011-02-18 17:00:00	AAPL	Stock	12.5036	12.5071	12.4839	12.4893	1074052.0
2011-02-18 18:00:00	AAPL	Stock	12.4839	12.52	12.4296	12.4739	1640912.0
2011-02-18 19:00:00	AAPL	Stock	12.4714	12.4732	12.4639	12.4704	636552.0
2011-02-18 07:00:00	MSFT	Stock	27.28	27.29	27.27	27.27	1300.0
2011-02-18 08:00:00	MSFT	Stock	27.25	27.25	27.21	27.25	3556.0
2011-02-18 09:00:00	MSFT	Stock	27.24	27.24	27.01	27.07	16335462.0
2011-02-18 10:00:00	MSFT	Stock	27.065	27.14	27.03	27.11	8897859.0
2011-02-18 11:00:00	MSFT	Stock	27.11	27.2	27.08	27.121	6768560.0
2011-02-18 12:00:00	MSFT	Stock	27.12	27.13	26.99	27.03	6675136.0
2011-02-18 13:00:00	MSFT	Stock	27.04	27.09	26.99	27.07	6868861.0
2011-02-18 14:00:00	MSFT	Stock	27.065	27.09	27.02	27.07	6074193.0
2011-02-18 15:00:00	MSFT	Stock	27.07	27.11	26.99	27.1	13865782.0
2011-02-18 16:00:00	MSFT	Stock	27.09	27.12	27.012	27.05	900925.0
2011-02-18 17:00:00	MSFT	Stock	27.06	27.07	27.05	27.07	5130.0
2011-02-18 18:00:00	MSFT	Stock	27.06	27.07	27.05	27.05	45550.0
2011-02-18 19:00:00	MSFT	Stock	27.06	27.06	27.05	27.05	3640.0
2011-02-18 05:00:00	NVDA	Stock	0.639	0.639	0.6313	0.6315	41600.0
2011-02-18 06:00:00	NVDA	Stock	0.6315	0.6315	0.6315	0.6315	8000.0
2011-02-18 07:00:00	NVDA	Stock	0.6335	0.635	0.6335	0.635	48000.0
2011-02-18 08:00:00	NVDA	Stock	0.6375	0.6455	0.6335	0.641	1908400.0
2011-02-18 09:00:00	NVDA	Stock	0.641	0.6488	0.6358	0.6412	352020920.0
2011-02-18 10:00:00	NVDA	Stock	0.6412	0.6438	0.635	0.642	245579840.0
2011-02-18 11:00:00	NVDA	Stock	0.6422	0.6443	0.6388	0.6418	134410240.0
2011-02-18 12:00:00	NVDA	Stock	0.6418	0.643	0.6398	0.641	78843280.0
2011-02-18 13:00:00	NVDA	Stock	0.641	0.642	0.6308	0.6385	196391040.0
2011-02-18 14:00:00	NVDA	Stock	0.6385	0.6388	0.6315	0.635	128756200.0
2011-02-18 15:00:00	NVDA	Stock	0.635	0.6412	0.6338	0.6412	221440120.0
2011-02-18 16:00:00	NVDA	Stock	0.6402	0.642	0.636	0.6405	29567760.0
2011-02-18 17:00:00	NVDA	Stock	0.6405	0.6408	0.6388	0.64	106400.0
2011-02-18 18:00:00	NVDA	Stock	0.6402	0.6402	0.6388	0.64	31200.0
2011-02-18 19:00:00	NVDA	Stock	0.6388	0.6388	0.6383	0.6383	110400.0
2011-02-18 08:00:00	AMZN	Stock	9.4	9.4	9.4	9.4	7600.0
2011-02-18 09:00:00	AMZN	Stock	9.405	9.417	9.333	9.356	15945540.0
2011-02-18 10:00:00	AMZN	Stock	9.354	9.425	9.345	9.373	11208800.0
2011-02-18 11:00:00	AMZN	Stock	9.373	9.4205	9.362	9.39	7664340.0
2011-02-18 12:00:00	AMZN	Stock	9.387	9.3945	9.3475	9.3505	6846500.0
2011-02-18 13:00:00	AMZN	Stock	9.348	9.358	9.274	9.307	9852980.0

> showing 50 of 44,518 rows — these rows as CSV

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