PREVIEW / stock_1hour / 2014-01-23

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-23.parquet
  size:    1.0 MB
  rows:    48,391
  symbols: 3,549

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-23 04:00:00	AAPL	Stock	19.75	19.75	19.7171	19.7382	8932.0
2014-01-23 05:00:00	AAPL	Stock	19.7439	19.7439	19.7439	19.7439	5600.0
2014-01-23 06:00:00	AAPL	Stock	19.7411	19.7411	19.7071	19.7143	30940.0
2014-01-23 07:00:00	AAPL	Stock	19.6964	19.7071	19.6493	19.7021	405776.0
2014-01-23 08:00:00	AAPL	Stock	19.6607	19.7082	19.6296	19.6418	958104.0
2014-01-23 09:00:00	AAPL	Stock	19.635	19.7082	19.5754	19.6721	39449060.0
2014-01-23 10:00:00	AAPL	Stock	19.6741	19.7082	19.4764	19.4882	41545308.0
2014-01-23 11:00:00	AAPL	Stock	19.4911	19.5629	19.4574	19.5489	23446276.0
2014-01-23 12:00:00	AAPL	Stock	19.55	19.6036	19.519	19.5989	15421924.0
2014-01-23 13:00:00	AAPL	Stock	19.6012	19.7568	19.5975	19.7143	50606612.0
2014-01-23 14:00:00	AAPL	Stock	19.715	19.8311	19.6939	19.8196	58148272.0
2014-01-23 15:00:00	AAPL	Stock	19.8186	19.875	19.7657	19.8636	70084476.0
2014-01-23 16:00:00	AAPL	Stock	19.8636	19.8929	19.5732	19.8686	41132560.0
2014-01-23 17:00:00	AAPL	Stock	19.8643	19.8695	19.8439	19.8439	340956.0
2014-01-23 18:00:00	AAPL	Stock	19.845	19.8636	19.845	19.8521	346640.0
2014-01-23 19:00:00	AAPL	Stock	19.8521	19.8571	19.8379	19.8554	147000.0
2014-01-23 04:00:00	MSFT	Stock	36.07	36.23	36.07	36.23	1071.0
2014-01-23 05:00:00	MSFT	Stock	36.23	36.27	36.23	36.27	900.0
2014-01-23 06:00:00	MSFT	Stock	36.24	36.24	36.24	36.24	100.0
2014-01-23 07:00:00	MSFT	Stock	36.18	36.19	36.1	36.12	7331.0
2014-01-23 08:00:00	MSFT	Stock	36.19	36.31	36.12	36.2	34238.0
2014-01-23 09:00:00	MSFT	Stock	36.22	36.29	35.63	35.64	4757268.0
2014-01-23 10:00:00	MSFT	Stock	35.65	35.81	35.58	35.76	4672337.0
2014-01-23 11:00:00	MSFT	Stock	35.76	35.88	35.67	35.8	3677075.0
2014-01-23 12:00:00	MSFT	Stock	35.79	35.81	35.66	35.705	3121239.0
2014-01-23 13:00:00	MSFT	Stock	35.705	35.72	35.52	35.64	3826882.0
2014-01-23 14:00:00	MSFT	Stock	35.64	36.09	35.61	35.846	5445673.0
2014-01-23 15:00:00	MSFT	Stock	35.84	36.07	35.77	36.057	7865711.0
2014-01-23 16:00:00	MSFT	Stock	36.05	38.05	35.809	37.28	7556680.0
2014-01-23 17:00:00	MSFT	Stock	35.763	37.68	35.763	37.32	1041008.0
2014-01-23 18:00:00	MSFT	Stock	37.37	37.46	37.19	37.36	185806.0
2014-01-23 19:00:00	MSFT	Stock	37.4	37.45	37.3	37.45	88425.0
2014-01-23 08:00:00	NVDA	Stock	0.4	0.4	0.4	0.4	4000.0
2014-01-23 09:00:00	NVDA	Stock	0.3975	0.4038	0.397	0.399	38082440.0
2014-01-23 10:00:00	NVDA	Stock	0.399	0.4008	0.3978	0.3982	28536720.0
2014-01-23 11:00:00	NVDA	Stock	0.398	0.399	0.3978	0.3988	12180200.0
2014-01-23 12:00:00	NVDA	Stock	0.3988	0.3988	0.3975	0.398	13862160.0
2014-01-23 13:00:00	NVDA	Stock	0.398	0.3982	0.3962	0.3965	15784400.0
2014-01-23 14:00:00	NVDA	Stock	0.3966	0.398	0.3965	0.3973	9682680.0
2014-01-23 15:00:00	NVDA	Stock	0.3973	0.3995	0.3971	0.3993	37397960.0
2014-01-23 16:00:00	NVDA	Stock	0.3993	0.4013	0.3988	0.3988	24393320.0
2014-01-23 04:00:00	AMZN	Stock	20.3005	20.308	20.2875	20.308	8000.0
2014-01-23 07:00:00	AMZN	Stock	20.28	20.28	20.28	20.28	2000.0
2014-01-23 08:00:00	AMZN	Stock	20.4325	20.4325	20.106	20.106	204520.0
2014-01-23 09:00:00	AMZN	Stock	20.126	20.3085	19.936	20.214	13371480.0
2014-01-23 10:00:00	AMZN	Stock	20.2145	20.2305	20.075	20.1	9589460.0
2014-01-23 11:00:00	AMZN	Stock	20.1	20.1719	20.059	20.1675	3263480.0
2014-01-23 12:00:00	AMZN	Stock	20.16	20.1666	19.9975	20.0655	5472680.0
2014-01-23 13:00:00	AMZN	Stock	20.075	20.077	19.8895	19.9105	7182500.0
2014-01-23 14:00:00	AMZN	Stock	19.916	19.9995	19.9	19.9685	4982560.0

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

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