PREVIEW / stock_1hour / 2016-06-14

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-14.parquet
  size:    1.0 MB
  rows:    48,720
  symbols: 3,292

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-06-14 04:00:00	AAPL	Stock	24.235	24.2375	24.175	24.1775	4360.0
2016-06-14 05:00:00	AAPL	Stock	24.175	24.19	24.175	24.19	7868.0
2016-06-14 06:00:00	AAPL	Stock	24.1925	24.255	24.1925	24.2375	8072.0
2016-06-14 07:00:00	AAPL	Stock	24.25	24.295	24.2375	24.275	33772.0
2016-06-14 08:00:00	AAPL	Stock	24.275	24.3825	24.25	24.3825	230804.0
2016-06-14 09:00:00	AAPL	Stock	24.3875	24.6188	24.33	24.5832	19085000.0
2016-06-14 10:00:00	AAPL	Stock	24.5825	24.6075	24.2375	24.2575	24459624.0
2016-06-14 11:00:00	AAPL	Stock	24.2575	24.3	24.1875	24.215	18198752.0
2016-06-14 12:00:00	AAPL	Stock	24.215	24.37	24.2138	24.3225	11511880.0
2016-06-14 13:00:00	AAPL	Stock	24.3225	24.3425	24.2175	24.2388	9225852.0
2016-06-14 14:00:00	AAPL	Stock	24.2375	24.3275	24.23	24.25	9664024.0
2016-06-14 15:00:00	AAPL	Stock	24.25	24.3975	24.235	24.365	19212740.0
2016-06-14 16:00:00	AAPL	Stock	24.365	24.37	24.34	24.3625	6211772.0
2016-06-14 17:00:00	AAPL	Stock	24.36	24.36	24.335	24.35	68508.0
2016-06-14 18:00:00	AAPL	Stock	24.35	24.35	24.325	24.3375	16880.0
2016-06-14 19:00:00	AAPL	Stock	24.3375	24.35	24.3325	24.3375	30332.0
2016-06-14 04:00:00	MSFT	Stock	50.13	50.13	50.07	50.07	500.0
2016-06-14 05:00:00	MSFT	Stock	50.13	50.13	50.13	50.13	300.0
2016-06-14 06:00:00	MSFT	Stock	50.0	50.0	50.0	50.0	1192.0
2016-06-14 07:00:00	MSFT	Stock	49.95	49.98	49.8	49.98	9210.0
2016-06-14 08:00:00	MSFT	Stock	49.99	50.13	49.95	50.13	30717.0
2016-06-14 09:00:00	MSFT	Stock	50.13	50.14	49.872	49.97	5704890.0
2016-06-14 10:00:00	MSFT	Stock	49.97	50.02	49.6	49.655	7160576.0
2016-06-14 11:00:00	MSFT	Stock	49.66	49.78	49.57	49.695	5115433.0
2016-06-14 12:00:00	MSFT	Stock	49.69	49.99	49.65	49.827	3505838.0
2016-06-14 13:00:00	MSFT	Stock	49.825	49.91	49.73	49.805	2958059.0
2016-06-14 14:00:00	MSFT	Stock	49.8	49.91	49.68	49.7	3576300.0
2016-06-14 15:00:00	MSFT	Stock	49.7	49.84	49.635	49.82	10446017.0
2016-06-14 16:00:00	MSFT	Stock	49.83	49.83	49.78	49.78	1818831.0
2016-06-14 17:00:00	MSFT	Stock	49.78	49.83	49.78	49.83	400.0
2016-06-14 18:00:00	MSFT	Stock	49.83	49.83	49.78	49.81	3154.0
2016-06-14 19:00:00	MSFT	Stock	49.79	49.79	49.79	49.79	2023.0
2016-06-14 08:00:00	NVDA	Stock	1.1662	1.1705	1.1662	1.1705	35640.0
2016-06-14 09:00:00	NVDA	Stock	1.1685	1.1741	1.1602	1.173	33231440.0
2016-06-14 10:00:00	NVDA	Stock	1.1733	1.1775	1.1548	1.157	63546880.0
2016-06-14 11:00:00	NVDA	Stock	1.157	1.161	1.1539	1.1594	34021880.0
2016-06-14 12:00:00	NVDA	Stock	1.1595	1.1653	1.158	1.165	18211520.0
2016-06-14 13:00:00	NVDA	Stock	1.165	1.1702	1.1645	1.1668	20837160.0
2016-06-14 14:00:00	NVDA	Stock	1.1665	1.1715	1.1662	1.1695	39633400.0
2016-06-14 15:00:00	NVDA	Stock	1.1695	1.1749	1.1688	1.172	50183160.0
2016-06-14 16:00:00	NVDA	Stock	1.172	1.1745	1.172	1.172	12317600.0
2016-06-14 17:00:00	NVDA	Stock	1.171	1.172	1.171	1.172	408720.0
2016-06-14 18:00:00	NVDA	Stock	1.1735	1.1735	1.1735	1.1735	46640.0
2016-06-14 19:00:00	NVDA	Stock	1.172	1.172	1.172	1.172	4000.0
2016-06-14 04:00:00	AMZN	Stock	35.588	35.588	35.5505	35.5505	12000.0
2016-06-14 05:00:00	AMZN	Stock	35.425	35.425	35.425	35.425	4000.0
2016-06-14 06:00:00	AMZN	Stock	35.5145	35.525	35.5	35.525	10000.0
2016-06-14 07:00:00	AMZN	Stock	35.5575	35.681	35.5575	35.681	9600.0
2016-06-14 08:00:00	AMZN	Stock	35.6355	35.75	35.6215	35.75	45560.0
2016-06-14 09:00:00	AMZN	Stock	35.7125	36.021	35.6135	35.9705	7379740.0

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

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