PREVIEW / stock_1hour / 2013-05-24

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-24.parquet
  size:    973 KB
  rows:    45,317
  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
2013-05-24 05:00:00	AAPL	Stock	15.8246	15.8246	15.8246	15.8246	3864.0
2013-05-24 06:00:00	AAPL	Stock	15.7907	15.7907	15.7714	15.7714	23464.0
2013-05-24 07:00:00	AAPL	Stock	15.7857	15.8929	15.75	15.8929	244972.0
2013-05-24 08:00:00	AAPL	Stock	15.8593	15.8929	15.7411	15.7918	2030924.0
2013-05-24 09:00:00	AAPL	Stock	15.7875	15.9164	15.7271	15.8414	55318004.0
2013-05-24 10:00:00	AAPL	Stock	15.8386	15.9039	15.8011	15.8929	57674624.0
2013-05-24 11:00:00	AAPL	Stock	15.8929	15.905	15.8407	15.8801	39564308.0
2013-05-24 12:00:00	AAPL	Stock	15.8814	15.8939	15.8296	15.8382	20228544.0
2013-05-24 13:00:00	AAPL	Stock	15.8389	15.8614	15.8179	15.8375	18552072.0
2013-05-24 14:00:00	AAPL	Stock	15.8375	15.8671	15.8246	15.8539	18658108.0
2013-05-24 15:00:00	AAPL	Stock	15.8571	15.8996	15.8398	15.8982	40206600.0
2013-05-24 16:00:00	AAPL	Stock	15.8982	15.8982	15.8599	15.8943	17273088.0
2013-05-24 17:00:00	AAPL	Stock	15.8936	15.8968	15.8929	15.8954	575764.0
2013-05-24 18:00:00	AAPL	Stock	15.8961	15.8982	15.8929	15.8961	66080.0
2013-05-24 19:00:00	AAPL	Stock	15.8961	15.8979	15.8929	15.8979	213612.0
2013-05-24 05:00:00	MSFT	Stock	34.21	34.21	34.21	34.21	100.0
2013-05-24 07:00:00	MSFT	Stock	34.01	34.01	33.94	34.0	5200.0
2013-05-24 08:00:00	MSFT	Stock	34.08	34.08	34.0	34.0	14950.0
2013-05-24 09:00:00	MSFT	Stock	34.0	34.12	33.9	34.05	4757667.0
2013-05-24 10:00:00	MSFT	Stock	34.055	34.18	34.01	34.17	6054545.0
2013-05-24 11:00:00	MSFT	Stock	34.17	34.26	34.06	34.21	4516983.0
2013-05-24 12:00:00	MSFT	Stock	34.21	34.22	34.145	34.16	2452668.0
2013-05-24 13:00:00	MSFT	Stock	34.165	34.25	34.15	34.186	2316095.0
2013-05-24 14:00:00	MSFT	Stock	34.185	34.25	34.14	34.16	3129309.0
2013-05-24 15:00:00	MSFT	Stock	34.17	34.28	34.06	34.27	5766154.0
2013-05-24 16:00:00	MSFT	Stock	34.27	34.29	34.13	34.161	2070787.0
2013-05-24 17:00:00	MSFT	Stock	34.15	34.24	34.15	34.24	1200.0
2013-05-24 19:00:00	MSFT	Stock	34.23	34.23	34.23	34.23	1500.0
2013-05-24 09:00:00	NVDA	Stock	0.3638	0.3648	0.3608	0.3608	26285800.0
2013-05-24 10:00:00	NVDA	Stock	0.3608	0.363	0.3595	0.362	36403680.0
2013-05-24 11:00:00	NVDA	Stock	0.3622	0.3625	0.3608	0.362	20297440.0
2013-05-24 12:00:00	NVDA	Stock	0.362	0.3638	0.3618	0.3638	22224840.0
2013-05-24 13:00:00	NVDA	Stock	0.3635	0.3652	0.3633	0.3645	18269320.0
2013-05-24 14:00:00	NVDA	Stock	0.3645	0.3665	0.3645	0.366	26191520.0
2013-05-24 15:00:00	NVDA	Stock	0.3661	0.3668	0.363	0.3635	83001920.0
2013-05-24 16:00:00	NVDA	Stock	0.3638	0.3658	0.3628	0.3658	49550520.0
2013-05-24 05:00:00	AMZN	Stock	13.09	13.09	13.09	13.09	2000.0
2013-05-24 06:00:00	AMZN	Stock	13.065	13.0695	13.065	13.065	8000.0
2013-05-24 07:00:00	AMZN	Stock	13.0295	13.0295	13.0295	13.0295	4000.0
2013-05-24 08:00:00	AMZN	Stock	13.0505	13.0505	13.0505	13.0505	12000.0
2013-05-24 09:00:00	AMZN	Stock	13.05	13.075	12.927	12.987	4714540.0
2013-05-24 10:00:00	AMZN	Stock	12.9836	13.024	12.917	13.013	5927780.0
2013-05-24 11:00:00	AMZN	Stock	13.011	13.033	12.9688	12.973	3659340.0
2013-05-24 12:00:00	AMZN	Stock	12.9763	12.995	12.928	12.9463	3558500.0
2013-05-24 13:00:00	AMZN	Stock	12.949	12.985	12.94	12.985	4166760.0
2013-05-24 14:00:00	AMZN	Stock	12.9855	13.0425	12.9725	13.038	3166220.0
2013-05-24 15:00:00	AMZN	Stock	13.043	13.0965	13.018	13.0905	6697100.0
2013-05-24 16:00:00	AMZN	Stock	13.087	13.1405	12.9949	13.0536	1798680.0
2013-05-24 17:00:00	AMZN	Stock	13.1005	13.121	13.0975	13.121	11400.0
2013-05-24 19:00:00	AMZN	Stock	13.137	13.137	13.137	13.137	2500.0

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

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