PREVIEW / stock_1hour / 2020-01-08

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-08.parquet
  size:    1.2 MB
  rows:    51,885
  symbols: 2,474

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-01-08 04:00:00	AAPL	Stock	74.125	74.345	74.125	74.3	113332.0
2020-01-08 05:00:00	AAPL	Stock	74.25	74.5	74.25	74.5	46468.0
2020-01-08 06:00:00	AAPL	Stock	74.5625	74.6875	74.5	74.5925	86256.0
2020-01-08 07:00:00	AAPL	Stock	74.54	74.635	74.4	74.6175	370208.0
2020-01-08 08:00:00	AAPL	Stock	74.425	74.7825	74.3875	74.525	723756.0
2020-01-08 09:00:00	AAPL	Stock	74.5447	74.775	74.2325	74.5925	13420384.0
2020-01-08 10:00:00	AAPL	Stock	74.595	74.69	74.3425	74.4325	11148788.0
2020-01-08 11:00:00	AAPL	Stock	74.4325	75.0525	74.375	75.0225	17345492.0
2020-01-08 12:00:00	AAPL	Stock	75.0225	75.76	75.02	75.6577	20249960.0
2020-01-08 13:00:00	AAPL	Stock	75.6612	75.8075	75.6	75.6508	9609296.0
2020-01-08 14:00:00	AAPL	Stock	75.65	75.7725	75.6325	75.7675	6625728.0
2020-01-08 15:00:00	AAPL	Stock	75.7675	76.11	75.56	75.7875	22891508.0
2020-01-08 16:00:00	AAPL	Stock	75.7975	75.9225	75.615	75.865	9866728.0
2020-01-08 17:00:00	AAPL	Stock	75.8675	75.895	75.82	75.835	68508.0
2020-01-08 18:00:00	AAPL	Stock	75.84	75.97	75.825	75.9125	150772.0
2020-01-08 19:00:00	AAPL	Stock	75.925	76.0	75.9	75.9975	147096.0
2020-01-08 04:00:00	MSFT	Stock	156.62	157.47	156.62	157.3	36813.0
2020-01-08 05:00:00	MSFT	Stock	157.3	158.05	157.3	157.88	13553.0
2020-01-08 06:00:00	MSFT	Stock	157.89	158.26	157.75	157.83	9686.0
2020-01-08 07:00:00	MSFT	Stock	157.83	158.64	157.6	158.64	127286.0
2020-01-08 08:00:00	MSFT	Stock	157.7	159.16	157.58	158.842	198754.0
2020-01-08 09:00:00	MSFT	Stock	158.8	158.99	157.949	158.6	2878083.0
2020-01-08 10:00:00	MSFT	Stock	158.61	159.29	158.51	159.18	2826848.0
2020-01-08 11:00:00	MSFT	Stock	159.18	160.18	158.88	159.835	3656156.0
2020-01-08 12:00:00	MSFT	Stock	159.84	160.05	159.77	159.895	2049125.0
2020-01-08 13:00:00	MSFT	Stock	159.9	159.97	159.472	159.815	1422875.0
2020-01-08 14:00:00	MSFT	Stock	159.81	160.353	159.8	160.344	1486376.0
2020-01-08 15:00:00	MSFT	Stock	160.35	160.8	159.86	160.14	4420829.0
2020-01-08 16:00:00	MSFT	Stock	160.09	160.5	159.653	160.28	4265448.0
2020-01-08 17:00:00	MSFT	Stock	160.28	160.46	160.28	160.43	12521.0
2020-01-08 18:00:00	MSFT	Stock	160.43	160.7	160.37	160.5	12377.0
2020-01-08 19:00:00	MSFT	Stock	160.54	160.7	160.5	160.55	4876.0
2020-01-08 04:00:00	NVDA	Stock	5.9333	5.96	5.9333	5.9473	99120.0
2020-01-08 05:00:00	NVDA	Stock	5.9508	5.9968	5.9503	5.9968	43600.0
2020-01-08 06:00:00	NVDA	Stock	6.0	6.0	5.9685	5.9858	136440.0
2020-01-08 07:00:00	NVDA	Stock	5.9823	5.9975	5.95	5.9875	1056600.0
2020-01-08 08:00:00	NVDA	Stock	5.9688	6.017	5.9638	5.9825	4643120.0
2020-01-08 09:00:00	NVDA	Stock	5.984	6.0193	5.957	5.9953	46032480.0
2020-01-08 10:00:00	NVDA	Stock	5.9939	6.0081	5.9537	5.9667	36137520.0
2020-01-08 11:00:00	NVDA	Stock	5.9688	6.0392	5.9563	6.0193	34756760.0
2020-01-08 12:00:00	NVDA	Stock	6.0193	6.0358	6.0163	6.0284	17404480.0
2020-01-08 13:00:00	NVDA	Stock	6.0291	6.039	6.0178	6.0228	14025440.0
2020-01-08 14:00:00	NVDA	Stock	6.0248	6.0413	6.0212	6.0287	22310840.0
2020-01-08 15:00:00	NVDA	Stock	6.0285	6.051	5.9983	6.0123	53478800.0
2020-01-08 16:00:00	NVDA	Stock	6.0095	6.016	6.0035	6.0153	3452000.0
2020-01-08 17:00:00	NVDA	Stock	6.0125	6.0155	6.0125	6.0155	32200.0
2020-01-08 18:00:00	NVDA	Stock	6.016	6.03	6.0128	6.0128	157640.0
2020-01-08 19:00:00	NVDA	Stock	6.02	6.025	6.02	6.025	31360.0
2020-01-08 04:00:00	AMZN	Stock	94.8	94.85	94.7165	94.726	27020.0
2020-01-08 05:00:00	AMZN	Stock	94.99	95.15	94.99	95.15	33780.0

> showing 50 of 51,885 rows — these rows as CSV

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