PREVIEW / stock_1hour / 2016-05-25

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-25.parquet
  size:    1.0 MB
  rows:    48,133
  symbols: 3,300

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
2016-05-25 04:00:00	AAPL	Stock	24.6125	24.6925	24.6125	24.6925	31240.0
2016-05-25 05:00:00	AAPL	Stock	24.7225	24.7375	24.675	24.7125	9668.0
2016-05-25 06:00:00	AAPL	Stock	24.7	24.7125	24.665	24.665	50616.0
2016-05-25 07:00:00	AAPL	Stock	24.67	24.675	24.595	24.6125	217248.0
2016-05-25 08:00:00	AAPL	Stock	24.5925	24.675	24.5875	24.6575	509888.0
2016-05-25 09:00:00	AAPL	Stock	24.6525	24.6875	24.5275	24.6475	20830988.0
2016-05-25 10:00:00	AAPL	Stock	24.6475	24.7875	24.635	24.7275	25250076.0
2016-05-25 11:00:00	AAPL	Stock	24.7275	24.7575	24.6475	24.75	14105200.0
2016-05-25 12:00:00	AAPL	Stock	24.7488	24.8725	24.7375	24.8675	14370536.0
2016-05-25 13:00:00	AAPL	Stock	24.8675	24.935	24.8575	24.8825	16636568.0
2016-05-25 14:00:00	AAPL	Stock	24.8838	24.8972	24.825	24.83	13616888.0
2016-05-25 15:00:00	AAPL	Stock	24.83	24.9325	24.785	24.9	22445644.0
2016-05-25 16:00:00	AAPL	Stock	24.905	24.905	24.87	24.8975	10900564.0
2016-05-25 17:00:00	AAPL	Stock	24.8975	24.905	24.88	24.8825	1470868.0
2016-05-25 18:00:00	AAPL	Stock	24.8825	24.8975	24.8675	24.875	58580.0
2016-05-25 19:00:00	AAPL	Stock	24.8775	24.89	24.875	24.8875	55816.0
2016-05-25 05:00:00	MSFT	Stock	51.76	51.76	51.76	51.76	2000.0
2016-05-25 06:00:00	MSFT	Stock	51.85	51.85	51.8	51.8	1699.0
2016-05-25 07:00:00	MSFT	Stock	51.84	51.88	51.84	51.87	3430.0
2016-05-25 08:00:00	MSFT	Stock	51.87	52.0	51.82	51.94	36800.0
2016-05-25 09:00:00	MSFT	Stock	51.9	52.2	51.79	52.13	3364231.0
2016-05-25 10:00:00	MSFT	Stock	52.13	52.31	52.065	52.205	3510341.0
2016-05-25 11:00:00	MSFT	Stock	52.21	52.3	52.11	52.18	2628229.0
2016-05-25 12:00:00	MSFT	Stock	52.18	52.35	52.17	52.345	1787636.0
2016-05-25 13:00:00	MSFT	Stock	52.34	52.49	52.315	52.39	2939888.0
2016-05-25 14:00:00	MSFT	Stock	52.39	52.47	52.26	52.27	1897839.0
2016-05-25 15:00:00	MSFT	Stock	52.28	52.37	52.11	52.14	4571005.0
2016-05-25 16:00:00	MSFT	Stock	52.12	52.17	52.1	52.1	1345353.0
2016-05-25 17:00:00	MSFT	Stock	52.15	52.15	52.15	52.15	330.0
2016-05-25 18:00:00	MSFT	Stock	52.12	52.12	52.12	52.12	100.0
2016-05-25 19:00:00	MSFT	Stock	52.12	52.12	52.12	52.12	300.0
2016-05-25 07:00:00	NVDA	Stock	1.1408	1.1458	1.1368	1.1388	170800.0
2016-05-25 08:00:00	NVDA	Stock	1.1413	1.1415	1.1373	1.1373	430960.0
2016-05-25 09:00:00	NVDA	Stock	1.1398	1.1422	1.1308	1.1358	49921840.0
2016-05-25 10:00:00	NVDA	Stock	1.1355	1.1375	1.1265	1.13	66015160.0
2016-05-25 11:00:00	NVDA	Stock	1.1298	1.1328	1.1203	1.1236	65904560.0
2016-05-25 12:00:00	NVDA	Stock	1.1238	1.1262	1.1225	1.1236	45634880.0
2016-05-25 13:00:00	NVDA	Stock	1.1238	1.1345	1.1238	1.13	64957000.0
2016-05-25 14:00:00	NVDA	Stock	1.1299	1.1308	1.1216	1.1224	37859760.0
2016-05-25 15:00:00	NVDA	Stock	1.1225	1.13	1.1223	1.1294	63176040.0
2016-05-25 16:00:00	NVDA	Stock	1.1292	1.13	1.1292	1.13	3392760.0
2016-05-25 17:00:00	NVDA	Stock	1.1292	1.1292	1.1275	1.1292	424000.0
2016-05-25 18:00:00	NVDA	Stock	1.1275	1.13	1.1275	1.13	76000.0
2016-05-25 19:00:00	NVDA	Stock	1.1275	1.1288	1.1275	1.1288	28000.0
2016-05-25 05:00:00	AMZN	Stock	35.4	35.4	35.4	35.4	3940.0
2016-05-25 06:00:00	AMZN	Stock	35.39	35.39	35.39	35.39	2000.0
2016-05-25 07:00:00	AMZN	Stock	35.35	35.3875	35.325	35.325	112360.0
2016-05-25 08:00:00	AMZN	Stock	35.3495	35.3745	35.14	35.3495	222360.0
2016-05-25 09:00:00	AMZN	Stock	35.3035	35.543	35.2758	35.495	12340540.0
2016-05-25 10:00:00	AMZN	Stock	35.4835	35.5236	35.3355	35.416	9443980.0

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

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