PREVIEW / stock_1hour / 2014-01-30

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-30.parquet
  size:    1.0 MB
  rows:    48,798
  symbols: 3,526

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-01-30 04:00:00	AAPL	Stock	17.8232	17.8346	17.7857	17.7857	38472.0
2014-01-30 05:00:00	AAPL	Stock	17.7893	17.8282	17.7764	17.8282	91896.0
2014-01-30 06:00:00	AAPL	Stock	17.8164	17.8839	17.8036	17.8839	71008.0
2014-01-30 07:00:00	AAPL	Stock	17.8857	17.9229	17.8625	17.8818	418376.0
2014-01-30 08:00:00	AAPL	Stock	17.9096	17.9096	17.7893	17.8479	3348520.0
2014-01-30 09:00:00	AAPL	Stock	17.8439	18.0893	17.8318	17.9557	83682396.0
2014-01-30 10:00:00	AAPL	Stock	17.9568	17.9568	17.7682	17.8068	77055076.0
2014-01-30 11:00:00	AAPL	Stock	17.8082	17.9139	17.7393	17.8889	55775496.0
2014-01-30 12:00:00	AAPL	Stock	17.8871	17.9729	17.8775	17.9441	33460588.0
2014-01-30 13:00:00	AAPL	Stock	17.945	17.9596	17.8571	17.86	32601352.0
2014-01-30 14:00:00	AAPL	Stock	17.8621	17.8711	17.8357	17.8514	27262312.0
2014-01-30 15:00:00	AAPL	Stock	17.8489	17.8811	17.8196	17.8312	53223100.0
2014-01-30 16:00:00	AAPL	Stock	17.8371	17.8916	17.8089	17.8268	51183692.0
2014-01-30 17:00:00	AAPL	Stock	17.825	17.8464	17.8214	17.8346	1005144.0
2014-01-30 18:00:00	AAPL	Stock	17.8368	17.8464	17.8318	17.835	123620.0
2014-01-30 19:00:00	AAPL	Stock	17.8393	17.8493	17.8239	17.8414	116312.0
2014-01-30 04:00:00	MSFT	Stock	36.26	36.66	36.26	36.66	200.0
2014-01-30 06:00:00	MSFT	Stock	36.48	36.48	36.48	36.48	306.0
2014-01-30 07:00:00	MSFT	Stock	36.69	36.69	36.48	36.48	8038.0
2014-01-30 08:00:00	MSFT	Stock	36.49	36.65	36.49	36.65	35983.0
2014-01-30 09:00:00	MSFT	Stock	36.66	36.92	36.415	36.477	5731549.0
2014-01-30 10:00:00	MSFT	Stock	36.47	36.52	36.23	36.46	4652889.0
2014-01-30 11:00:00	MSFT	Stock	36.44	36.79	36.41	36.73	3951184.0
2014-01-30 12:00:00	MSFT	Stock	36.74	36.8	36.67	36.785	3126212.0
2014-01-30 13:00:00	MSFT	Stock	36.78	36.8	36.72	36.725	2431386.0
2014-01-30 14:00:00	MSFT	Stock	36.72	36.75	36.59	36.68	2918997.0
2014-01-30 15:00:00	MSFT	Stock	36.685	36.88	36.68	36.86	8460436.0
2014-01-30 16:00:00	MSFT	Stock	36.87	36.877	36.0	36.4	2279379.0
2014-01-30 17:00:00	MSFT	Stock	36.4	37.4	36.31	37.21	645158.0
2014-01-30 18:00:00	MSFT	Stock	37.21	37.21	36.87	37.15	30745.0
2014-01-30 19:00:00	MSFT	Stock	37.15	37.17	37.1	37.12	8757.0
2014-01-30 06:00:00	NVDA	Stock	0.4075	0.4075	0.4075	0.4075	4000.0
2014-01-30 08:00:00	NVDA	Stock	0.3913	0.3913	0.3913	0.3913	4564000.0
2014-01-30 09:00:00	NVDA	Stock	0.3882	0.392	0.3875	0.3918	26744720.0
2014-01-30 10:00:00	NVDA	Stock	0.3915	0.392	0.389	0.389	27940680.0
2014-01-30 11:00:00	NVDA	Stock	0.3891	0.3922	0.3888	0.3916	22162800.0
2014-01-30 12:00:00	NVDA	Stock	0.3915	0.3928	0.3914	0.3918	12812200.0
2014-01-30 13:00:00	NVDA	Stock	0.3918	0.392	0.391	0.3913	20532360.0
2014-01-30 14:00:00	NVDA	Stock	0.3914	0.3929	0.3905	0.3925	17797720.0
2014-01-30 15:00:00	NVDA	Stock	0.3925	0.3938	0.3925	0.3928	43651320.0
2014-01-30 16:00:00	NVDA	Stock	0.393	0.3935	0.3899	0.391	10381600.0
2014-01-30 17:00:00	NVDA	Stock	0.393	0.393	0.393	0.393	420280.0
2014-01-30 04:00:00	AMZN	Stock	19.3155	19.34	19.3155	19.34	6000.0
2014-01-30 05:00:00	AMZN	Stock	19.324	19.4375	19.324	19.4375	11800.0
2014-01-30 06:00:00	AMZN	Stock	19.5	19.5	19.5	19.5	2000.0
2014-01-30 07:00:00	AMZN	Stock	19.55	19.5975	19.4995	19.5975	85600.0
2014-01-30 08:00:00	AMZN	Stock	19.598	19.652	19.5535	19.6285	387040.0
2014-01-30 09:00:00	AMZN	Stock	19.65	19.7	19.385	19.4658	14593540.0
2014-01-30 10:00:00	AMZN	Stock	19.459	19.867	19.3875	19.794	17116540.0
2014-01-30 11:00:00	AMZN	Stock	19.794	19.9635	19.7615	19.9	14407040.0

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

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