PREVIEW / stock_1hour / 2013-07-31

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-31.parquet
  size:    1019 KB
  rows:    46,720
  symbols: 3,515

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-07-31 04:00:00	AAPL	Stock	16.2096	16.2121	16.2096	16.2121	5600.0
2013-07-31 05:00:00	AAPL	Stock	16.2404	16.2518	16.2404	16.2518	23520.0
2013-07-31 06:00:00	AAPL	Stock	16.2571	16.2571	16.2571	16.2571	30800.0
2013-07-31 07:00:00	AAPL	Stock	16.25	16.3036	16.2286	16.2764	314552.0
2013-07-31 08:00:00	AAPL	Stock	16.2754	16.2821	16.1071	16.2496	1929872.0
2013-07-31 09:00:00	AAPL	Stock	16.2496	16.3336	16.2143	16.2941	40262068.0
2013-07-31 10:00:00	AAPL	Stock	16.2946	16.2986	16.0511	16.1211	79289504.0
2013-07-31 11:00:00	AAPL	Stock	16.1225	16.1857	16.0954	16.1071	26939556.0
2013-07-31 12:00:00	AAPL	Stock	16.1075	16.1511	16.0897	16.1282	16563008.0
2013-07-31 13:00:00	AAPL	Stock	16.1271	16.1696	16.0964	16.1689	17550484.0
2013-07-31 14:00:00	AAPL	Stock	16.1643	16.2833	16.1214	16.2711	42659428.0
2013-07-31 15:00:00	AAPL	Stock	16.2711	16.2721	16.1161	16.1614	48747076.0
2013-07-31 16:00:00	AAPL	Stock	16.1607	16.31	16.1231	16.1754	37861376.0
2013-07-31 17:00:00	AAPL	Stock	16.1775	16.1786	16.1696	16.175	131768.0
2013-07-31 18:00:00	AAPL	Stock	16.17	16.1964	16.17	16.1925	150164.0
2013-07-31 19:00:00	AAPL	Stock	16.1829	16.1968	16.1804	16.1929	255920.0
2013-07-31 08:00:00	MSFT	Stock	31.81	31.89	31.8	31.87	3534.0
2013-07-31 09:00:00	MSFT	Stock	31.78	32.04	31.77	31.83	3728089.0
2013-07-31 10:00:00	MSFT	Stock	31.82	32.05	31.8	31.99	7706902.0
2013-07-31 11:00:00	MSFT	Stock	31.99	32.03	31.92	32.011	4251775.0
2013-07-31 12:00:00	MSFT	Stock	32.01	32.03	31.91	31.918	4787280.0
2013-07-31 13:00:00	MSFT	Stock	31.91	31.97	31.9	31.92	2654611.0
2013-07-31 14:00:00	MSFT	Stock	31.91	31.96	31.75	31.94	6903129.0
2013-07-31 15:00:00	MSFT	Stock	31.94	31.95	31.71	31.83	8510089.0
2013-07-31 16:00:00	MSFT	Stock	31.84	31.985	31.776	31.83	4749406.0
2013-07-31 18:00:00	MSFT	Stock	31.88	31.88	31.83	31.83	880.0
2013-07-31 19:00:00	MSFT	Stock	31.84	31.9	31.84	31.9	1200.0
2013-07-31 04:00:00	NVDA	Stock	0.3588	0.3588	0.3588	0.3588	4000.0
2013-07-31 06:00:00	NVDA	Stock	0.3578	0.3578	0.3578	0.3578	4000.0
2013-07-31 08:00:00	NVDA	Stock	0.3565	0.357	0.3562	0.357	116440.0
2013-07-31 09:00:00	NVDA	Stock	0.3572	0.3618	0.3572	0.3598	33425400.0
2013-07-31 10:00:00	NVDA	Stock	0.3598	0.3625	0.3588	0.362	36433200.0
2013-07-31 11:00:00	NVDA	Stock	0.362	0.362	0.3592	0.3596	19646640.0
2013-07-31 12:00:00	NVDA	Stock	0.3598	0.3612	0.359	0.3612	25478120.0
2013-07-31 13:00:00	NVDA	Stock	0.361	0.3632	0.361	0.3632	18125200.0
2013-07-31 14:00:00	NVDA	Stock	0.363	0.3642	0.3612	0.3642	36482720.0
2013-07-31 15:00:00	NVDA	Stock	0.3642	0.3645	0.3605	0.3608	74148920.0
2013-07-31 16:00:00	NVDA	Stock	0.3608	0.3638	0.3607	0.3638	2192000.0
2013-07-31 04:00:00	AMZN	Stock	15.1255	15.1255	15.1255	15.1255	2000.0
2013-07-31 05:00:00	AMZN	Stock	15.1355	15.1355	15.1355	15.1355	2000.0
2013-07-31 08:00:00	AMZN	Stock	15.128	15.128	15.1255	15.1255	6000.0
2013-07-31 09:00:00	AMZN	Stock	15.183	15.2575	15.13	15.1485	5453260.0
2013-07-31 10:00:00	AMZN	Stock	15.148	15.182	15.0805	15.151	6034360.0
2013-07-31 11:00:00	AMZN	Stock	15.1515	15.156	15.085	15.128	3587520.0
2013-07-31 12:00:00	AMZN	Stock	15.1265	15.1375	15.0755	15.095	3400000.0
2013-07-31 13:00:00	AMZN	Stock	15.0955	15.125	15.095	15.1205	1902920.0
2013-07-31 14:00:00	AMZN	Stock	15.1195	15.2	15.0775	15.1975	4830080.0
2013-07-31 15:00:00	AMZN	Stock	15.199	15.2	15.05	15.0605	8397800.0
2013-07-31 16:00:00	AMZN	Stock	15.061	15.1638	15.0608	15.09	1348260.0
2013-07-31 19:00:00	AMZN	Stock	15.095	15.095	15.095	15.095	4000.0

> showing 50 of 46,720 rows — these rows as CSV

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