PREVIEW / stock_1hour / 2014-11-07

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-11-07.parquet
  size:    1.0 MB
  rows:    48,452
  symbols: 3,553

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
2014-11-07 04:00:00	AAPL	Stock	27.1925	27.205	27.175	27.205	18712.0
2014-11-07 05:00:00	AAPL	Stock	27.2125	27.2475	27.2125	27.2425	20992.0
2014-11-07 06:00:00	AAPL	Stock	27.2425	27.2475	27.225	27.225	24484.0
2014-11-07 07:00:00	AAPL	Stock	27.225	27.225	27.1625	27.175	95732.0
2014-11-07 08:00:00	AAPL	Stock	27.175	27.23	26.93	27.2	445012.0
2014-11-07 09:00:00	AAPL	Stock	27.205	27.3275	27.1375	27.3232	23338524.0
2014-11-07 10:00:00	AAPL	Stock	27.3225	27.33	27.1525	27.244	23300072.0
2014-11-07 11:00:00	AAPL	Stock	27.245	27.245	27.175	27.2018	10982616.0
2014-11-07 12:00:00	AAPL	Stock	27.2	27.2225	27.1825	27.205	7146216.0
2014-11-07 13:00:00	AAPL	Stock	27.205	27.2725	27.195	27.2475	10434132.0
2014-11-07 14:00:00	AAPL	Stock	27.2475	27.2575	27.2125	27.2362	8340104.0
2014-11-07 15:00:00	AAPL	Stock	27.235	27.2525	27.2025	27.25	21217736.0
2014-11-07 16:00:00	AAPL	Stock	27.2525	27.26	27.2202	27.2525	7647920.0
2014-11-07 17:00:00	AAPL	Stock	27.25	27.2675	27.235	27.255	132600.0
2014-11-07 18:00:00	AAPL	Stock	27.255	27.26	27.25	27.2575	59152.0
2014-11-07 19:00:00	AAPL	Stock	27.255	27.26	27.2425	27.26	45516.0
2014-11-07 04:00:00	MSFT	Stock	48.85	48.85	48.85	48.85	200.0
2014-11-07 05:00:00	MSFT	Stock	48.85	48.85	48.85	48.85	914.0
2014-11-07 07:00:00	MSFT	Stock	48.73	48.73	48.64	48.7	3600.0
2014-11-07 08:00:00	MSFT	Stock	48.85	48.97	48.66	48.8	39474.0
2014-11-07 09:00:00	MSFT	Stock	48.79	48.96	48.29	48.45	3891265.0
2014-11-07 10:00:00	MSFT	Stock	48.455	48.52	48.3	48.41	5694355.0
2014-11-07 11:00:00	MSFT	Stock	48.41	48.56	48.32	48.4	3014365.0
2014-11-07 12:00:00	MSFT	Stock	48.405	48.49	48.385	48.41	1680793.0
2014-11-07 13:00:00	MSFT	Stock	48.41	48.66	48.4	48.53	2978242.0
2014-11-07 14:00:00	MSFT	Stock	48.53	48.63	48.48	48.535	1807889.0
2014-11-07 15:00:00	MSFT	Stock	48.54	48.7	48.45	48.68	4616871.0
2014-11-07 16:00:00	MSFT	Stock	48.68	48.72	48.37	48.7	2769162.0
2014-11-07 17:00:00	MSFT	Stock	48.7	48.7	48.554	48.7	27921.0
2014-11-07 18:00:00	MSFT	Stock	48.69	49.0	48.65	48.65	9553.0
2014-11-07 19:00:00	MSFT	Stock	48.7	48.7	48.7	48.7	241.0
2014-11-07 06:00:00	NVDA	Stock	0.525	0.525	0.525	0.525	8000.0
2014-11-07 08:00:00	NVDA	Stock	0.5188	0.5225	0.5175	0.5175	341000.0
2014-11-07 09:00:00	NVDA	Stock	0.5188	0.5188	0.4965	0.4965	85449680.0
2014-11-07 10:00:00	NVDA	Stock	0.4965	0.498	0.4898	0.4972	97989840.0
2014-11-07 11:00:00	NVDA	Stock	0.497	0.4974	0.4925	0.4932	40967240.0
2014-11-07 12:00:00	NVDA	Stock	0.4935	0.4952	0.492	0.494	29628400.0
2014-11-07 13:00:00	NVDA	Stock	0.4942	0.4963	0.4942	0.4948	26793360.0
2014-11-07 14:00:00	NVDA	Stock	0.4949	0.4955	0.493	0.4955	30321800.0
2014-11-07 15:00:00	NVDA	Stock	0.4955	0.4955	0.492	0.4948	86687680.0
2014-11-07 16:00:00	NVDA	Stock	0.4948	0.5066	0.494	0.4951	34253960.0
2014-11-07 18:00:00	NVDA	Stock	0.494	0.494	0.494	0.494	24000.0
2014-11-07 19:00:00	NVDA	Stock	0.495	0.495	0.495	0.495	12000.0
2014-11-07 04:00:00	AMZN	Stock	14.8555	14.8555	14.8555	14.8555	2000.0
2014-11-07 08:00:00	AMZN	Stock	14.8565	14.86	14.818	14.85	46480.0
2014-11-07 09:00:00	AMZN	Stock	14.85	14.9145	14.8225	14.833	7183540.0
2014-11-07 10:00:00	AMZN	Stock	14.8275	14.9795	14.8145	14.9445	9675560.0
2014-11-07 11:00:00	AMZN	Stock	14.951	14.955	14.876	14.9128	6109020.0
2014-11-07 12:00:00	AMZN	Stock	14.9095	14.953	14.8915	14.944	5020220.0
2014-11-07 13:00:00	AMZN	Stock	14.943	14.9995	14.9395	14.9814	3950560.0

> showing 50 of 48,452 rows — these rows as CSV

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