PREVIEW / stock_1hour / 2020-05-26

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-05-26.parquet
  size:    1.2 MB
  rows:    57,404
  symbols: 2,380

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-05-26 04:00:00	AAPL	Stock	80.7875	81.3625	80.7775	81.3625	32584.0
2020-05-26 05:00:00	AAPL	Stock	81.355	81.375	81.275	81.2875	14904.0
2020-05-26 06:00:00	AAPL	Stock	81.125	81.31	81.1075	81.1075	36604.0
2020-05-26 07:00:00	AAPL	Stock	81.1075	81.14	80.7675	80.97	337012.0
2020-05-26 08:00:00	AAPL	Stock	80.925	81.0725	80.85	80.99	419952.0
2020-05-26 09:00:00	AAPL	Stock	80.995	81.4875	79.93	79.9838	16557936.0
2020-05-26 10:00:00	AAPL	Stock	79.9875	80.455	79.96	80.24	13779256.0
2020-05-26 11:00:00	AAPL	Stock	80.235	80.3615	79.175	79.7162	15223556.0
2020-05-26 12:00:00	AAPL	Stock	79.715	80.1325	79.6275	80.0108	10229944.0
2020-05-26 13:00:00	AAPL	Stock	80.015	80.3425	79.825	80.03	11540528.0
2020-05-26 14:00:00	AAPL	Stock	80.0275	80.0675	79.6275	79.8213	7418996.0
2020-05-26 15:00:00	AAPL	Stock	79.8175	79.86	79.125	79.21	18036552.0
2020-05-26 16:00:00	AAPL	Stock	79.1825	79.3875	79.1625	79.3475	11664040.0
2020-05-26 17:00:00	AAPL	Stock	79.3275	79.3675	79.3275	79.3325	18532.0
2020-05-26 18:00:00	AAPL	Stock	79.3125	79.4	79.2625	79.325	28648.0
2020-05-26 19:00:00	AAPL	Stock	79.3275	79.355	79.1875	79.22	78856.0
2020-05-26 04:00:00	MSFT	Stock	186.7	187.0	186.6	187.0	12109.0
2020-05-26 05:00:00	MSFT	Stock	187.2	187.6	186.95	186.99	4495.0
2020-05-26 06:00:00	MSFT	Stock	186.89	187.2	186.64	186.64	10946.0
2020-05-26 07:00:00	MSFT	Stock	186.62	186.92	185.91	186.25	42197.0
2020-05-26 08:00:00	MSFT	Stock	186.23	186.55	185.05	185.709	98845.0
2020-05-26 09:00:00	MSFT	Stock	185.65	186.55	183.65	184.08	4694618.0
2020-05-26 10:00:00	MSFT	Stock	184.085	184.59	183.4	183.74	3930223.0
2020-05-26 11:00:00	MSFT	Stock	183.74	183.83	182.32	183.0	3538808.0
2020-05-26 12:00:00	MSFT	Stock	183.0	183.43	182.5	183.205	2334593.0
2020-05-26 13:00:00	MSFT	Stock	183.21	183.75	182.86	183.05	1686102.0
2020-05-26 14:00:00	MSFT	Stock	183.06	183.14	182.44	182.528	2162050.0
2020-05-26 15:00:00	MSFT	Stock	182.52	183.5	181.1	181.56	6308026.0
2020-05-26 16:00:00	MSFT	Stock	181.57	182.572	181.57	181.89	6242055.0
2020-05-26 17:00:00	MSFT	Stock	181.88	181.97	181.76	181.97	13778.0
2020-05-26 18:00:00	MSFT	Stock	181.93	182.15	181.75	181.9	10300.0
2020-05-26 19:00:00	MSFT	Stock	181.94	181.94	181.46	181.8	22332.0
2020-05-26 04:00:00	NVDA	Stock	9.275	9.3	9.2128	9.2313	968000.0
2020-05-26 05:00:00	NVDA	Stock	9.2268	9.2325	9.2153	9.2228	690240.0
2020-05-26 06:00:00	NVDA	Stock	9.2188	9.2225	9.2062	9.2062	203840.0
2020-05-26 07:00:00	NVDA	Stock	9.2062	9.2175	9.15	9.1975	1797880.0
2020-05-26 08:00:00	NVDA	Stock	9.1874	9.2125	9.0038	9.195	2729520.0
2020-05-26 09:00:00	NVDA	Stock	9.1925	9.201	8.8503	8.8901	123204280.0
2020-05-26 10:00:00	NVDA	Stock	8.8901	8.9848	8.8062	8.8732	123337920.0
2020-05-26 11:00:00	NVDA	Stock	8.8715	8.9295	8.7028	8.7612	117890920.0
2020-05-26 12:00:00	NVDA	Stock	8.761	8.8563	8.7598	8.8136	72530080.0
2020-05-26 13:00:00	NVDA	Stock	8.815	8.8498	8.7882	8.806	42385600.0
2020-05-26 14:00:00	NVDA	Stock	8.8058	8.8148	8.758	8.7908	46925240.0
2020-05-26 15:00:00	NVDA	Stock	8.7882	8.8073	8.672	8.7195	92408520.0
2020-05-26 16:00:00	NVDA	Stock	8.7178	8.7558	8.7178	8.751	11686240.0
2020-05-26 17:00:00	NVDA	Stock	8.7545	8.755	8.7425	8.7538	244360.0
2020-05-26 18:00:00	NVDA	Stock	8.75	8.7525	8.7268	8.7343	303320.0
2020-05-26 19:00:00	NVDA	Stock	8.7332	8.7375	8.727	8.7275	373840.0
2020-05-26 04:00:00	AMZN	Stock	122.5	123.2955	122.5	122.98	25440.0
2020-05-26 05:00:00	AMZN	Stock	123.147	123.15	123.047	123.047	9380.0

> showing 50 of 57,404 rows — these rows as CSV

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