PREVIEW / stock_1hour / 2019-07-29

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-29.parquet
  size:    1.1 MB
  rows:    50,672
  symbols: 2,596

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-07-29 04:00:00	AAPL	Stock	51.9625	51.975	51.8825	51.8825	4840.0
2019-07-29 05:00:00	AAPL	Stock	51.875	51.95	51.86	51.875	9600.0
2019-07-29 06:00:00	AAPL	Stock	51.88	51.95	51.8475	51.8875	3600.0
2019-07-29 07:00:00	AAPL	Stock	51.8975	52.095	51.8975	52.08	34544.0
2019-07-29 08:00:00	AAPL	Stock	51.925	52.1	51.881	52.075	229424.0
2019-07-29 09:00:00	AAPL	Stock	52.0975	52.425	52.075	52.2425	12436408.0
2019-07-29 10:00:00	AAPL	Stock	52.24	52.5	52.2017	52.4235	11479320.0
2019-07-29 11:00:00	AAPL	Stock	52.4312	52.66	52.4025	52.645	11505852.0
2019-07-29 12:00:00	AAPL	Stock	52.645	52.65	52.4635	52.5425	7926856.0
2019-07-29 13:00:00	AAPL	Stock	52.5418	52.615	52.4875	52.5275	5015988.0
2019-07-29 14:00:00	AAPL	Stock	52.5275	52.6275	52.5025	52.6135	6032852.0
2019-07-29 15:00:00	AAPL	Stock	52.6125	52.625	52.4175	52.4175	10755860.0
2019-07-29 16:00:00	AAPL	Stock	52.42	52.4775	52.375	52.4625	7028408.0
2019-07-29 17:00:00	AAPL	Stock	52.4725	52.475	52.3875	52.4075	88340.0
2019-07-29 18:00:00	AAPL	Stock	52.405	52.4125	52.3775	52.4075	92028.0
2019-07-29 19:00:00	AAPL	Stock	52.3875	52.42	52.3875	52.42	70468.0
2019-07-29 04:00:00	MSFT	Stock	141.85	141.85	141.34	141.45	1912.0
2019-07-29 05:00:00	MSFT	Stock	141.3	141.3	141.3	141.3	200.0
2019-07-29 06:00:00	MSFT	Stock	141.45	141.45	141.34	141.34	511.0
2019-07-29 07:00:00	MSFT	Stock	141.25	141.77	141.25	141.61	17203.0
2019-07-29 08:00:00	MSFT	Stock	141.25	141.76	141.25	141.6	17821.0
2019-07-29 09:00:00	MSFT	Stock	141.77	141.88	139.66	139.834	2493387.0
2019-07-29 10:00:00	MSFT	Stock	139.83	140.43	139.366	140.035	2656964.0
2019-07-29 11:00:00	MSFT	Stock	140.04	140.85	139.99	140.695	1264951.0
2019-07-29 12:00:00	MSFT	Stock	140.703	140.91	140.44	140.91	1040245.0
2019-07-29 13:00:00	MSFT	Stock	140.9	141.14	140.87	141.07	985219.0
2019-07-29 14:00:00	MSFT	Stock	141.065	141.13	140.95	141.113	846481.0
2019-07-29 15:00:00	MSFT	Stock	141.11	141.28	140.98	141.04	1812095.0
2019-07-29 16:00:00	MSFT	Stock	141.04	141.07	140.91	141.0	1814249.0
2019-07-29 17:00:00	MSFT	Stock	141.0	141.08	140.98	141.077	1514.0
2019-07-29 18:00:00	MSFT	Stock	141.08	141.15	141.0	141.15	6247.0
2019-07-29 19:00:00	MSFT	Stock	141.15	141.15	141.05	141.06	3774.0
2019-07-29 04:00:00	NVDA	Stock	4.3745	4.3748	4.3745	4.3748	11120.0
2019-07-29 05:00:00	NVDA	Stock	4.3682	4.3682	4.3682	4.3682	12000.0
2019-07-29 07:00:00	NVDA	Stock	4.3682	4.385	4.3675	4.3832	239280.0
2019-07-29 08:00:00	NVDA	Stock	4.3674	4.3852	4.3638	4.375	312520.0
2019-07-29 09:00:00	NVDA	Stock	4.375	4.3813	4.3237	4.3327	36408240.0
2019-07-29 10:00:00	NVDA	Stock	4.3315	4.3341	4.2818	4.318	43510120.0
2019-07-29 11:00:00	NVDA	Stock	4.3195	4.36	4.3179	4.3545	23937760.0
2019-07-29 12:00:00	NVDA	Stock	4.3542	4.3635	4.3443	4.361	17680680.0
2019-07-29 13:00:00	NVDA	Stock	4.3615	4.37	4.3588	4.363	17022400.0
2019-07-29 14:00:00	NVDA	Stock	4.3632	4.386	4.3562	4.3844	17032120.0
2019-07-29 15:00:00	NVDA	Stock	4.385	4.3868	4.3687	4.3705	28438920.0
2019-07-29 16:00:00	NVDA	Stock	4.3705	4.3785	4.3668	4.3785	23758720.0
2019-07-29 17:00:00	NVDA	Stock	4.37	4.375	4.3688	4.375	74840.0
2019-07-29 18:00:00	NVDA	Stock	4.37	4.3703	4.37	4.3703	31560.0
2019-07-29 19:00:00	NVDA	Stock	4.369	4.375	4.369	4.375	92640.0
2019-07-29 05:00:00	AMZN	Stock	97.059	97.059	97.059	97.059	2000.0
2019-07-29 06:00:00	AMZN	Stock	96.955	96.955	96.865	96.865	17000.0
2019-07-29 07:00:00	AMZN	Stock	96.9345	97.1	96.9345	97.1	6000.0

> showing 50 of 50,672 rows — these rows as CSV

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