PREVIEW / stock_1hour / 2011-08-30

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-30.parquet
  size:    909 KB
  rows:    43,295
  symbols: 3,514

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
2011-08-30 04:00:00	AAPL	Stock	13.8929	13.8929	13.8682	13.8682	5600.0
2011-08-30 05:00:00	AAPL	Stock	13.8789	13.8789	13.8789	13.8789	2800.0
2011-08-30 06:00:00	AAPL	Stock	13.8743	13.8871	13.8632	13.8871	31976.0
2011-08-30 07:00:00	AAPL	Stock	13.8918	13.8929	13.8664	13.8761	180628.0
2011-08-30 08:00:00	AAPL	Stock	13.8875	13.8875	13.8164	13.8246	2391396.0
2011-08-30 09:00:00	AAPL	Stock	13.8282	13.9204	13.8236	13.8929	41992524.0
2011-08-30 10:00:00	AAPL	Stock	13.8886	13.9029	13.7932	13.8657	78556520.0
2011-08-30 11:00:00	AAPL	Stock	13.8664	13.9943	13.8625	13.9768	67380096.0
2011-08-30 12:00:00	AAPL	Stock	13.9784	13.9818	13.8554	13.8818	44364180.0
2011-08-30 13:00:00	AAPL	Stock	13.8796	13.9107	13.8546	13.8932	39477256.0
2011-08-30 14:00:00	AAPL	Stock	13.8954	13.9496	13.875	13.9175	60772488.0
2011-08-30 15:00:00	AAPL	Stock	13.9198	13.9664	13.9025	13.9271	67246004.0
2011-08-30 16:00:00	AAPL	Stock	13.9279	13.9544	13.8621	13.8621	11449200.0
2011-08-30 17:00:00	AAPL	Stock	13.8646	13.8782	13.8579	13.8621	197484.0
2011-08-30 18:00:00	AAPL	Stock	13.8625	13.9282	13.8618	13.8736	183204.0
2011-08-30 19:00:00	AAPL	Stock	13.8714	13.8768	13.8593	13.8714	359996.0
2011-08-30 05:00:00	MSFT	Stock	25.7	25.7	25.7	25.7	100.0
2011-08-30 06:00:00	MSFT	Stock	25.7	25.7	25.7	25.7	170.0
2011-08-30 07:00:00	MSFT	Stock	25.66	25.66	25.66	25.66	922.0
2011-08-30 08:00:00	MSFT	Stock	25.66	25.85	25.66	25.69	51142.0
2011-08-30 09:00:00	MSFT	Stock	25.7	26.12	25.66	25.97	7687209.0
2011-08-30 10:00:00	MSFT	Stock	25.97	26.175	25.81	26.123	11485477.0
2011-08-30 11:00:00	MSFT	Stock	26.13	26.265	26.1	26.25	6376142.0
2011-08-30 12:00:00	MSFT	Stock	26.25	26.28	26.1	26.19	4925721.0
2011-08-30 13:00:00	MSFT	Stock	26.185	26.34	26.15	26.16	5417486.0
2011-08-30 14:00:00	MSFT	Stock	26.16	26.37	26.11	26.367	7722303.0
2011-08-30 15:00:00	MSFT	Stock	26.365	26.43	26.22	26.24	9884921.0
2011-08-30 16:00:00	MSFT	Stock	26.24	26.399	25.773	26.167	2745149.0
2011-08-30 17:00:00	MSFT	Stock	26.17	26.17	26.1	26.12	14055.0
2011-08-30 18:00:00	MSFT	Stock	26.13	26.23	26.12	26.12	31879.0
2011-08-30 19:00:00	MSFT	Stock	26.12	26.12	26.07	26.09	9438.0
2011-08-30 08:00:00	NVDA	Stock	0.333	0.3333	0.3268	0.33	394400.0
2011-08-30 09:00:00	NVDA	Stock	0.33	0.3418	0.3295	0.3408	98954440.0
2011-08-30 10:00:00	NVDA	Stock	0.3408	0.342	0.3368	0.339	139771000.0
2011-08-30 11:00:00	NVDA	Stock	0.339	0.3425	0.3378	0.3425	85680880.0
2011-08-30 12:00:00	NVDA	Stock	0.3422	0.3438	0.3395	0.34	77765840.0
2011-08-30 13:00:00	NVDA	Stock	0.3401	0.3425	0.339	0.3405	52816640.0
2011-08-30 14:00:00	NVDA	Stock	0.3405	0.3425	0.3395	0.3418	81515240.0
2011-08-30 15:00:00	NVDA	Stock	0.3415	0.3448	0.3406	0.342	103495920.0
2011-08-30 16:00:00	NVDA	Stock	0.342	0.3435	0.3404	0.341	24963120.0
2011-08-30 17:00:00	NVDA	Stock	0.341	0.3418	0.341	0.3418	219200.0
2011-08-30 18:00:00	NVDA	Stock	0.3413	0.3413	0.3413	0.3413	120000.0
2011-08-30 19:00:00	NVDA	Stock	0.3413	0.3413	0.3413	0.3413	56000.0
2011-08-30 04:00:00	AMZN	Stock	10.34	10.34	10.32	10.3345	6000.0
2011-08-30 05:00:00	AMZN	Stock	10.3005	10.3005	10.3005	10.3005	2000.0
2011-08-30 07:00:00	AMZN	Stock	10.282	10.282	10.282	10.282	2000.0
2011-08-30 08:00:00	AMZN	Stock	10.282	10.282	10.2315	10.232	74760.0
2011-08-30 09:00:00	AMZN	Stock	10.2325	10.3756	10.2325	10.295	9661300.0
2011-08-30 10:00:00	AMZN	Stock	10.3	10.325	10.2161	10.3078	15557480.0
2011-08-30 11:00:00	AMZN	Stock	10.3115	10.512	10.2995	10.51	19712700.0

> showing 50 of 43,295 rows — these rows as CSV

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