PREVIEW / stock_1hour / 2016-06-28

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-28.parquet
  size:    1.0 MB
  rows:    48,996
  symbols: 3,278

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-28 04:00:00	AAPL	Stock	23.1375	23.2625	23.1375	23.2225	12540.0
2016-06-28 05:00:00	AAPL	Stock	23.2225	23.2625	23.2	23.25	12504.0
2016-06-28 06:00:00	AAPL	Stock	23.2525	23.3225	23.2375	23.2375	37624.0
2016-06-28 07:00:00	AAPL	Stock	23.2475	23.2625	23.2025	23.2475	92024.0
2016-06-28 08:00:00	AAPL	Stock	23.25	23.33	23.2125	23.2875	872760.0
2016-06-28 09:00:00	AAPL	Stock	23.2825	23.3025	23.13	23.225	26092764.0
2016-06-28 10:00:00	AAPL	Stock	23.2275	23.24	23.105	23.1275	21439972.0
2016-06-28 11:00:00	AAPL	Stock	23.125	23.15	23.035	23.135	17303192.0
2016-06-28 12:00:00	AAPL	Stock	23.1375	23.1825	23.09	23.1812	12788420.0
2016-06-28 13:00:00	AAPL	Stock	23.18	23.22	23.12	23.2035	13132296.0
2016-06-28 14:00:00	AAPL	Stock	23.2025	23.32	23.1625	23.29	16730020.0
2016-06-28 15:00:00	AAPL	Stock	23.2922	23.415	23.275	23.3975	27557744.0
2016-06-28 16:00:00	AAPL	Stock	23.3975	23.435	23.122	23.435	10336676.0
2016-06-28 17:00:00	AAPL	Stock	23.3975	23.435	23.3975	23.4	975928.0
2016-06-28 18:00:00	AAPL	Stock	23.4	23.4	23.37	23.375	43244.0
2016-06-28 19:00:00	AAPL	Stock	23.3925	23.4	23.365	23.395	53676.0
2016-06-28 04:00:00	MSFT	Stock	48.56	49.0	48.56	48.9	2000.0
2016-06-28 05:00:00	MSFT	Stock	49.03	49.03	49.03	49.03	1320.0
2016-06-28 06:00:00	MSFT	Stock	48.96	48.97	48.8	48.96	5149.0
2016-06-28 07:00:00	MSFT	Stock	48.87	48.9	48.8	48.81	15722.0
2016-06-28 08:00:00	MSFT	Stock	48.99	48.99	48.8	48.9	67090.0
2016-06-28 09:00:00	MSFT	Stock	48.9	49.25	48.67	49.14	5194139.0
2016-06-28 10:00:00	MSFT	Stock	49.15	49.4	49.01	49.14	5069317.0
2016-06-28 11:00:00	MSFT	Stock	49.14	49.21	48.92	49.145	3332814.0
2016-06-28 12:00:00	MSFT	Stock	49.15	49.37	49.01	49.365	6155877.0
2016-06-28 13:00:00	MSFT	Stock	49.37	49.38	49.11	49.145	2746720.0
2016-06-28 14:00:00	MSFT	Stock	49.143	49.38	48.95	49.295	3019738.0
2016-06-28 15:00:00	MSFT	Stock	49.3	49.47	49.24	49.44	5840305.0
2016-06-28 16:00:00	MSFT	Stock	49.44	49.47	49.155	49.47	3616633.0
2016-06-28 17:00:00	MSFT	Stock	49.44	49.49	49.44	49.44	61594.0
2016-06-28 18:00:00	MSFT	Stock	49.43	49.45	49.43	49.44	3050.0
2016-06-28 19:00:00	MSFT	Stock	49.44	49.44	49.43	49.43	1944.0
2016-06-28 07:00:00	NVDA	Stock	1.16	1.16	1.1525	1.1525	32000.0
2016-06-28 08:00:00	NVDA	Stock	1.147	1.1575	1.1438	1.1525	823200.0
2016-06-28 09:00:00	NVDA	Stock	1.1525	1.1588	1.1355	1.151	61597600.0
2016-06-28 10:00:00	NVDA	Stock	1.151	1.1523	1.1422	1.1449	59974280.0
2016-06-28 11:00:00	NVDA	Stock	1.1448	1.1458	1.1318	1.1428	63213880.0
2016-06-28 12:00:00	NVDA	Stock	1.1428	1.1469	1.142	1.1465	26292720.0
2016-06-28 13:00:00	NVDA	Stock	1.1465	1.147	1.1408	1.1434	34193320.0
2016-06-28 14:00:00	NVDA	Stock	1.1434	1.1505	1.138	1.1493	37004400.0
2016-06-28 15:00:00	NVDA	Stock	1.1493	1.1498	1.143	1.1473	57317160.0
2016-06-28 16:00:00	NVDA	Stock	1.1475	1.1493	1.1465	1.1475	14275920.0
2016-06-28 17:00:00	NVDA	Stock	1.1475	1.1482	1.145	1.1482	207720.0
2016-06-28 18:00:00	NVDA	Stock	1.1482	1.15	1.1475	1.15	412000.0
2016-06-28 06:00:00	AMZN	Stock	34.875	34.875	34.85	34.8625	12000.0
2016-06-28 07:00:00	AMZN	Stock	34.8995	35.015	34.8995	35.015	71440.0
2016-06-28 08:00:00	AMZN	Stock	35.0	35.05	34.875	35.0	937480.0
2016-06-28 09:00:00	AMZN	Stock	35.0165	35.2416	34.9086	35.1844	13516280.0
2016-06-28 10:00:00	AMZN	Stock	35.194	35.3073	35.065	35.2235	12863200.0
2016-06-28 11:00:00	AMZN	Stock	35.2261	35.2969	35.15	35.2794	7146880.0

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

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