PREVIEW / stock_1hour / 2012-12-03

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-12-03.parquet
  size:    949 KB
  rows:    44,888
  symbols: 3,502

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-12-03 04:00:00	AAPL	Stock	21.0536	21.0789	21.0396	21.0714	34860.0
2012-12-03 05:00:00	AAPL	Stock	21.0536	21.0536	21.0357	21.0429	56560.0
2012-12-03 06:00:00	AAPL	Stock	21.0429	21.0536	21.0429	21.0439	22400.0
2012-12-03 07:00:00	AAPL	Stock	21.0625	21.1339	21.0536	21.1036	654472.0
2012-12-03 08:00:00	AAPL	Stock	21.1036	21.1246	20.9029	21.1182	2456804.0
2012-12-03 09:00:00	AAPL	Stock	21.1179	21.2354	21.1146	21.1571	72173136.0
2012-12-03 10:00:00	AAPL	Stock	21.1536	21.1571	20.9829	21.0082	79154796.0
2012-12-03 11:00:00	AAPL	Stock	21.0082	21.1025	20.9807	21.0889	40064388.0
2012-12-03 12:00:00	AAPL	Stock	21.0889	21.1029	21.0196	21.0307	20734728.0
2012-12-03 13:00:00	AAPL	Stock	21.0221	21.05	20.9643	21.03	31013360.0
2012-12-03 14:00:00	AAPL	Stock	21.0246	21.0729	20.955	20.9911	31969000.0
2012-12-03 15:00:00	AAPL	Stock	20.9907	21.0429	20.9107	20.9318	59769416.0
2012-12-03 16:00:00	AAPL	Stock	20.9321	21.098	20.9029	20.9032	8390984.0
2012-12-03 17:00:00	AAPL	Stock	20.9032	20.9071	20.8604	20.8714	477904.0
2012-12-03 18:00:00	AAPL	Stock	20.875	20.8929	20.875	20.8921	170968.0
2012-12-03 19:00:00	AAPL	Stock	20.8786	20.8825	20.8539	20.8571	273224.0
2012-12-03 07:00:00	MSFT	Stock	26.75	26.77	26.71	26.75	20770.0
2012-12-03 08:00:00	MSFT	Stock	26.73	26.79	26.73	26.76	106271.0
2012-12-03 09:00:00	MSFT	Stock	26.77	26.85	26.65	26.725	5654804.0
2012-12-03 10:00:00	MSFT	Stock	26.72	26.735	26.48	26.525	10184398.0
2012-12-03 11:00:00	MSFT	Stock	26.52	26.59	26.49	26.58	6691981.0
2012-12-03 12:00:00	MSFT	Stock	26.575	26.59	26.49	26.506	4990468.0
2012-12-03 13:00:00	MSFT	Stock	26.5	26.52	26.475	26.5	4775739.0
2012-12-03 14:00:00	MSFT	Stock	26.495	26.52	26.41	26.47	5564796.0
2012-12-03 15:00:00	MSFT	Stock	26.475	26.52	26.4	26.42	11653912.0
2012-12-03 16:00:00	MSFT	Stock	26.43	26.62	26.41	26.44	1975708.0
2012-12-03 17:00:00	MSFT	Stock	26.45	26.58	26.4	26.57	38286.0
2012-12-03 18:00:00	MSFT	Stock	26.57	26.57	26.46	26.46	23955.0
2012-12-03 19:00:00	MSFT	Stock	26.47	26.47	26.42	26.42	15632.0
2012-12-03 08:00:00	NVDA	Stock	0.3005	0.3018	0.3005	0.3018	91000.0
2012-12-03 09:00:00	NVDA	Stock	0.3015	0.3032	0.2958	0.2981	80317400.0
2012-12-03 10:00:00	NVDA	Stock	0.298	0.3	0.2965	0.2978	61525960.0
2012-12-03 11:00:00	NVDA	Stock	0.2978	0.2982	0.2958	0.2979	38800960.0
2012-12-03 12:00:00	NVDA	Stock	0.2979	0.298	0.2965	0.2965	23178480.0
2012-12-03 13:00:00	NVDA	Stock	0.2965	0.2965	0.2948	0.2952	35143000.0
2012-12-03 14:00:00	NVDA	Stock	0.2952	0.2962	0.2948	0.2959	33014160.0
2012-12-03 15:00:00	NVDA	Stock	0.2959	0.2966	0.293	0.2938	109586640.0
2012-12-03 16:00:00	NVDA	Stock	0.2932	0.2965	0.2932	0.294	7975320.0
2012-12-03 17:00:00	NVDA	Stock	0.2938	0.2938	0.2938	0.2938	80000.0
2012-12-03 18:00:00	NVDA	Stock	0.2938	0.2938	0.2938	0.2938	92000.0
2012-12-03 19:00:00	NVDA	Stock	0.294	0.294	0.2938	0.294	40000.0
2012-12-03 04:00:00	AMZN	Stock	12.6375	12.6375	12.6375	12.6375	2000.0
2012-12-03 07:00:00	AMZN	Stock	12.65	12.6925	12.65	12.65	34100.0
2012-12-03 08:00:00	AMZN	Stock	12.6495	12.6495	12.6	12.6485	145000.0
2012-12-03 09:00:00	AMZN	Stock	12.6485	12.675	12.5755	12.6585	10190240.0
2012-12-03 10:00:00	AMZN	Stock	12.66	12.708	12.614	12.6365	11887420.0
2012-12-03 11:00:00	AMZN	Stock	12.6345	12.65	12.5695	12.636	6730580.0
2012-12-03 12:00:00	AMZN	Stock	12.636	12.6385	12.573	12.5815	3108520.0
2012-12-03 13:00:00	AMZN	Stock	12.5795	12.5965	12.56	12.5705	3829960.0
2012-12-03 14:00:00	AMZN	Stock	12.569	12.5925	12.535	12.5526	6510540.0

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

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