PREVIEW / stock_1hour / 2014-01-15

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-15.parquet
  size:    1.0 MB
  rows:    49,061
  symbols: 3,518

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-15 04:00:00	AAPL	Stock	19.5507	19.8143	19.5507	19.7854	152180.0
2014-01-15 05:00:00	AAPL	Stock	19.7836	19.7836	19.7504	19.7654	71232.0
2014-01-15 06:00:00	AAPL	Stock	19.7836	19.7839	19.7143	19.7375	240772.0
2014-01-15 07:00:00	AAPL	Stock	19.7411	19.8839	19.7314	19.8218	2046632.0
2014-01-15 08:00:00	AAPL	Stock	19.8214	19.875	19.7393	19.7861	3680348.0
2014-01-15 09:00:00	AAPL	Stock	19.7861	19.9286	19.7021	19.9279	82526276.0
2014-01-15 10:00:00	AAPL	Stock	19.9279	19.9996	19.875	19.9286	60843720.0
2014-01-15 11:00:00	AAPL	Stock	19.9257	19.9711	19.8964	19.9357	29651356.0
2014-01-15 12:00:00	AAPL	Stock	19.9389	20.0068	19.9146	19.9707	32414004.0
2014-01-15 13:00:00	AAPL	Stock	19.9718	20.0018	19.8814	19.9127	27102404.0
2014-01-15 14:00:00	AAPL	Stock	19.9107	19.9692	19.9064	19.9518	19609856.0
2014-01-15 15:00:00	AAPL	Stock	19.9496	19.9732	19.8489	19.9057	44720872.0
2014-01-15 16:00:00	AAPL	Stock	19.9057	19.9636	19.7579	19.9054	19054028.0
2014-01-15 17:00:00	AAPL	Stock	19.9057	19.9643	19.9004	19.9643	617652.0
2014-01-15 18:00:00	AAPL	Stock	19.9643	19.9736	19.9061	19.959	779240.0
2014-01-15 19:00:00	AAPL	Stock	19.9632	19.9732	19.9554	19.9707	746508.0
2014-01-15 04:00:00	MSFT	Stock	35.75	35.86	35.75	35.86	600.0
2014-01-15 05:00:00	MSFT	Stock	35.9	35.9	35.9	35.9	300.0
2014-01-15 07:00:00	MSFT	Stock	35.89	35.95	35.88	35.92	9968.0
2014-01-15 08:00:00	MSFT	Stock	35.92	35.97	35.89	35.95	22119.0
2014-01-15 09:00:00	MSFT	Stock	35.93	36.32	35.85	36.24	5201620.0
2014-01-15 10:00:00	MSFT	Stock	36.25	36.55	36.2	36.55	6218016.0
2014-01-15 11:00:00	MSFT	Stock	36.55	36.67	36.535	36.65	5317665.0
2014-01-15 12:00:00	MSFT	Stock	36.647	36.7	36.59	36.61	2986376.0
2014-01-15 13:00:00	MSFT	Stock	36.6	36.73	36.6	36.7	2894722.0
2014-01-15 14:00:00	MSFT	Stock	36.7	36.745	36.6	36.665	6049130.0
2014-01-15 15:00:00	MSFT	Stock	36.67	36.79	36.66	36.76	9581906.0
2014-01-15 16:00:00	MSFT	Stock	36.76	36.761	36.561	36.75	5509450.0
2014-01-15 17:00:00	MSFT	Stock	36.67	36.76	36.67	36.7	18909.0
2014-01-15 18:00:00	MSFT	Stock	36.7	36.76	36.7	36.76	3438.0
2014-01-15 19:00:00	MSFT	Stock	36.71	36.71	36.55	36.6	26161.0
2014-01-15 08:00:00	NVDA	Stock	0.397	0.3975	0.3953	0.3953	336800.0
2014-01-15 09:00:00	NVDA	Stock	0.397	0.4009	0.396	0.4006	22560800.0
2014-01-15 10:00:00	NVDA	Stock	0.4008	0.4016	0.3969	0.3988	22676840.0
2014-01-15 11:00:00	NVDA	Stock	0.3988	0.4004	0.3988	0.3995	27306200.0
2014-01-15 12:00:00	NVDA	Stock	0.3995	0.4	0.3988	0.399	10640320.0
2014-01-15 13:00:00	NVDA	Stock	0.3993	0.3995	0.3988	0.399	14931520.0
2014-01-15 14:00:00	NVDA	Stock	0.399	0.4008	0.399	0.4008	23462400.0
2014-01-15 15:00:00	NVDA	Stock	0.4008	0.4013	0.3998	0.4003	41473200.0
2014-01-15 16:00:00	NVDA	Stock	0.4003	0.4005	0.3985	0.3985	896600.0
2014-01-15 17:00:00	NVDA	Stock	0.4003	0.4003	0.4003	0.4003	37560.0
2014-01-15 06:00:00	AMZN	Stock	19.9925	19.9925	19.9925	19.9925	2000.0
2014-01-15 07:00:00	AMZN	Stock	19.992	19.992	19.9555	19.9555	19140.0
2014-01-15 08:00:00	AMZN	Stock	19.9725	19.9955	19.935	19.935	40040.0
2014-01-15 09:00:00	AMZN	Stock	19.988	19.995	19.8055	19.8545	6734160.0
2014-01-15 10:00:00	AMZN	Stock	19.8725	19.9055	19.7256	19.7256	10457420.0
2014-01-15 11:00:00	AMZN	Stock	19.725	19.788	19.6267	19.688	9565580.0
2014-01-15 12:00:00	AMZN	Stock	19.6875	19.7631	19.682	19.715	3681640.0
2014-01-15 13:00:00	AMZN	Stock	19.708	19.773	19.689	19.711	2973820.0
2014-01-15 14:00:00	AMZN	Stock	19.7115	19.8125	19.6905	19.7985	4287940.0

> showing 50 of 49,061 rows — these rows as CSV

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