PREVIEW / stock_1hour / 2020-03-27

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-27.parquet
  size:    1.2 MB
  rows:    54,140
  symbols: 2,443

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
2020-03-27 04:00:00	AAPL	Stock	63.61	63.8	63.375	63.375	42776.0
2020-03-27 05:00:00	AAPL	Stock	63.3	63.5	63.0	63.0	59740.0
2020-03-27 06:00:00	AAPL	Stock	63.0	63.3275	62.825	62.825	79008.0
2020-03-27 07:00:00	AAPL	Stock	62.9375	63.6125	62.83	63.075	672540.0
2020-03-27 08:00:00	AAPL	Stock	63.45	63.5875	62.825	63.0025	898504.0
2020-03-27 09:00:00	AAPL	Stock	63.0	63.335	62.095	62.716	24352904.0
2020-03-27 10:00:00	AAPL	Stock	62.7225	62.7975	62.1725	62.425	19808816.0
2020-03-27 11:00:00	AAPL	Stock	62.43	63.03	62.43	62.5	16184352.0
2020-03-27 12:00:00	AAPL	Stock	62.4975	62.8625	62.25	62.7592	14824420.0
2020-03-27 13:00:00	AAPL	Stock	62.7775	63.66	62.6125	63.3425	19950360.0
2020-03-27 14:00:00	AAPL	Stock	63.3475	63.49	62.93	63.43	14902100.0
2020-03-27 15:00:00	AAPL	Stock	63.426	63.9675	61.7625	61.905	40745004.0
2020-03-27 16:00:00	AAPL	Stock	61.9325	62.7155	61.75	61.9075	18540504.0
2020-03-27 17:00:00	AAPL	Stock	61.9075	61.9975	61.85	61.9975	159204.0
2020-03-27 18:00:00	AAPL	Stock	61.9975	62.0	61.825	61.8725	65028.0
2020-03-27 19:00:00	AAPL	Stock	61.8675	61.8725	61.75	61.75	95072.0
2020-03-27 04:00:00	MSFT	Stock	153.38	153.82	152.8	153.0	8423.0
2020-03-27 05:00:00	MSFT	Stock	152.99	153.0	151.75	151.75	7310.0
2020-03-27 06:00:00	MSFT	Stock	151.76	153.2	151.21	151.4	18991.0
2020-03-27 07:00:00	MSFT	Stock	151.98	152.9	151.04	151.31	105745.0
2020-03-27 08:00:00	MSFT	Stock	152.25	152.8	151.0	151.31	170483.0
2020-03-27 09:00:00	MSFT	Stock	151.37	152.31	149.25	150.26	7693543.0
2020-03-27 10:00:00	MSFT	Stock	150.29	151.3	149.2	150.58	5797478.0
2020-03-27 11:00:00	MSFT	Stock	150.57	153.12	150.55	151.3	4465965.0
2020-03-27 12:00:00	MSFT	Stock	151.28	152.42	150.61	152.2	3313578.0
2020-03-27 13:00:00	MSFT	Stock	152.216	153.8	151.87	153.075	4045138.0
2020-03-27 14:00:00	MSFT	Stock	153.09	154.5	152.7	153.962	4287458.0
2020-03-27 15:00:00	MSFT	Stock	153.94	154.89	149.26	149.61	10377379.0
2020-03-27 16:00:00	MSFT	Stock	149.62	150.0	148.8	149.34	7839548.0
2020-03-27 17:00:00	MSFT	Stock	149.25	149.5	149.2	149.5	43643.0
2020-03-27 18:00:00	MSFT	Stock	149.36	149.6	149.16	149.16	5761.0
2020-03-27 19:00:00	MSFT	Stock	149.41	149.45	148.49	148.8	25612.0
2020-03-27 04:00:00	NVDA	Stock	6.32	6.32	6.2845	6.305	27080.0
2020-03-27 05:00:00	NVDA	Stock	6.3058	6.3058	6.25	6.25	65040.0
2020-03-27 06:00:00	NVDA	Stock	6.22	6.2805	6.22	6.2625	121240.0
2020-03-27 07:00:00	NVDA	Stock	6.25	6.3305	6.25	6.2763	1703440.0
2020-03-27 08:00:00	NVDA	Stock	6.3175	6.336	6.241	6.275	2418680.0
2020-03-27 09:00:00	NVDA	Stock	6.2825	6.4	6.217	6.3698	73546880.0
2020-03-27 10:00:00	NVDA	Stock	6.3693	6.41	6.259	6.3002	66174200.0
2020-03-27 11:00:00	NVDA	Stock	6.3005	6.3992	6.3005	6.3159	52617440.0
2020-03-27 12:00:00	NVDA	Stock	6.314	6.3863	6.2888	6.3772	34603240.0
2020-03-27 13:00:00	NVDA	Stock	6.379	6.525	6.3665	6.4522	78360440.0
2020-03-27 14:00:00	NVDA	Stock	6.4536	6.4988	6.383	6.4975	74606120.0
2020-03-27 15:00:00	NVDA	Stock	6.4955	6.578	6.2933	6.3135	140535040.0
2020-03-27 16:00:00	NVDA	Stock	6.3182	6.341	6.3005	6.3105	20834280.0
2020-03-27 17:00:00	NVDA	Stock	6.315	6.3253	6.3112	6.3212	256160.0
2020-03-27 18:00:00	NVDA	Stock	6.325	6.3253	6.3105	6.3175	448640.0
2020-03-27 19:00:00	NVDA	Stock	6.3123	6.3125	6.3	6.3025	245520.0
2020-03-27 04:00:00	AMZN	Stock	96.7085	96.7085	96.2	96.2	27480.0
2020-03-27 06:00:00	AMZN	Stock	96.0	96.3025	95.925	96.24	33320.0

> showing 50 of 54,140 rows — these rows as CSV

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