PREVIEW / stock_1hour / 2019-05-10

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-10.parquet
  size:    1.1 MB
  rows:    49,083
  symbols: 2,604

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
2019-05-10 04:00:00	AAPL	Stock	49.9825	49.9825	49.745	49.845	58700.0
2019-05-10 05:00:00	AAPL	Stock	49.9475	50.15	49.9475	49.9525	26364.0
2019-05-10 06:00:00	AAPL	Stock	50.0025	50.175	49.73	49.73	63304.0
2019-05-10 07:00:00	AAPL	Stock	49.7675	49.8925	49.5825	49.6	248520.0
2019-05-10 08:00:00	AAPL	Stock	49.725	49.8975	49.27	49.3475	1115632.0
2019-05-10 09:00:00	AAPL	Stock	49.3475	49.7125	49.2525	49.3675	16577496.0
2019-05-10 10:00:00	AAPL	Stock	49.3725	49.435	48.1925	48.4325	33088820.0
2019-05-10 11:00:00	AAPL	Stock	48.44	48.6925	48.2675	48.54	17492256.0
2019-05-10 12:00:00	AAPL	Stock	48.532	49.0	48.53	48.8875	14125232.0
2019-05-10 13:00:00	AAPL	Stock	48.891	49.23	48.8275	49.195	11862828.0
2019-05-10 14:00:00	AAPL	Stock	49.1987	49.2542	48.8562	49.205	11465768.0
2019-05-10 15:00:00	AAPL	Stock	49.2012	49.6375	49.1098	49.325	22086036.0
2019-05-10 16:00:00	AAPL	Stock	49.295	49.3125	49.1952	49.2875	6492412.0
2019-05-10 17:00:00	AAPL	Stock	49.2625	49.3075	49.2525	49.3025	41504.0
2019-05-10 18:00:00	AAPL	Stock	49.3025	49.3125	49.295	49.3125	40504.0
2019-05-10 19:00:00	AAPL	Stock	49.3125	49.3125	49.2875	49.2875	44644.0
2019-05-10 04:00:00	MSFT	Stock	125.48	125.66	125.2	125.38	3200.0
2019-05-10 05:00:00	MSFT	Stock	125.71	125.81	125.6	125.6	939.0
2019-05-10 06:00:00	MSFT	Stock	125.55	126.0	125.44	125.44	3395.0
2019-05-10 07:00:00	MSFT	Stock	125.5	125.75	124.98	125.01	9498.0
2019-05-10 08:00:00	MSFT	Stock	125.5	125.82	124.26	124.76	15054.0
2019-05-10 09:00:00	MSFT	Stock	124.86	126.0	124.79	125.28	2330091.0
2019-05-10 10:00:00	MSFT	Stock	125.29	125.305	124.02	124.2	3656261.0
2019-05-10 11:00:00	MSFT	Stock	124.19	124.58	123.82	124.24	3511295.0
2019-05-10 12:00:00	MSFT	Stock	124.24	126.0	124.23	125.776	2836821.0
2019-05-10 13:00:00	MSFT	Stock	125.79	126.67	125.66	126.5	2908891.0
2019-05-10 14:00:00	MSFT	Stock	126.49	126.99	126.24	126.88	2204745.0
2019-05-10 15:00:00	MSFT	Stock	126.89	127.93	126.8	127.19	6235276.0
2019-05-10 16:00:00	MSFT	Stock	127.23	127.27	126.95	127.15	3828390.0
2019-05-10 17:00:00	MSFT	Stock	127.18	127.28	127.18	127.25	4529.0
2019-05-10 18:00:00	MSFT	Stock	127.24	127.42	127.2	127.42	8072.0
2019-05-10 19:00:00	MSFT	Stock	127.38	127.38	127.21	127.23	779.0
2019-05-10 04:00:00	NVDA	Stock	4.25	4.2552	4.228	4.2345	117640.0
2019-05-10 05:00:00	NVDA	Stock	4.252	4.252	4.2382	4.2382	8280.0
2019-05-10 06:00:00	NVDA	Stock	4.245	4.255	4.245	4.252	16000.0
2019-05-10 07:00:00	NVDA	Stock	4.25	4.25	4.2225	4.225	272400.0
2019-05-10 08:00:00	NVDA	Stock	4.225	4.25	4.1812	4.195	1663000.0
2019-05-10 09:00:00	NVDA	Stock	4.19	4.2898	4.1888	4.2486	66848320.0
2019-05-10 10:00:00	NVDA	Stock	4.2488	4.25	4.133	4.1488	90378880.0
2019-05-10 11:00:00	NVDA	Stock	4.1481	4.1618	4.1	4.1186	82384720.0
2019-05-10 12:00:00	NVDA	Stock	4.1198	4.1718	4.1175	4.1635	52990800.0
2019-05-10 13:00:00	NVDA	Stock	4.1645	4.2226	4.158	4.219	49523840.0
2019-05-10 14:00:00	NVDA	Stock	4.2185	4.2288	4.1895	4.2028	42636120.0
2019-05-10 15:00:00	NVDA	Stock	4.2032	4.2538	4.1975	4.221	90698440.0
2019-05-10 16:00:00	NVDA	Stock	4.2205	4.2333	4.2028	4.2333	17436200.0
2019-05-10 17:00:00	NVDA	Stock	4.2318	4.2318	4.2252	4.2275	198800.0
2019-05-10 18:00:00	NVDA	Stock	4.225	4.235	4.2232	4.235	371320.0
2019-05-10 19:00:00	NVDA	Stock	4.2348	4.2368	4.2275	4.2275	299560.0
2019-05-10 04:00:00	AMZN	Stock	94.847	94.861	94.8	94.8195	16580.0
2019-05-10 05:00:00	AMZN	Stock	95.0	95.25	95.0	95.2	12340.0

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

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