PREVIEW / stock_1hour / 2013-04-23

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-23.parquet
  size:    976 KB
  rows:    45,559
  symbols: 3,477

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
2013-04-23 04:00:00	AAPL	Stock	14.2643	14.2643	14.2143	14.2282	164864.0
2013-04-23 05:00:00	AAPL	Stock	14.2382	14.2429	14.2321	14.2429	33600.0
2013-04-23 06:00:00	AAPL	Stock	14.2711	14.275	14.2711	14.275	5600.0
2013-04-23 07:00:00	AAPL	Stock	14.2857	14.4446	14.2857	14.405	1534316.0
2013-04-23 08:00:00	AAPL	Stock	14.3943	14.4286	14.3218	14.3886	2460276.0
2013-04-23 09:00:00	AAPL	Stock	14.3843	14.4732	14.2593	14.3279	79079140.0
2013-04-23 10:00:00	AAPL	Stock	14.3246	14.4507	14.2432	14.4364	70563276.0
2013-04-23 11:00:00	AAPL	Stock	14.4389	14.5093	14.4025	14.4954	52405220.0
2013-04-23 12:00:00	AAPL	Stock	14.4954	14.5536	14.4614	14.4948	49507360.0
2013-04-23 13:00:00	AAPL	Stock	14.495	14.5268	14.3571	14.4891	49420392.0
2013-04-23 14:00:00	AAPL	Stock	14.4893	14.5118	14.3968	14.485	39442704.0
2013-04-23 15:00:00	AAPL	Stock	14.4854	14.585	14.4682	14.5002	97868932.0
2013-04-23 16:00:00	AAPL	Stock	14.5002	15.3389	14.22	15.2089	76204016.0
2013-04-23 17:00:00	AAPL	Stock	15.2093	15.3536	14.4086	14.5093	81665640.0
2013-04-23 18:00:00	AAPL	Stock	14.51	14.5679	14.3754	14.4679	17086524.0
2013-04-23 19:00:00	AAPL	Stock	14.4671	14.4893	14.4214	14.4268	4147584.0
2013-04-23 04:00:00	MSFT	Stock	30.9	30.9	30.9	30.9	1000.0
2013-04-23 06:00:00	MSFT	Stock	30.69	30.69	30.69	30.69	100.0
2013-04-23 07:00:00	MSFT	Stock	30.85	30.9	30.85	30.9	5600.0
2013-04-23 08:00:00	MSFT	Stock	30.85	30.86	30.55	30.74	61814.0
2013-04-23 09:00:00	MSFT	Stock	30.73	30.82	30.64	30.78	8204709.0
2013-04-23 10:00:00	MSFT	Stock	30.77	30.9	30.74	30.75	8217718.0
2013-04-23 11:00:00	MSFT	Stock	30.755	30.85	30.7	30.828	7158644.0
2013-04-23 12:00:00	MSFT	Stock	30.825	30.84	30.77	30.78	5582403.0
2013-04-23 13:00:00	MSFT	Stock	30.78	30.82	30.38	30.785	8959366.0
2013-04-23 14:00:00	MSFT	Stock	30.785	30.8	30.59	30.66	6054150.0
2013-04-23 15:00:00	MSFT	Stock	30.665	30.71	30.58	30.59	11125520.0
2013-04-23 16:00:00	MSFT	Stock	30.6	30.8	30.56	30.69	2092859.0
2013-04-23 17:00:00	MSFT	Stock	30.63	30.75	30.6	30.62	260641.0
2013-04-23 18:00:00	MSFT	Stock	30.6	30.66	30.6	30.63	73467.0
2013-04-23 19:00:00	MSFT	Stock	30.65	30.65	30.62	30.62	7500.0
2013-04-23 09:00:00	NVDA	Stock	0.3163	0.3195	0.3163	0.3188	30307120.0
2013-04-23 10:00:00	NVDA	Stock	0.319	0.3215	0.3181	0.3213	64675680.0
2013-04-23 11:00:00	NVDA	Stock	0.3215	0.325	0.3213	0.3243	57250880.0
2013-04-23 12:00:00	NVDA	Stock	0.3244	0.3263	0.3238	0.3245	36852040.0
2013-04-23 13:00:00	NVDA	Stock	0.3245	0.325	0.3201	0.323	61741120.0
2013-04-23 14:00:00	NVDA	Stock	0.323	0.3233	0.321	0.3231	35614080.0
2013-04-23 15:00:00	NVDA	Stock	0.323	0.3243	0.3228	0.323	79078760.0
2013-04-23 16:00:00	NVDA	Stock	0.3228	0.324	0.3225	0.3233	3422800.0
2013-04-23 17:00:00	NVDA	Stock	0.3233	0.3233	0.3233	0.3233	7000.0
2013-04-23 18:00:00	NVDA	Stock	0.3213	0.3213	0.3213	0.3213	46000.0
2013-04-23 04:00:00	AMZN	Stock	13.1495	13.1495	13.1395	13.1395	4000.0
2013-04-23 06:00:00	AMZN	Stock	13.1625	13.1625	13.1625	13.1625	2000.0
2013-04-23 08:00:00	AMZN	Stock	13.225	13.225	13.19	13.199	16000.0
2013-04-23 09:00:00	AMZN	Stock	13.1985	13.4145	13.1975	13.3175	8414700.0
2013-04-23 10:00:00	AMZN	Stock	13.3225	13.432	13.3175	13.3915	6967900.0
2013-04-23 11:00:00	AMZN	Stock	13.3975	13.455	13.3735	13.447	4224880.0
2013-04-23 12:00:00	AMZN	Stock	13.447	13.4935	13.4425	13.4675	4183560.0
2013-04-23 13:00:00	AMZN	Stock	13.4695	13.488	13.3042	13.431	6202260.0
2013-04-23 14:00:00	AMZN	Stock	13.429	13.4365	13.3665	13.4233	5046160.0

> showing 50 of 45,559 rows — these rows as CSV

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