PREVIEW / stock_1hour / 2020-05-08

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-05-08.parquet
  size:    1.2 MB
  rows:    54,643
  symbols: 2,384

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-08 04:00:00	AAPL	Stock	76.6275	76.6625	76.35	76.45	57640.0
2020-05-08 05:00:00	AAPL	Stock	76.555	76.655	76.5	76.655	16940.0
2020-05-08 06:00:00	AAPL	Stock	76.6425	76.7475	76.6325	76.72	33660.0
2020-05-08 07:00:00	AAPL	Stock	76.6525	76.6775	76.48	76.56	158432.0
2020-05-08 08:00:00	AAPL	Stock	76.6232	76.7668	76.1225	76.6325	795932.0
2020-05-08 09:00:00	AAPL	Stock	76.6125	76.6825	76.0725	76.215	13317052.0
2020-05-08 10:00:00	AAPL	Stock	76.225	76.6825	76.215	76.5825	16034428.0
2020-05-08 11:00:00	AAPL	Stock	76.595	77.0	76.475	76.9975	11291544.0
2020-05-08 12:00:00	AAPL	Stock	76.9925	77.1175	76.935	77.0625	10299116.0
2020-05-08 13:00:00	AAPL	Stock	77.06	77.125	76.69	76.77	8507592.0
2020-05-08 14:00:00	AAPL	Stock	76.7675	76.9825	76.66	76.9317	7352348.0
2020-05-08 15:00:00	AAPL	Stock	76.93	77.5875	76.92	77.537	34076044.0
2020-05-08 16:00:00	AAPL	Stock	77.4375	77.595	76.9925	77.595	8853628.0
2020-05-08 17:00:00	AAPL	Stock	77.58	77.6375	77.525	77.6375	150940.0
2020-05-08 18:00:00	AAPL	Stock	77.625	77.685	77.5875	77.65	69600.0
2020-05-08 19:00:00	AAPL	Stock	77.6775	77.685	77.6375	77.6375	116124.0
2020-05-08 04:00:00	MSFT	Stock	185.33	185.46	185.0	185.23	4745.0
2020-05-08 05:00:00	MSFT	Stock	185.39	186.0	185.39	186.0	4289.0
2020-05-08 06:00:00	MSFT	Stock	186.0	186.17	185.75	185.82	8246.0
2020-05-08 07:00:00	MSFT	Stock	185.55	185.8	185.35	185.48	48192.0
2020-05-08 08:00:00	MSFT	Stock	185.75	185.8	184.05	185.09	146888.0
2020-05-08 09:00:00	MSFT	Stock	185.07	185.24	183.38	183.726	4116091.0
2020-05-08 10:00:00	MSFT	Stock	183.725	184.65	183.36	184.399	4200895.0
2020-05-08 11:00:00	MSFT	Stock	184.4	184.75	183.96	184.52	2537489.0
2020-05-08 12:00:00	MSFT	Stock	184.526	184.94	184.275	184.92	2057824.0
2020-05-08 13:00:00	MSFT	Stock	184.92	184.96	183.8	183.96	2415206.0
2020-05-08 14:00:00	MSFT	Stock	183.96	184.33	183.59	184.1	2084653.0
2020-05-08 15:00:00	MSFT	Stock	184.106	185.0	183.99	184.68	4393553.0
2020-05-08 16:00:00	MSFT	Stock	184.68	184.75	184.33	184.64	5099569.0
2020-05-08 17:00:00	MSFT	Stock	184.69	184.7	184.5	184.6	10879.0
2020-05-08 18:00:00	MSFT	Stock	184.65	184.75	184.57	184.7	14930.0
2020-05-08 19:00:00	MSFT	Stock	184.74	184.75	184.6	184.6	16594.0
2020-05-08 05:00:00	NVDA	Stock	7.7342	7.7342	7.725	7.725	33840.0
2020-05-08 06:00:00	NVDA	Stock	7.7405	7.7405	7.7365	7.7375	41640.0
2020-05-08 07:00:00	NVDA	Stock	7.7255	7.7472	7.6998	7.7008	436440.0
2020-05-08 08:00:00	NVDA	Stock	7.725	7.739	7.6825	7.7285	1887080.0
2020-05-08 09:00:00	NVDA	Stock	7.7265	7.7763	7.6598	7.7518	60345080.0
2020-05-08 10:00:00	NVDA	Stock	7.7518	7.8185	7.749	7.7733	57971040.0
2020-05-08 11:00:00	NVDA	Stock	7.7745	7.817	7.7695	7.8074	33227800.0
2020-05-08 12:00:00	NVDA	Stock	7.8068	7.8072	7.7718	7.7935	21577040.0
2020-05-08 13:00:00	NVDA	Stock	7.7925	7.8005	7.7302	7.755	34558400.0
2020-05-08 14:00:00	NVDA	Stock	7.7522	7.7575	7.7248	7.7445	26956200.0
2020-05-08 15:00:00	NVDA	Stock	7.7472	7.8188	7.7455	7.8128	46232360.0
2020-05-08 16:00:00	NVDA	Stock	7.8125	7.821	7.8075	7.8162	17588520.0
2020-05-08 17:00:00	NVDA	Stock	7.8155	7.8375	7.8132	7.8375	596560.0
2020-05-08 18:00:00	NVDA	Stock	7.8375	7.8538	7.8345	7.8538	465520.0
2020-05-08 19:00:00	NVDA	Stock	7.8398	7.8525	7.8398	7.85	228760.0
2020-05-08 04:00:00	AMZN	Stock	119.0	119.0	119.0	119.0	9340.0
2020-05-08 05:00:00	AMZN	Stock	119.1	119.1	119.1	119.1	2000.0
2020-05-08 07:00:00	AMZN	Stock	119.0	119.0215	118.919	118.9485	44860.0

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

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