PREVIEW / stock_1hour / 2018-02-28

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-02-28.parquet
  size:    1.1 MB
  rows:    49,208
  symbols: 2,880

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-02-28 04:00:00	AAPL	Stock	44.6775	44.745	44.6625	44.7375	48040.0
2018-02-28 05:00:00	AAPL	Stock	44.735	44.735	44.6375	44.6375	6784.0
2018-02-28 06:00:00	AAPL	Stock	44.6275	44.695	44.5925	44.625	4408.0
2018-02-28 07:00:00	AAPL	Stock	44.645	44.73	44.6375	44.7	116492.0
2018-02-28 08:00:00	AAPL	Stock	44.7125	44.8725	44.635	44.8	461336.0
2018-02-28 09:00:00	AAPL	Stock	44.81	44.9822	44.77	44.965	14067392.0
2018-02-28 10:00:00	AAPL	Stock	44.965	45.1538	44.8	44.9065	22434972.0
2018-02-28 11:00:00	AAPL	Stock	44.9075	44.9475	44.6275	44.785	15184488.0
2018-02-28 12:00:00	AAPL	Stock	44.785	44.9975	44.7225	44.97	8196928.0
2018-02-28 13:00:00	AAPL	Stock	44.9675	45.0875	44.855	45.075	10538996.0
2018-02-28 14:00:00	AAPL	Stock	45.0775	45.1225	44.82	44.865	10512128.0
2018-02-28 15:00:00	AAPL	Stock	44.8675	44.905	44.5125	44.5325	24678288.0
2018-02-28 16:00:00	AAPL	Stock	44.5325	44.8112	44.53	44.61	21469796.0
2018-02-28 17:00:00	AAPL	Stock	44.605	44.61	44.575	44.605	45580.0
2018-02-28 18:00:00	AAPL	Stock	44.595	44.6175	44.575	44.6175	87768.0
2018-02-28 19:00:00	AAPL	Stock	44.6175	44.625	44.59	44.6225	47356.0
2018-02-28 04:00:00	MSFT	Stock	94.62	94.62	94.62	94.62	200.0
2018-02-28 05:00:00	MSFT	Stock	94.52	94.52	94.51	94.51	3100.0
2018-02-28 06:00:00	MSFT	Stock	94.51	94.51	94.33	94.33	611.0
2018-02-28 07:00:00	MSFT	Stock	94.52	94.56	94.45	94.55	3719.0
2018-02-28 08:00:00	MSFT	Stock	94.34	94.79	94.34	94.7	9524.0
2018-02-28 09:00:00	MSFT	Stock	94.74	95.36	94.695	95.275	2378565.0
2018-02-28 10:00:00	MSFT	Stock	95.28	95.31	94.53	94.69	2430444.0
2018-02-28 11:00:00	MSFT	Stock	94.7	95.11	94.56	94.89	2390361.0
2018-02-28 12:00:00	MSFT	Stock	94.9	95.479	94.732	95.415	1759227.0
2018-02-28 13:00:00	MSFT	Stock	95.42	95.61	95.28	95.596	2007877.0
2018-02-28 14:00:00	MSFT	Stock	95.595	95.705	94.8	94.83	2366875.0
2018-02-28 15:00:00	MSFT	Stock	94.845	94.93	93.63	93.77	7234269.0
2018-02-28 16:00:00	MSFT	Stock	93.77	95.08	93.762	94.2	6460688.0
2018-02-28 17:00:00	MSFT	Stock	94.19	94.26	93.77	94.15	15085.0
2018-02-28 18:00:00	MSFT	Stock	94.17	94.2	94.02	94.1	2418.0
2018-02-28 19:00:00	MSFT	Stock	94.14	94.2	94.07	94.18	7063.0
2018-02-28 04:00:00	NVDA	Stock	6.1748	6.175	6.1748	6.175	26120.0
2018-02-28 05:00:00	NVDA	Stock	6.175	6.175	6.175	6.175	35960.0
2018-02-28 06:00:00	NVDA	Stock	6.1545	6.1622	6.1545	6.1615	53800.0
2018-02-28 07:00:00	NVDA	Stock	6.1553	6.1598	6.1438	6.1598	416360.0
2018-02-28 08:00:00	NVDA	Stock	6.155	6.1798	6.1338	6.175	1135560.0
2018-02-28 09:00:00	NVDA	Stock	6.1763	6.2025	6.1523	6.1701	56229600.0
2018-02-28 10:00:00	NVDA	Stock	6.1713	6.175	6.0813	6.0998	88431240.0
2018-02-28 11:00:00	NVDA	Stock	6.1015	6.113	6.0383	6.0595	83831560.0
2018-02-28 12:00:00	NVDA	Stock	6.0616	6.0955	6.0576	6.0848	50583320.0
2018-02-28 13:00:00	NVDA	Stock	6.0835	6.1292	6.0688	6.1285	45320000.0
2018-02-28 14:00:00	NVDA	Stock	6.127	6.1393	6.0803	6.0905	38969600.0
2018-02-28 15:00:00	NVDA	Stock	6.0908	6.0946	6.039	6.0502	89822600.0
2018-02-28 16:00:00	NVDA	Stock	6.0505	6.0742	6.05	6.062	35341840.0
2018-02-28 17:00:00	NVDA	Stock	6.0575	6.065	6.0575	6.065	327440.0
2018-02-28 18:00:00	NVDA	Stock	6.064	6.08	6.0575	6.0753	880280.0
2018-02-28 19:00:00	NVDA	Stock	6.075	6.075	6.0662	6.0662	640520.0
2018-02-28 05:00:00	AMZN	Stock	76.0	76.0	75.9	75.9	15660.0
2018-02-28 06:00:00	AMZN	Stock	76.0	76.0	76.0	76.0	7620.0

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

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