PREVIEW / stock_1hour / 2013-11-19

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-11-19.parquet
  size:    1.0 MB
  rows:    47,302
  symbols: 3,546

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
2013-11-19 05:00:00	AAPL	Stock	18.5114	18.5114	18.5107	18.5107	5600.0
2013-11-19 07:00:00	AAPL	Stock	18.5107	18.5268	18.5	18.5089	132860.0
2013-11-19 08:00:00	AAPL	Stock	18.5196	18.6	18.5082	18.5571	756196.0
2013-11-19 09:00:00	AAPL	Stock	18.5671	18.6604	18.5154	18.6489	34094256.0
2013-11-19 10:00:00	AAPL	Stock	18.6489	18.6921	18.5964	18.6	36029196.0
2013-11-19 11:00:00	AAPL	Stock	18.6	18.6121	18.5371	18.5986	24774904.0
2013-11-19 12:00:00	AAPL	Stock	18.6018	18.6336	18.5614	18.5614	27946716.0
2013-11-19 13:00:00	AAPL	Stock	18.5625	18.5905	18.4989	18.5371	23377256.0
2013-11-19 14:00:00	AAPL	Stock	18.5375	18.5714	18.5175	18.5429	19576368.0
2013-11-19 15:00:00	AAPL	Stock	18.5404	18.5871	18.54	18.5536	22638812.0
2013-11-19 16:00:00	AAPL	Stock	18.5525	18.5853	18.5361	18.5525	11227356.0
2013-11-19 17:00:00	AAPL	Stock	18.5496	18.5514	18.5354	18.5379	328636.0
2013-11-19 18:00:00	AAPL	Stock	18.5361	18.5661	18.5357	18.5571	334460.0
2013-11-19 19:00:00	AAPL	Stock	18.555	18.5636	18.5511	18.5636	69888.0
2013-11-19 04:00:00	MSFT	Stock	36.82	36.82	36.82	36.82	562.0
2013-11-19 06:00:00	MSFT	Stock	36.8	36.86	36.8	36.86	3048.0
2013-11-19 07:00:00	MSFT	Stock	36.85	36.85	36.85	36.85	3950.0
2013-11-19 08:00:00	MSFT	Stock	36.88	36.98	36.8	36.98	38659.0
2013-11-19 09:00:00	MSFT	Stock	36.95	37.23	36.7	37.13	7236332.0
2013-11-19 10:00:00	MSFT	Stock	37.135	37.18	36.835	36.93	6176926.0
2013-11-19 11:00:00	MSFT	Stock	36.93	37.02	36.84	36.91	4894357.0
2013-11-19 12:00:00	MSFT	Stock	36.91	37.1	36.87	36.895	4735275.0
2013-11-19 13:00:00	MSFT	Stock	36.89	36.94	36.76	36.8	5258186.0
2013-11-19 14:00:00	MSFT	Stock	36.8	36.86	36.79	36.845	4106983.0
2013-11-19 15:00:00	MSFT	Stock	36.85	36.91	36.67	36.74	9149920.0
2013-11-19 16:00:00	MSFT	Stock	36.74	36.971	36.62	36.7	1385050.0
2013-11-19 17:00:00	MSFT	Stock	36.66	36.71	36.63	36.7	12651.0
2013-11-19 18:00:00	MSFT	Stock	36.7	36.847	36.7	36.73	8607.0
2013-11-19 19:00:00	MSFT	Stock	36.81	36.81	36.7	36.7	3000.0
2013-11-19 09:00:00	NVDA	Stock	0.3905	0.394	0.3893	0.3918	22108320.0
2013-11-19 10:00:00	NVDA	Stock	0.3918	0.3925	0.3905	0.3908	24506080.0
2013-11-19 11:00:00	NVDA	Stock	0.3908	0.391	0.3882	0.3891	20817640.0
2013-11-19 12:00:00	NVDA	Stock	0.389	0.3898	0.3875	0.3877	12263240.0
2013-11-19 13:00:00	NVDA	Stock	0.3875	0.388	0.386	0.3862	29828120.0
2013-11-19 14:00:00	NVDA	Stock	0.386	0.3882	0.3855	0.3871	28078560.0
2013-11-19 15:00:00	NVDA	Stock	0.3871	0.3882	0.3858	0.386	47578560.0
2013-11-19 16:00:00	NVDA	Stock	0.386	0.3878	0.3859	0.386	7237200.0
2013-11-19 17:00:00	NVDA	Stock	0.3875	0.3902	0.3875	0.39	636000.0
2013-11-19 18:00:00	NVDA	Stock	0.389	0.39	0.389	0.39	112000.0
2013-11-19 04:00:00	AMZN	Stock	18.294	18.311	18.294	18.311	4000.0
2013-11-19 05:00:00	AMZN	Stock	18.294	18.294	18.294	18.294	2000.0
2013-11-19 08:00:00	AMZN	Stock	18.209	18.2955	18.209	18.275	11600.0
2013-11-19 09:00:00	AMZN	Stock	18.279	18.375	18.1825	18.3422	5083720.0
2013-11-19 10:00:00	AMZN	Stock	18.342	18.439	18.3375	18.3975	7987900.0
2013-11-19 11:00:00	AMZN	Stock	18.39	18.406	18.2745	18.3126	4190460.0
2013-11-19 12:00:00	AMZN	Stock	18.322	18.3725	18.289	18.289	3211240.0
2013-11-19 13:00:00	AMZN	Stock	18.2875	18.3075	18.125	18.1765	4950880.0
2013-11-19 14:00:00	AMZN	Stock	18.1665	18.2605	18.1575	18.2385	3793900.0
2013-11-19 15:00:00	AMZN	Stock	18.228	18.317	18.214	18.252	6612180.0
2013-11-19 16:00:00	AMZN	Stock	18.247	18.2939	18.2358	18.2358	1894600.0

> showing 50 of 47,302 rows — these rows as CSV

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