PREVIEW / stock_1hour / 2014-08-22

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-22.parquet
  size:    1.0 MB
  rows:    47,463
  symbols: 3,554

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-08-22 04:00:00	AAPL	Stock	25.1525	25.1525	25.1525	25.1525	400.0
2014-08-22 05:00:00	AAPL	Stock	25.165	25.17	25.025	25.0975	48264.0
2014-08-22 06:00:00	AAPL	Stock	25.0925	25.0925	25.025	25.05	52604.0
2014-08-22 07:00:00	AAPL	Stock	25.0375	25.09	25.0375	25.0625	204112.0
2014-08-22 08:00:00	AAPL	Stock	25.0675	25.145	25.035	25.075	654360.0
2014-08-22 09:00:00	AAPL	Stock	25.075	25.3162	25.0475	25.22	23684548.0
2014-08-22 10:00:00	AAPL	Stock	25.2175	25.31	25.1525	25.2425	34744516.0
2014-08-22 11:00:00	AAPL	Stock	25.2425	25.3518	25.2125	25.3375	24886228.0
2014-08-22 12:00:00	AAPL	Stock	25.3382	25.3675	25.2925	25.3288	12154936.0
2014-08-22 13:00:00	AAPL	Stock	25.3275	25.335	25.245	25.2888	18191944.0
2014-08-22 14:00:00	AAPL	Stock	25.2888	25.31	25.2475	25.3	15812856.0
2014-08-22 15:00:00	AAPL	Stock	25.3	25.35	25.28	25.33	28056444.0
2014-08-22 16:00:00	AAPL	Stock	25.3275	25.3775	25.0725	25.37	6986152.0
2014-08-22 17:00:00	AAPL	Stock	25.37	25.37	25.3275	25.35	639328.0
2014-08-22 18:00:00	AAPL	Stock	25.35	25.3675	25.3275	25.3625	199376.0
2014-08-22 19:00:00	AAPL	Stock	25.3625	25.365	25.3525	25.3625	168872.0
2014-08-22 08:00:00	MSFT	Stock	45.07	45.23	45.07	45.2	2458.0
2014-08-22 09:00:00	MSFT	Stock	45.17	45.47	45.16	45.31	3709059.0
2014-08-22 10:00:00	MSFT	Stock	45.31	45.35	45.08	45.15	3407013.0
2014-08-22 11:00:00	MSFT	Stock	45.15	45.39	45.115	45.265	2304071.0
2014-08-22 12:00:00	MSFT	Stock	45.27	45.31	45.21	45.22	1087344.0
2014-08-22 13:00:00	MSFT	Stock	45.22	45.23	45.13	45.22	1207152.0
2014-08-22 14:00:00	MSFT	Stock	45.225	45.23	45.11	45.16	1026386.0
2014-08-22 15:00:00	MSFT	Stock	45.16	45.27	45.07	45.16	2528685.0
2014-08-22 16:00:00	MSFT	Stock	45.16	45.229	45.147	45.16	2058966.0
2014-08-22 17:00:00	MSFT	Stock	45.16	45.16	45.13	45.13	1488.0
2014-08-22 19:00:00	MSFT	Stock	45.1	45.21	45.1	45.21	258.0
2014-08-22 05:00:00	NVDA	Stock	0.475	0.475	0.475	0.475	4000.0
2014-08-22 09:00:00	NVDA	Stock	0.4763	0.4788	0.4732	0.4785	25665440.0
2014-08-22 10:00:00	NVDA	Stock	0.4785	0.481	0.4776	0.4796	49879040.0
2014-08-22 11:00:00	NVDA	Stock	0.4795	0.4803	0.479	0.4793	21729040.0
2014-08-22 12:00:00	NVDA	Stock	0.4793	0.4795	0.477	0.479	19398840.0
2014-08-22 13:00:00	NVDA	Stock	0.479	0.4793	0.4775	0.4779	19800840.0
2014-08-22 14:00:00	NVDA	Stock	0.4779	0.4785	0.4763	0.4782	46675640.0
2014-08-22 15:00:00	NVDA	Stock	0.4782	0.4793	0.4763	0.4771	47382280.0
2014-08-22 16:00:00	NVDA	Stock	0.477	0.4779	0.477	0.477	14278280.0
2014-08-22 08:00:00	AMZN	Stock	16.6455	16.6455	16.63	16.63	49760.0
2014-08-22 09:00:00	AMZN	Stock	16.6285	16.704	16.585	16.6075	5857700.0
2014-08-22 10:00:00	AMZN	Stock	16.5995	16.6745	16.5655	16.5785	5922040.0
2014-08-22 11:00:00	AMZN	Stock	16.577	16.5945	16.54	16.578	6572240.0
2014-08-22 12:00:00	AMZN	Stock	16.5795	16.6125	16.5595	16.595	3062200.0
2014-08-22 13:00:00	AMZN	Stock	16.598	16.6265	16.5915	16.5965	2814660.0
2014-08-22 14:00:00	AMZN	Stock	16.5965	16.6	16.564	16.595	4115700.0
2014-08-22 15:00:00	AMZN	Stock	16.596	16.6365	16.564	16.5795	9175280.0
2014-08-22 16:00:00	AMZN	Stock	16.5795	16.604	16.577	16.5795	1985400.0
2014-08-22 18:00:00	AMZN	Stock	16.5955	16.5955	16.5795	16.5795	21240.0
2014-08-22 19:00:00	AMZN	Stock	16.5975	16.5975	16.5925	16.5925	12000.0
2014-08-22 07:00:00	GOOGL	Stock	29.5495	29.5495	29.5495	29.5495	2000.0
2014-08-22 08:00:00	GOOGL	Stock	29.5205	29.5205	29.5205	29.5205	2000.0
2014-08-22 09:00:00	GOOGL	Stock	29.5615	29.7	29.49	29.6035	2559180.0

> showing 50 of 47,463 rows — these rows as CSV

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