PREVIEW / stock_1hour / 2011-10-14

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-14.parquet
  size:    899 KB
  rows:    43,026
  symbols: 3,504

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-10-14 04:00:00	AAPL	Stock	14.7268	14.7714	14.7193	14.7679	67760.0
2011-10-14 05:00:00	AAPL	Stock	14.7786	14.8214	14.7736	14.8214	36372.0
2011-10-14 06:00:00	AAPL	Stock	14.8307	14.8689	14.8307	14.8689	21560.0
2011-10-14 07:00:00	AAPL	Stock	14.8893	14.9554	14.8	14.8514	1613836.0
2011-10-14 08:00:00	AAPL	Stock	14.8518	14.9464	14.8214	14.9286	8157772.0
2011-10-14 09:00:00	AAPL	Stock	14.9279	14.9593	14.8396	14.8664	114314704.0
2011-10-14 10:00:00	AAPL	Stock	14.8661	14.9032	14.8311	14.8861	74619412.0
2011-10-14 11:00:00	AAPL	Stock	14.8868	14.9029	14.8425	14.8657	51907156.0
2011-10-14 12:00:00	AAPL	Stock	14.8643	14.9125	14.8532	14.8939	37949156.0
2011-10-14 13:00:00	AAPL	Stock	14.8964	14.9739	14.8943	14.9684	57703072.0
2011-10-14 14:00:00	AAPL	Stock	14.9679	15.01	14.9564	15.0075	68019700.0
2011-10-14 15:00:00	AAPL	Stock	15.0075	15.0714	14.9514	15.0714	121384676.0
2011-10-14 16:00:00	AAPL	Stock	15.0693	15.0818	14.9322	15.0607	29257508.0
2011-10-14 17:00:00	AAPL	Stock	15.0643	15.0661	15.0379	15.0464	1556464.0
2011-10-14 18:00:00	AAPL	Stock	15.0511	15.0714	15.0411	15.0536	662732.0
2011-10-14 19:00:00	AAPL	Stock	15.0489	15.0714	15.0468	15.0714	575848.0
2011-10-14 04:00:00	MSFT	Stock	27.17	27.17	27.17	27.17	1000.0
2011-10-14 07:00:00	MSFT	Stock	27.23	27.29	27.23	27.27	4100.0
2011-10-14 08:00:00	MSFT	Stock	27.27	27.44	27.23	27.33	97385.0
2011-10-14 09:00:00	MSFT	Stock	27.34	27.5	27.18	27.34	6764408.0
2011-10-14 10:00:00	MSFT	Stock	27.34	27.48	27.27	27.378	5643050.0
2011-10-14 11:00:00	MSFT	Stock	27.374	27.42	27.06	27.1	5810244.0
2011-10-14 12:00:00	MSFT	Stock	27.09	27.16	27.02	27.141	4412701.0
2011-10-14 13:00:00	MSFT	Stock	27.145	27.26	27.14	27.2	5549631.0
2011-10-14 14:00:00	MSFT	Stock	27.2	27.24	27.16	27.22	4136594.0
2011-10-14 15:00:00	MSFT	Stock	27.22	27.27	27.17	27.27	12611603.0
2011-10-14 16:00:00	MSFT	Stock	27.27	27.374	27.223	27.374	4169325.0
2011-10-14 17:00:00	MSFT	Stock	27.27	27.3	27.27	27.28	3977.0
2011-10-14 18:00:00	MSFT	Stock	27.27	27.28	27.27	27.28	31036.0
2011-10-14 19:00:00	MSFT	Stock	27.28	27.3	27.28	27.3	1174.0
2011-10-14 07:00:00	NVDA	Stock	0.3948	0.3948	0.394	0.394	25000.0
2011-10-14 08:00:00	NVDA	Stock	0.3925	0.3962	0.391	0.3958	643200.0
2011-10-14 09:00:00	NVDA	Stock	0.3953	0.3973	0.3902	0.3955	110158960.0
2011-10-14 10:00:00	NVDA	Stock	0.3955	0.397	0.3908	0.392	182597240.0
2011-10-14 11:00:00	NVDA	Stock	0.3918	0.392	0.3835	0.3855	118065160.0
2011-10-14 12:00:00	NVDA	Stock	0.3855	0.3885	0.3845	0.3878	42788720.0
2011-10-14 13:00:00	NVDA	Stock	0.3878	0.3918	0.3878	0.3909	54572880.0
2011-10-14 14:00:00	NVDA	Stock	0.3909	0.3918	0.3885	0.3913	51649360.0
2011-10-14 15:00:00	NVDA	Stock	0.3911	0.393	0.3893	0.393	117760400.0
2011-10-14 16:00:00	NVDA	Stock	0.393	0.3931	0.3865	0.393	12826880.0
2011-10-14 18:00:00	NVDA	Stock	0.3913	0.3913	0.3913	0.3913	143000.0
2011-10-14 19:00:00	NVDA	Stock	0.3922	0.3922	0.3905	0.3905	237200.0
2011-10-14 07:00:00	AMZN	Stock	11.9	11.975	11.9	11.96	30800.0
2011-10-14 08:00:00	AMZN	Stock	11.95	12.01	11.95	11.996	444400.0
2011-10-14 09:00:00	AMZN	Stock	12.0	12.1625	11.995	12.071	26701400.0
2011-10-14 10:00:00	AMZN	Stock	12.0708	12.0995	12.029	12.075	12604800.0
2011-10-14 11:00:00	AMZN	Stock	12.075	12.0975	12.0205	12.0935	8432980.0
2011-10-14 12:00:00	AMZN	Stock	12.09	12.172	12.0705	12.1294	13090400.0
2011-10-14 13:00:00	AMZN	Stock	12.129	12.157	12.0825	12.142	7820180.0
2011-10-14 14:00:00	AMZN	Stock	12.142	12.2335	12.136	12.2125	14663880.0

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

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