PREVIEW / stock_1hour / 2018-05-22

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-22.parquet
  size:    1.1 MB
  rows:    49,355
  symbols: 2,856

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-22 04:00:00	AAPL	Stock	46.98	46.98	46.98	46.98	1332.0
2018-05-22 06:00:00	AAPL	Stock	47.0275	47.075	47.025	47.075	8260.0
2018-05-22 07:00:00	AAPL	Stock	47.0325	47.125	47.0325	47.1	126480.0
2018-05-22 08:00:00	AAPL	Stock	47.1125	47.1375	47.025	47.0625	127560.0
2018-05-22 09:00:00	AAPL	Stock	47.0525	47.22	46.9658	46.9875	8425632.0
2018-05-22 10:00:00	AAPL	Stock	46.9875	47.0465	46.8325	46.8625	9222000.0
2018-05-22 11:00:00	AAPL	Stock	46.8625	46.9075	46.8125	46.8575	4604332.0
2018-05-22 12:00:00	AAPL	Stock	46.86	46.915	46.7525	46.8425	4483392.0
2018-05-22 13:00:00	AAPL	Stock	46.8438	46.9075	46.8162	46.87	2873656.0
2018-05-22 14:00:00	AAPL	Stock	46.8725	46.965	46.8462	46.8675	3993044.0
2018-05-22 15:00:00	AAPL	Stock	46.865	46.915	46.695	46.8275	9767444.0
2018-05-22 16:00:00	AAPL	Stock	46.8225	46.8525	46.79	46.825	9174616.0
2018-05-22 17:00:00	AAPL	Stock	46.8225	46.83	46.79	46.82	65200.0
2018-05-22 18:00:00	AAPL	Stock	46.83	46.83	46.8025	46.8025	13672.0
2018-05-22 19:00:00	AAPL	Stock	46.8125	46.835	46.8125	46.8125	12900.0
2018-05-22 04:00:00	MSFT	Stock	97.6	98.0	97.6	98.0	440.0
2018-05-22 05:00:00	MSFT	Stock	98.1	98.1	98.1	98.1	100.0
2018-05-22 06:00:00	MSFT	Stock	98.12	98.12	98.0	98.0	1835.0
2018-05-22 07:00:00	MSFT	Stock	98.0	98.0	97.85	97.99	704.0
2018-05-22 08:00:00	MSFT	Stock	98.0	98.01	97.8	97.8	7251.0
2018-05-22 09:00:00	MSFT	Stock	97.81	98.17	97.6	97.885	2014455.0
2018-05-22 10:00:00	MSFT	Stock	97.88	97.91	97.2	97.5	1987240.0
2018-05-22 11:00:00	MSFT	Stock	97.5	97.62	97.38	97.51	1012752.0
2018-05-22 12:00:00	MSFT	Stock	97.51	97.63	97.32	97.55	892580.0
2018-05-22 13:00:00	MSFT	Stock	97.55	97.735	97.51	97.665	896246.0
2018-05-22 14:00:00	MSFT	Stock	97.666	97.995	97.66	97.724	1064235.0
2018-05-22 15:00:00	MSFT	Stock	97.73	97.855	97.3	97.57	2707753.0
2018-05-22 16:00:00	MSFT	Stock	97.57	97.65	97.37	97.5	2203240.0
2018-05-22 17:00:00	MSFT	Stock	97.5	97.51	97.5	97.51	381.0
2018-05-22 18:00:00	MSFT	Stock	97.47	97.47	97.47	97.47	597.0
2018-05-22 19:00:00	MSFT	Stock	97.42	97.59	97.42	97.59	730.0
2018-05-22 04:00:00	NVDA	Stock	6.15	6.15	6.1485	6.1485	14800.0
2018-05-22 05:00:00	NVDA	Stock	6.1468	6.1468	6.1468	6.1468	7360.0
2018-05-22 06:00:00	NVDA	Stock	6.1355	6.1358	6.1355	6.1358	14720.0
2018-05-22 07:00:00	NVDA	Stock	6.147	6.1485	6.1275	6.1393	457720.0
2018-05-22 08:00:00	NVDA	Stock	6.146	6.155	6.1188	6.1363	1910320.0
2018-05-22 09:00:00	NVDA	Stock	6.133	6.145	6.0335	6.0458	78295560.0
2018-05-22 10:00:00	NVDA	Stock	6.0455	6.0733	6.0063	6.0335	89953800.0
2018-05-22 11:00:00	NVDA	Stock	6.0345	6.07	6.0278	6.068	40889840.0
2018-05-22 12:00:00	NVDA	Stock	6.069	6.0888	6.0252	6.0364	54915320.0
2018-05-22 13:00:00	NVDA	Stock	6.0372	6.0612	6.0342	6.0588	33657600.0
2018-05-22 14:00:00	NVDA	Stock	6.0578	6.1095	6.0565	6.0862	64694720.0
2018-05-22 15:00:00	NVDA	Stock	6.0852	6.1018	6.0478	6.0675	51837840.0
2018-05-22 16:00:00	NVDA	Stock	6.0675	6.0763	6.0625	6.0763	18616200.0
2018-05-22 17:00:00	NVDA	Stock	6.0725	6.075	6.0675	6.0675	74280.0
2018-05-22 18:00:00	NVDA	Stock	6.0688	6.0688	6.0625	6.065	111440.0
2018-05-22 19:00:00	NVDA	Stock	6.0688	6.07	6.0575	6.0575	206520.0
2018-05-22 05:00:00	AMZN	Stock	79.614	79.614	79.614	79.614	2000.0
2018-05-22 06:00:00	AMZN	Stock	79.575	79.6125	79.533	79.533	12560.0
2018-05-22 07:00:00	AMZN	Stock	79.525	79.525	79.438	79.5	46900.0

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

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