PREVIEW / stock_1hour / 2018-08-01

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-01.parquet
  size:    1.1 MB
  rows:    49,357
  symbols: 2,799

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
2018-08-01 04:00:00	AAPL	Stock	49.3225	49.4725	49.1775	49.25	168636.0
2018-08-01 05:00:00	AAPL	Stock	49.19	49.3	49.19	49.2375	67972.0
2018-08-01 06:00:00	AAPL	Stock	49.2175	49.45	49.1625	49.375	257332.0
2018-08-01 07:00:00	AAPL	Stock	49.3875	49.745	49.375	49.7125	1055572.0
2018-08-01 08:00:00	AAPL	Stock	49.425	49.85	49.375	49.6875	3931772.0
2018-08-01 09:00:00	AAPL	Stock	49.6825	49.8975	49.3275	49.6825	48286088.0
2018-08-01 10:00:00	AAPL	Stock	49.6825	50.33	49.48	50.1125	60587232.0
2018-08-01 11:00:00	AAPL	Stock	50.114	50.225	49.8175	49.9825	31905864.0
2018-08-01 12:00:00	AAPL	Stock	49.9825	50.1925	49.9345	50.0388	18192768.0
2018-08-01 13:00:00	AAPL	Stock	50.0375	50.25	49.9625	50.02	13210700.0
2018-08-01 14:00:00	AAPL	Stock	50.025	50.1375	49.8925	50.0525	14739816.0
2018-08-01 15:00:00	AAPL	Stock	50.05	50.44	50.005	50.405	37669784.0
2018-08-01 16:00:00	AAPL	Stock	50.405	50.48	50.2728	50.41	12796092.0
2018-08-01 17:00:00	AAPL	Stock	50.4125	50.45	50.375	50.4175	236552.0
2018-08-01 18:00:00	AAPL	Stock	50.425	50.4375	50.38	50.3975	171096.0
2018-08-01 19:00:00	AAPL	Stock	50.39	50.4325	50.2875	50.4175	209452.0
2018-08-01 04:00:00	MSFT	Stock	106.0	106.09	106.0	106.09	2984.0
2018-08-01 05:00:00	MSFT	Stock	106.0	106.0	105.55	105.55	3780.0
2018-08-01 06:00:00	MSFT	Stock	106.0	106.08	106.0	106.0	3016.0
2018-08-01 07:00:00	MSFT	Stock	105.98	105.98	105.65	105.65	12628.0
2018-08-01 08:00:00	MSFT	Stock	105.9	106.34	105.65	105.91	48904.0
2018-08-01 09:00:00	MSFT	Stock	105.92	106.446	105.42	106.02	3885790.0
2018-08-01 10:00:00	MSFT	Stock	106.03	106.36	105.87	106.22	3136845.0
2018-08-01 11:00:00	MSFT	Stock	106.211	106.295	105.9	106.11	2422741.0
2018-08-01 12:00:00	MSFT	Stock	106.11	106.2	105.89	106.065	1920145.0
2018-08-01 13:00:00	MSFT	Stock	106.06	106.14	105.86	106.01	1592271.0
2018-08-01 14:00:00	MSFT	Stock	106.02	106.26	105.66	105.99	2034006.0
2018-08-01 15:00:00	MSFT	Stock	105.98	106.32	105.88	106.28	2810724.0
2018-08-01 16:00:00	MSFT	Stock	106.28	106.3	105.991	106.2	3092454.0
2018-08-01 17:00:00	MSFT	Stock	106.35	106.39	106.2	106.35	4212.0
2018-08-01 18:00:00	MSFT	Stock	106.39	106.49	106.35	106.43	4421.0
2018-08-01 19:00:00	MSFT	Stock	106.32	106.4	106.32	106.4	764.0
2018-08-01 04:00:00	NVDA	Stock	6.1375	6.1375	6.1375	6.1375	24000.0
2018-08-01 05:00:00	NVDA	Stock	6.1412	6.1412	6.128	6.1285	28960.0
2018-08-01 06:00:00	NVDA	Stock	6.13	6.13	6.1285	6.1285	68000.0
2018-08-01 07:00:00	NVDA	Stock	6.14	6.14	6.127	6.1315	110120.0
2018-08-01 08:00:00	NVDA	Stock	6.12	6.1375	6.12	6.1263	790080.0
2018-08-01 09:00:00	NVDA	Stock	6.1469	6.1683	6.0972	6.1599	31534080.0
2018-08-01 10:00:00	NVDA	Stock	6.1598	6.209	6.1415	6.1788	51427880.0
2018-08-01 11:00:00	NVDA	Stock	6.181	6.182	6.0995	6.1204	43494720.0
2018-08-01 12:00:00	NVDA	Stock	6.118	6.1562	6.1125	6.1465	24247000.0
2018-08-01 13:00:00	NVDA	Stock	6.1455	6.1553	6.1332	6.1485	13270840.0
2018-08-01 14:00:00	NVDA	Stock	6.148	6.1555	6.1105	6.1445	23289440.0
2018-08-01 15:00:00	NVDA	Stock	6.1458	6.172	6.1375	6.1642	40471120.0
2018-08-01 16:00:00	NVDA	Stock	6.1618	6.1658	6.1545	6.1548	14502960.0
2018-08-01 17:00:00	NVDA	Stock	6.1545	6.165	6.1438	6.16	611920.0
2018-08-01 18:00:00	NVDA	Stock	6.157	6.157	6.1028	6.1075	594480.0
2018-08-01 19:00:00	NVDA	Stock	6.1088	6.125	6.1	6.125	854080.0
2018-08-01 04:00:00	AMZN	Stock	89.3955	89.4	89.3145	89.4	40900.0
2018-08-01 05:00:00	AMZN	Stock	89.3885	89.4495	89.2645	89.2645	72580.0

> showing 50 of 49,357 rows — these rows as CSV

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