PREVIEW / stock_1hour / 2018-03-22

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-22.parquet
  size:    1.1 MB
  rows:    49,399
  symbols: 2,869

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-03-22 04:00:00	AAPL	Stock	42.825	42.825	42.4975	42.555	124228.0
2018-03-22 05:00:00	AAPL	Stock	42.5525	42.575	42.395	42.525	31012.0
2018-03-22 06:00:00	AAPL	Stock	42.4775	42.5625	42.4	42.4975	18524.0
2018-03-22 07:00:00	AAPL	Stock	42.5	42.675	42.5	42.5575	242144.0
2018-03-22 08:00:00	AAPL	Stock	42.575	42.7025	42.4275	42.4725	655852.0
2018-03-22 09:00:00	AAPL	Stock	42.44	42.59	42.325	42.4475	21085436.0
2018-03-22 10:00:00	AAPL	Stock	42.4425	42.6	42.295	42.33	19362704.0
2018-03-22 11:00:00	AAPL	Stock	42.3325	42.4925	42.2325	42.395	18504276.0
2018-03-22 12:00:00	AAPL	Stock	42.3925	42.825	42.325	42.65	18275808.0
2018-03-22 13:00:00	AAPL	Stock	42.6425	43.17	42.52	43.025	19010924.0
2018-03-22 14:00:00	AAPL	Stock	43.0225	43.1025	42.685	42.705	12776756.0
2018-03-22 15:00:00	AAPL	Stock	42.705	42.835	42.15	42.1875	30819988.0
2018-03-22 16:00:00	AAPL	Stock	42.2125	42.25	42.1375	42.2	9109340.0
2018-03-22 17:00:00	AAPL	Stock	42.205	42.25	42.175	42.175	66248.0
2018-03-22 18:00:00	AAPL	Stock	42.1725	42.2	42.0	42.05	137492.0
2018-03-22 19:00:00	AAPL	Stock	42.015	42.015	41.8875	41.925	230020.0
2018-03-22 04:00:00	MSFT	Stock	92.65	92.65	91.94	92.0	2107.0
2018-03-22 05:00:00	MSFT	Stock	92.01	92.01	91.68	91.68	428.0
2018-03-22 06:00:00	MSFT	Stock	91.8	91.8	91.34	91.34	656.0
2018-03-22 07:00:00	MSFT	Stock	91.74	91.84	91.5	91.51	17437.0
2018-03-22 08:00:00	MSFT	Stock	91.65	91.84	91.37	91.49	33705.0
2018-03-22 09:00:00	MSFT	Stock	91.389	91.62	90.56	91.28	3751098.0
2018-03-22 10:00:00	MSFT	Stock	91.27	91.75	90.7	90.79	3943536.0
2018-03-22 11:00:00	MSFT	Stock	90.79	90.915	90.09	90.39	4776919.0
2018-03-22 12:00:00	MSFT	Stock	90.395	91.26	90.25	91.03	3506813.0
2018-03-22 13:00:00	MSFT	Stock	91.03	91.405	90.64	91.18	2938799.0
2018-03-22 14:00:00	MSFT	Stock	91.18	91.27	90.59	90.675	2858360.0
2018-03-22 15:00:00	MSFT	Stock	90.68	90.945	89.66	89.8	9173683.0
2018-03-22 16:00:00	MSFT	Stock	89.79	90.04	89.71	89.75	3813357.0
2018-03-22 17:00:00	MSFT	Stock	89.75	89.95	89.74	89.74	4695.0
2018-03-22 18:00:00	MSFT	Stock	89.74	89.75	89.21	89.45	8919.0
2018-03-22 19:00:00	MSFT	Stock	89.44	89.5	89.02	89.02	6813.0
2018-03-22 04:00:00	NVDA	Stock	6.1875	6.1908	6.15	6.1908	810720.0
2018-03-22 05:00:00	NVDA	Stock	6.178	6.178	6.1562	6.1603	123040.0
2018-03-22 06:00:00	NVDA	Stock	6.165	6.1745	6.149	6.15	117800.0
2018-03-22 07:00:00	NVDA	Stock	6.1612	6.175	6.1525	6.1618	573800.0
2018-03-22 08:00:00	NVDA	Stock	6.1698	6.1925	6.1378	6.1562	3867040.0
2018-03-22 09:00:00	NVDA	Stock	6.1505	6.1885	6.09	6.1538	70645480.0
2018-03-22 10:00:00	NVDA	Stock	6.1558	6.197	6.0701	6.0922	76739920.0
2018-03-22 11:00:00	NVDA	Stock	6.0914	6.113	6.0085	6.0433	87802600.0
2018-03-22 12:00:00	NVDA	Stock	6.042	6.1565	6.0338	6.1425	75457160.0
2018-03-22 13:00:00	NVDA	Stock	6.1425	6.1715	6.1068	6.1472	42442560.0
2018-03-22 14:00:00	NVDA	Stock	6.1453	6.1485	6.0888	6.098	39775600.0
2018-03-22 15:00:00	NVDA	Stock	6.097	6.1192	6.0415	6.0463	99919760.0
2018-03-22 16:00:00	NVDA	Stock	6.0485	6.0662	6.025	6.05	5221200.0
2018-03-22 17:00:00	NVDA	Stock	6.05	6.062	6.05	6.0562	428720.0
2018-03-22 18:00:00	NVDA	Stock	6.0513	6.0513	6.0125	6.025	1431960.0
2018-03-22 19:00:00	NVDA	Stock	6.025	6.0358	6.0002	6.0005	655200.0
2018-03-22 04:00:00	AMZN	Stock	78.6375	78.6375	78.5525	78.5525	8000.0
2018-03-22 05:00:00	AMZN	Stock	78.3275	78.3275	78.3135	78.3135	4000.0

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

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