PREVIEW / stock_1hour / 2018-05-24

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-24.parquet
  size:    1.1 MB
  rows:    48,909
  symbols: 2,825

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-05-24 04:00:00	AAPL	Stock	47.1725	47.255	47.1725	47.225	15332.0
2018-05-24 05:00:00	AAPL	Stock	47.235	47.25	47.19	47.2375	23472.0
2018-05-24 06:00:00	AAPL	Stock	47.225	47.2525	47.195	47.2125	28412.0
2018-05-24 07:00:00	AAPL	Stock	47.19	47.2	47.1275	47.195	125428.0
2018-05-24 08:00:00	AAPL	Stock	47.2	47.21	47.0875	47.1625	243568.0
2018-05-24 09:00:00	AAPL	Stock	47.14	47.215	46.7375	46.7925	11675396.0
2018-05-24 10:00:00	AAPL	Stock	46.7925	46.9625	46.5525	46.605	13519584.0
2018-05-24 11:00:00	AAPL	Stock	46.6075	46.9075	46.59	46.9075	8295144.0
2018-05-24 12:00:00	AAPL	Stock	46.905	47.0175	46.8825	46.9925	5698784.0
2018-05-24 13:00:00	AAPL	Stock	46.9938	47.1625	46.99	47.055	6225744.0
2018-05-24 14:00:00	AAPL	Stock	47.055	47.135	46.9975	47.0438	4877180.0
2018-05-24 15:00:00	AAPL	Stock	47.0425	47.1275	46.945	47.0525	9994984.0
2018-05-24 16:00:00	AAPL	Stock	47.0375	47.1125	47.0125	47.04	6202340.0
2018-05-24 17:00:00	AAPL	Stock	47.05	47.0875	47.0392	47.055	33640.0
2018-05-24 18:00:00	AAPL	Stock	47.06	47.0875	47.045	47.075	67060.0
2018-05-24 19:00:00	AAPL	Stock	47.0875	47.125	47.0875	47.125	21824.0
2018-05-24 04:00:00	MSFT	Stock	98.8	98.8	98.8	98.8	150.0
2018-05-24 05:00:00	MSFT	Stock	98.71	98.71	98.71	98.71	2900.0
2018-05-24 06:00:00	MSFT	Stock	98.7	98.7	98.7	98.7	190.0
2018-05-24 07:00:00	MSFT	Stock	98.66	98.67	98.5	98.67	1860.0
2018-05-24 08:00:00	MSFT	Stock	98.476	98.75	98.476	98.55	6574.0
2018-05-24 09:00:00	MSFT	Stock	98.52	98.94	97.655	97.86	2823794.0
2018-05-24 10:00:00	MSFT	Stock	97.86	98.09	96.9	96.94	3446644.0
2018-05-24 11:00:00	MSFT	Stock	96.94	97.787	96.81	97.75	2534591.0
2018-05-24 12:00:00	MSFT	Stock	97.76	98.07	97.63	98.02	1832455.0
2018-05-24 13:00:00	MSFT	Stock	98.02	98.18	97.79	97.965	1761791.0
2018-05-24 14:00:00	MSFT	Stock	97.96	98.325	97.88	98.22	1290266.0
2018-05-24 15:00:00	MSFT	Stock	98.22	98.58	98.09	98.32	3130061.0
2018-05-24 16:00:00	MSFT	Stock	98.31	98.37	98.14	98.31	2853390.0
2018-05-24 17:00:00	MSFT	Stock	98.17	98.25	98.16	98.17	999.0
2018-05-24 18:00:00	MSFT	Stock	98.28	98.31	98.2	98.31	1779.0
2018-05-24 19:00:00	MSFT	Stock	98.36	98.4	98.31	98.35	5896.0
2018-05-24 04:00:00	NVDA	Stock	6.2048	6.2048	6.192	6.2	22400.0
2018-05-24 05:00:00	NVDA	Stock	6.2125	6.2125	6.2125	6.2125	4000.0
2018-05-24 06:00:00	NVDA	Stock	6.2112	6.2112	6.2112	6.2112	4000.0
2018-05-24 07:00:00	NVDA	Stock	6.2013	6.21	6.1768	6.1812	248920.0
2018-05-24 08:00:00	NVDA	Stock	6.1819	6.211	6.169	6.175	1528920.0
2018-05-24 09:00:00	NVDA	Stock	6.1702	6.2188	6.1425	6.1548	73019840.0
2018-05-24 10:00:00	NVDA	Stock	6.1525	6.2033	6.1358	6.14	62934360.0
2018-05-24 11:00:00	NVDA	Stock	6.1403	6.1921	6.131	6.1908	41395080.0
2018-05-24 12:00:00	NVDA	Stock	6.1903	6.2118	6.1812	6.1976	44882320.0
2018-05-24 13:00:00	NVDA	Stock	6.1983	6.23	6.1953	6.2278	38781720.0
2018-05-24 14:00:00	NVDA	Stock	6.2285	6.235	6.2053	6.2222	37317840.0
2018-05-24 15:00:00	NVDA	Stock	6.22	6.22	6.183	6.1935	50134920.0
2018-05-24 16:00:00	NVDA	Stock	6.1923	6.1923	6.1875	6.1888	1381480.0
2018-05-24 17:00:00	NVDA	Stock	6.1888	6.1923	6.185	6.1923	147920.0
2018-05-24 18:00:00	NVDA	Stock	6.1923	6.1973	6.1923	6.1942	255440.0
2018-05-24 19:00:00	NVDA	Stock	6.1962	6.1998	6.19	6.1912	207840.0
2018-05-24 06:00:00	AMZN	Stock	80.1745	80.2	80.1745	80.2	8820.0
2018-05-24 07:00:00	AMZN	Stock	80.109	80.109	79.999	80.061	135040.0

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

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