PREVIEW / stock_1hour / 2014-08-21

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-21.parquet
  size:    1.0 MB
  rows:    48,190
  symbols: 3,581

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-21 04:00:00	AAPL	Stock	25.12	25.1275	25.1025	25.11	58760.0
2014-08-21 05:00:00	AAPL	Stock	25.11	25.125	25.1025	25.125	15780.0
2014-08-21 06:00:00	AAPL	Stock	25.1325	25.155	25.13	25.1525	34000.0
2014-08-21 07:00:00	AAPL	Stock	25.1375	25.155	25.115	25.115	142292.0
2014-08-21 08:00:00	AAPL	Stock	25.1225	25.17	25.09	25.17	715440.0
2014-08-21 09:00:00	AAPL	Stock	25.165	25.195	25.0875	25.1538	21201072.0
2014-08-21 10:00:00	AAPL	Stock	25.155	25.16	25.0275	25.1097	24232632.0
2014-08-21 11:00:00	AAPL	Stock	25.11	25.1368	25.085	25.1115	12624840.0
2014-08-21 12:00:00	AAPL	Stock	25.11	25.1375	25.0875	25.1175	10499892.0
2014-08-21 13:00:00	AAPL	Stock	25.1175	25.1675	25.1125	25.1585	10450748.0
2014-08-21 14:00:00	AAPL	Stock	25.1588	25.235	25.155	25.2075	14447328.0
2014-08-21 15:00:00	AAPL	Stock	25.2087	25.2125	25.1175	25.1475	19215184.0
2014-08-21 16:00:00	AAPL	Stock	25.145	25.16	20.7615	25.145	9813480.0
2014-08-21 17:00:00	AAPL	Stock	25.1475	25.15	25.1375	25.14	122528.0
2014-08-21 18:00:00	AAPL	Stock	25.14	25.15	25.13	25.1425	231940.0
2014-08-21 19:00:00	AAPL	Stock	25.1425	25.16	25.1425	25.1525	92040.0
2014-08-21 08:00:00	MSFT	Stock	45.12	45.12	44.97	44.97	1700.0
2014-08-21 09:00:00	MSFT	Stock	45.0	45.25	44.83	45.16	3792920.0
2014-08-21 10:00:00	MSFT	Stock	45.16	45.18	44.995	45.06	3117548.0
2014-08-21 11:00:00	MSFT	Stock	45.06	45.24	45.0	45.23	2328565.0
2014-08-21 12:00:00	MSFT	Stock	45.22	45.24	45.1	45.13	1805654.0
2014-08-21 13:00:00	MSFT	Stock	45.13	45.18	45.1	45.128	1035543.0
2014-08-21 14:00:00	MSFT	Stock	45.13	45.17	45.09	45.14	1486428.0
2014-08-21 15:00:00	MSFT	Stock	45.145	45.23	45.12	45.23	4066235.0
2014-08-21 16:00:00	MSFT	Stock	45.22	45.226	45.095	45.19	3259730.0
2014-08-21 17:00:00	MSFT	Stock	45.178	45.211	45.178	45.21	14370.0
2014-08-21 18:00:00	MSFT	Stock	45.22	45.22	45.19	45.19	12033.0
2014-08-21 19:00:00	MSFT	Stock	45.22	45.22	45.19	45.19	1347.0
2014-08-21 09:00:00	NVDA	Stock	0.4795	0.4825	0.4795	0.4812	15576480.0
2014-08-21 10:00:00	NVDA	Stock	0.481	0.4825	0.479	0.4794	32949640.0
2014-08-21 11:00:00	NVDA	Stock	0.4795	0.4798	0.4765	0.4765	39542920.0
2014-08-21 12:00:00	NVDA	Stock	0.4765	0.4785	0.4765	0.4776	25690120.0
2014-08-21 13:00:00	NVDA	Stock	0.4778	0.4782	0.477	0.4771	20826960.0
2014-08-21 14:00:00	NVDA	Stock	0.4771	0.479	0.477	0.4789	19146680.0
2014-08-21 15:00:00	NVDA	Stock	0.479	0.4795	0.476	0.4765	69922160.0
2014-08-21 16:00:00	NVDA	Stock	0.4768	0.478	0.4768	0.4769	4376560.0
2014-08-21 17:00:00	NVDA	Stock	0.4766	0.4766	0.4766	0.4766	40200.0
2014-08-21 07:00:00	AMZN	Stock	16.789	16.841	16.789	16.837	14000.0
2014-08-21 08:00:00	AMZN	Stock	16.825	16.837	16.825	16.825	78940.0
2014-08-21 09:00:00	AMZN	Stock	16.818	16.8291	16.75	16.772	3466740.0
2014-08-21 10:00:00	AMZN	Stock	16.775	16.7795	16.6855	16.687	6887460.0
2014-08-21 11:00:00	AMZN	Stock	16.6898	16.725	16.631	16.645	4694760.0
2014-08-21 12:00:00	AMZN	Stock	16.6445	16.6615	16.613	16.6304	3707860.0
2014-08-21 13:00:00	AMZN	Stock	16.6305	16.682	16.625	16.6455	3554860.0
2014-08-21 14:00:00	AMZN	Stock	16.6477	16.6704	16.6387	16.662	2621400.0
2014-08-21 15:00:00	AMZN	Stock	16.6655	16.675	16.6115	16.6455	9791760.0
2014-08-21 16:00:00	AMZN	Stock	16.6455	16.6794	16.6295	16.6794	1994720.0
2014-08-21 17:00:00	AMZN	Stock	16.6422	16.6422	16.6422	16.6422	13420.0
2014-08-21 18:00:00	AMZN	Stock	16.6455	16.6455	16.6415	16.6415	90820.0
2014-08-21 19:00:00	AMZN	Stock	16.6615	16.6615	16.6615	16.6615	2000.0

> showing 50 of 48,190 rows — these rows as CSV

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