PREVIEW / stock_1hour / 2015-05-18

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-05-18.parquet
  size:    1.1 MB
  rows:    48,926
  symbols: 3,502

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
2015-05-18 04:00:00	AAPL	Stock	32.195	32.2	32.175	32.1875	18724.0
2015-05-18 05:00:00	AAPL	Stock	32.175	32.22	32.175	32.215	8176.0
2015-05-18 06:00:00	AAPL	Stock	32.19	32.19	32.0775	32.1	30332.0
2015-05-18 07:00:00	AAPL	Stock	32.1075	32.1275	32.0775	32.1075	76160.0
2015-05-18 08:00:00	AAPL	Stock	32.1025	32.1625	32.005	32.1175	415276.0
2015-05-18 09:00:00	AAPL	Stock	32.1125	32.3875	32.09	32.3075	22494008.0
2015-05-18 10:00:00	AAPL	Stock	32.3125	32.3625	32.1578	32.1948	21319444.0
2015-05-18 11:00:00	AAPL	Stock	32.195	32.635	32.1875	32.567	52956984.0
2015-05-18 12:00:00	AAPL	Stock	32.565	32.62	32.4775	32.59	18650492.0
2015-05-18 13:00:00	AAPL	Stock	32.59	32.68	32.5875	32.63	17847420.0
2015-05-18 14:00:00	AAPL	Stock	32.6325	32.6575	32.57	32.6425	16060220.0
2015-05-18 15:00:00	AAPL	Stock	32.6448	32.6575	32.5325	32.5425	23255900.0
2015-05-18 16:00:00	AAPL	Stock	32.5475	32.56	32.2785	32.54	18658656.0
2015-05-18 17:00:00	AAPL	Stock	32.54	32.5475	32.5025	32.5375	195768.0
2015-05-18 18:00:00	AAPL	Stock	32.5375	32.565	32.5325	32.565	119404.0
2015-05-18 19:00:00	AAPL	Stock	32.565	32.5875	32.5625	32.565	218204.0
2015-05-18 06:00:00	MSFT	Stock	48.28	48.28	48.21	48.23	3100.0
2015-05-18 07:00:00	MSFT	Stock	48.15	48.15	48.1	48.13	2600.0
2015-05-18 08:00:00	MSFT	Stock	48.11	48.18	48.09	48.16	8985.0
2015-05-18 09:00:00	MSFT	Stock	48.16	48.19	47.61	47.82	4235576.0
2015-05-18 10:00:00	MSFT	Stock	47.825	47.86	47.63	47.696	3603108.0
2015-05-18 11:00:00	MSFT	Stock	47.7	47.89	47.66	47.855	2688720.0
2015-05-18 12:00:00	MSFT	Stock	47.855	47.94	47.765	47.923	1982210.0
2015-05-18 13:00:00	MSFT	Stock	47.925	48.02	47.87	47.97	1807933.0
2015-05-18 14:00:00	MSFT	Stock	47.965	48.165	47.963	48.14	2424073.0
2015-05-18 15:00:00	MSFT	Stock	48.15	48.22	48.0	48.0	3710258.0
2015-05-18 16:00:00	MSFT	Stock	48.01	48.08	48.0	48.01	1770531.0
2015-05-18 17:00:00	MSFT	Stock	48.01	48.01	48.01	48.01	600.0
2015-05-18 18:00:00	MSFT	Stock	48.01	48.02	48.01	48.02	1300.0
2015-05-18 19:00:00	MSFT	Stock	48.02	48.16	48.02	48.139	7993.0
2015-05-18 09:00:00	NVDA	Stock	0.536	0.536	0.5287	0.5332	27229680.0
2015-05-18 10:00:00	NVDA	Stock	0.5332	0.535	0.5315	0.5329	31947240.0
2015-05-18 11:00:00	NVDA	Stock	0.533	0.534	0.5325	0.5338	27404040.0
2015-05-18 12:00:00	NVDA	Stock	0.5338	0.5342	0.532	0.533	15094400.0
2015-05-18 13:00:00	NVDA	Stock	0.533	0.533	0.5306	0.5311	21323200.0
2015-05-18 14:00:00	NVDA	Stock	0.5309	0.5318	0.5302	0.5304	22857280.0
2015-05-18 15:00:00	NVDA	Stock	0.5304	0.5325	0.5302	0.5318	45958680.0
2015-05-18 16:00:00	NVDA	Stock	0.5318	0.5318	0.5318	0.5318	120113280.0
2015-05-18 17:00:00	NVDA	Stock	0.5327	0.5327	0.5327	0.5327	8000.0
2015-05-18 06:00:00	AMZN	Stock	21.268	21.284	21.268	21.284	22000.0
2015-05-18 08:00:00	AMZN	Stock	21.253	21.2655	21.232	21.2655	13000.0
2015-05-18 09:00:00	AMZN	Stock	21.26	21.3395	21.16	21.2185	6953040.0
2015-05-18 10:00:00	AMZN	Stock	21.2165	21.3635	21.175	21.3052	4738320.0
2015-05-18 11:00:00	AMZN	Stock	21.31	21.346	21.073	21.1368	10035780.0
2015-05-18 12:00:00	AMZN	Stock	21.1355	21.255	21.0975	21.189	3839400.0
2015-05-18 13:00:00	AMZN	Stock	21.1895	21.244	21.144	21.205	3206300.0
2015-05-18 14:00:00	AMZN	Stock	21.2105	21.309	21.18	21.279	4010340.0
2015-05-18 15:00:00	AMZN	Stock	21.279	21.315	21.2495	21.2615	6727000.0
2015-05-18 16:00:00	AMZN	Stock	21.262	21.262	21.245	21.262	2762440.0
2015-05-18 18:00:00	AMZN	Stock	21.2451	21.2451	21.2451	21.2451	2000.0

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

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