PREVIEW / stock_1hour / 2012-09-18

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-09-18.parquet
  size:    941 KB
  rows:    44,480
  symbols: 3,480

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
2012-09-18 04:00:00	AAPL	Stock	25.0286	25.0607	25.0286	25.0607	28000.0
2012-09-18 05:00:00	AAPL	Stock	25.0607	25.0643	25.0268	25.0268	42224.0
2012-09-18 06:00:00	AAPL	Stock	25.0271	25.0521	25.0268	25.0521	43260.0
2012-09-18 07:00:00	AAPL	Stock	25.0586	25.1	25.0357	25.0893	1377404.0
2012-09-18 08:00:00	AAPL	Stock	25.0893	25.0893	24.9286	24.9971	4731496.0
2012-09-18 09:00:00	AAPL	Stock	24.9929	25.0175	24.8721	25.0125	83419000.0
2012-09-18 10:00:00	AAPL	Stock	25.0093	25.0514	24.9371	24.9959	82264756.0
2012-09-18 11:00:00	AAPL	Stock	24.9929	25.0286	24.9775	24.9882	32681796.0
2012-09-18 12:00:00	AAPL	Stock	24.9871	24.9954	24.9182	24.9589	30709616.0
2012-09-18 13:00:00	AAPL	Stock	24.9593	24.9821	24.9375	24.9414	15907276.0
2012-09-18 14:00:00	AAPL	Stock	24.9418	25.0264	24.9411	25.015	36834196.0
2012-09-18 15:00:00	AAPL	Stock	25.0125	25.0832	25.0046	25.0697	70408828.0
2012-09-18 16:00:00	AAPL	Stock	25.0696	25.0786	24.9787	25.0625	7519680.0
2012-09-18 17:00:00	AAPL	Stock	25.0696	25.0696	25.0446	25.0446	499380.0
2012-09-18 18:00:00	AAPL	Stock	25.0429	25.0525	25.0357	25.0489	334628.0
2012-09-18 19:00:00	AAPL	Stock	25.0489	25.05	25.0357	25.0375	400260.0
2012-09-18 04:00:00	MSFT	Stock	31.53	31.53	31.53	31.53	172.0
2012-09-18 06:00:00	MSFT	Stock	31.22	31.3	31.22	31.3	3962.0
2012-09-18 07:00:00	MSFT	Stock	31.2	31.2	31.14	31.14	550.0
2012-09-18 08:00:00	MSFT	Stock	31.13	31.15	31.13	31.15	3800.0
2012-09-18 09:00:00	MSFT	Stock	31.15	31.21	31.03	31.16	4366135.0
2012-09-18 10:00:00	MSFT	Stock	31.16	31.18	31.08	31.17	5063883.0
2012-09-18 11:00:00	MSFT	Stock	31.17	31.2	31.11	31.15	3338311.0
2012-09-18 12:00:00	MSFT	Stock	31.15	31.2	31.13	31.175	2237098.0
2012-09-18 13:00:00	MSFT	Stock	31.18	31.21	31.15	31.173	2080694.0
2012-09-18 14:00:00	MSFT	Stock	31.175	31.2	31.16	31.17	2591817.0
2012-09-18 15:00:00	MSFT	Stock	31.18	31.2	31.12	31.2	5754042.0
2012-09-18 16:00:00	MSFT	Stock	31.17	31.45	31.04	31.09	4713459.0
2012-09-18 17:00:00	MSFT	Stock	31.17	31.175	31.07	31.1	86754.0
2012-09-18 18:00:00	MSFT	Stock	31.1	31.1	31.08	31.1	8374.0
2012-09-18 19:00:00	MSFT	Stock	31.1	31.1	31.07	31.09	9665.0
2012-09-18 04:00:00	NVDA	Stock	0.3362	0.3362	0.3355	0.3355	16000.0
2012-09-18 07:00:00	NVDA	Stock	0.335	0.3353	0.335	0.335	136000.0
2012-09-18 08:00:00	NVDA	Stock	0.335	0.335	0.3325	0.3325	334760.0
2012-09-18 09:00:00	NVDA	Stock	0.3338	0.3396	0.3324	0.3365	66464480.0
2012-09-18 10:00:00	NVDA	Stock	0.3368	0.3375	0.3333	0.3373	63625320.0
2012-09-18 11:00:00	NVDA	Stock	0.3375	0.3415	0.3373	0.3415	44974360.0
2012-09-18 12:00:00	NVDA	Stock	0.3415	0.3428	0.3405	0.3406	44400760.0
2012-09-18 13:00:00	NVDA	Stock	0.3408	0.3413	0.339	0.339	28103840.0
2012-09-18 14:00:00	NVDA	Stock	0.3391	0.3395	0.338	0.3393	33962840.0
2012-09-18 15:00:00	NVDA	Stock	0.3393	0.3395	0.3378	0.339	63133160.0
2012-09-18 16:00:00	NVDA	Stock	0.3388	0.3393	0.3356	0.339	1018600.0
2012-09-18 17:00:00	NVDA	Stock	0.339	0.339	0.339	0.339	25120.0
2012-09-18 19:00:00	NVDA	Stock	0.3365	0.3365	0.3365	0.3365	56000.0
2012-09-18 08:00:00	AMZN	Stock	12.885	12.9125	12.885	12.9	310280.0
2012-09-18 09:00:00	AMZN	Stock	12.9	13.0	12.85	12.998	6727700.0
2012-09-18 10:00:00	AMZN	Stock	12.999	13.025	12.955	12.971	7715920.0
2012-09-18 11:00:00	AMZN	Stock	12.97	13.012	12.9575	12.981	5708940.0
2012-09-18 12:00:00	AMZN	Stock	12.9795	12.9865	12.9095	12.9325	6599320.0
2012-09-18 13:00:00	AMZN	Stock	12.9365	12.9605	12.9255	12.938	3549000.0

> showing 50 of 44,480 rows — these rows as CSV

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