PREVIEW / stock_1hour / 2014-01-28

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-28.parquet
  size:    1.0 MB
  rows:    48,107
  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
2014-01-28 04:00:00	AAPL	Stock	18.2232	18.5714	18.1982	18.3357	504308.0
2014-01-28 05:00:00	AAPL	Stock	18.3411	18.3757	18.3	18.3214	271600.0
2014-01-28 06:00:00	AAPL	Stock	18.315	18.3189	18.1989	18.2696	1205400.0
2014-01-28 07:00:00	AAPL	Stock	18.3032	18.355	18.2179	18.3189	3260712.0
2014-01-28 08:00:00	AAPL	Stock	18.3161	18.3489	18.1082	18.25	16552732.0
2014-01-28 09:00:00	AAPL	Stock	18.2536	18.325	17.9454	18.0027	236396468.0
2014-01-28 10:00:00	AAPL	Stock	18.0028	18.3929	17.9311	18.2475	198876832.0
2014-01-28 11:00:00	AAPL	Stock	18.2407	18.3303	18.1186	18.1911	124972176.0
2014-01-28 12:00:00	AAPL	Stock	18.1979	18.2411	18.1011	18.2287	58179604.0
2014-01-28 13:00:00	AAPL	Stock	18.2264	18.2411	18.0718	18.0807	55381004.0
2014-01-28 14:00:00	AAPL	Stock	18.0826	18.2214	18.0732	18.1625	51825984.0
2014-01-28 15:00:00	AAPL	Stock	18.1629	18.1631	18.0214	18.1011	100121896.0
2014-01-28 16:00:00	AAPL	Stock	18.1054	19.6607	17.9795	18.0786	35034440.0
2014-01-28 17:00:00	AAPL	Stock	18.08	18.1404	18.08	18.1332	1119888.0
2014-01-28 18:00:00	AAPL	Stock	18.1257	18.1689	18.1054	18.1454	545916.0
2014-01-28 19:00:00	AAPL	Stock	18.1482	18.1743	18.1468	18.1636	564144.0
2014-01-28 04:00:00	MSFT	Stock	36.14	36.14	36.14	36.14	554.0
2014-01-28 07:00:00	MSFT	Stock	36.28	36.28	36.26	36.26	2250.0
2014-01-28 08:00:00	MSFT	Stock	36.29	36.31	36.12	36.3	24580.0
2014-01-28 09:00:00	MSFT	Stock	36.3	36.39	36.07	36.21	3725149.0
2014-01-28 10:00:00	MSFT	Stock	36.21	36.27	35.99	36.064	5082945.0
2014-01-28 11:00:00	MSFT	Stock	36.067	36.13	35.75	35.915	5571441.0
2014-01-28 12:00:00	MSFT	Stock	35.915	36.02	35.86	35.98	3970951.0
2014-01-28 13:00:00	MSFT	Stock	35.98	36.12	35.905	36.07	3794725.0
2014-01-28 14:00:00	MSFT	Stock	36.07	36.21	36.02	36.14	3521863.0
2014-01-28 15:00:00	MSFT	Stock	36.14	36.29	36.09	36.27	6582894.0
2014-01-28 16:00:00	MSFT	Stock	36.27	36.34	35.925	36.26	3099862.0
2014-01-28 17:00:00	MSFT	Stock	36.28	36.4	36.03	36.39	47109.0
2014-01-28 18:00:00	MSFT	Stock	36.4	36.41	36.39	36.4	16675.0
2014-01-28 19:00:00	MSFT	Stock	36.42	36.48	36.42	36.48	770.0
2014-01-28 09:00:00	NVDA	Stock	0.3855	0.3868	0.3842	0.3862	15848960.0
2014-01-28 10:00:00	NVDA	Stock	0.3862	0.3898	0.386	0.3893	20418360.0
2014-01-28 11:00:00	NVDA	Stock	0.3894	0.3905	0.387	0.3873	20754480.0
2014-01-28 12:00:00	NVDA	Stock	0.3874	0.3875	0.3862	0.387	10635280.0
2014-01-28 13:00:00	NVDA	Stock	0.3873	0.3873	0.3855	0.3855	7395680.0
2014-01-28 14:00:00	NVDA	Stock	0.3855	0.3893	0.3853	0.3888	12447920.0
2014-01-28 15:00:00	NVDA	Stock	0.3888	0.3905	0.3882	0.39	28002320.0
2014-01-28 16:00:00	NVDA	Stock	0.39	0.391	0.3888	0.3903	28062080.0
2014-01-28 04:00:00	AMZN	Stock	19.3875	19.4845	19.3875	19.4375	6080.0
2014-01-28 07:00:00	AMZN	Stock	19.4125	19.513	19.4125	19.441	43500.0
2014-01-28 08:00:00	AMZN	Stock	19.505	19.505	19.35	19.425	131860.0
2014-01-28 09:00:00	AMZN	Stock	19.383	19.72	19.351	19.6435	10000800.0
2014-01-28 10:00:00	AMZN	Stock	19.643	19.6915	19.534	19.6135	8946540.0
2014-01-28 11:00:00	AMZN	Stock	19.614	19.6675	19.4035	19.4855	9358900.0
2014-01-28 12:00:00	AMZN	Stock	19.493	19.594	19.4715	19.552	3928800.0
2014-01-28 13:00:00	AMZN	Stock	19.563	19.6868	19.55	19.608	6627060.0
2014-01-28 14:00:00	AMZN	Stock	19.6035	19.715	19.596	19.6903	4199060.0
2014-01-28 15:00:00	AMZN	Stock	19.696	19.737	19.6615	19.721	7235600.0
2014-01-28 16:00:00	AMZN	Stock	19.7185	19.737	19.5275	19.7	851140.0
2014-01-28 17:00:00	AMZN	Stock	19.7345	19.8	19.7345	19.7875	45960.0

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

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