PREVIEW / stock_1hour / 2020-03-13

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-13.parquet
  size:    1.2 MB
  rows:    55,928
  symbols: 2,465

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-13 04:00:00	AAPL	Stock	63.775	65.4225	63.5	63.8025	218900.0
2020-03-13 05:00:00	AAPL	Stock	63.895	64.7	63.575	64.6975	70648.0
2020-03-13 06:00:00	AAPL	Stock	64.625	65.3125	64.5	65.0075	332132.0
2020-03-13 07:00:00	AAPL	Stock	65.005	66.0	64.5	65.9	1413108.0
2020-03-13 08:00:00	AAPL	Stock	64.8125	67.1725	64.5	66.81	3008548.0
2020-03-13 09:00:00	AAPL	Stock	66.8	66.875	63.3575	64.8725	50330388.0
2020-03-13 10:00:00	AAPL	Stock	64.86	66.125	64.25	64.275	42456104.0
2020-03-13 11:00:00	AAPL	Stock	64.27	65.3225	63.2375	64.3378	34173808.0
2020-03-13 12:00:00	AAPL	Stock	64.3375	65.76	63.7128	64.91	29180184.0
2020-03-13 13:00:00	AAPL	Stock	64.9132	66.0	64.6375	65.58	25354156.0
2020-03-13 14:00:00	AAPL	Stock	65.5838	65.619	64.04	64.8175	25746232.0
2020-03-13 15:00:00	AAPL	Stock	64.8	69.98	63.59	69.515	61702560.0
2020-03-13 16:00:00	AAPL	Stock	69.4925	69.5	68.4075	68.6875	24538408.0
2020-03-13 17:00:00	AAPL	Stock	68.6875	68.7775	68.6	68.73	571796.0
2020-03-13 18:00:00	AAPL	Stock	68.7375	69.0875	68.25	68.4875	440844.0
2020-03-13 19:00:00	AAPL	Stock	68.475	68.545	68.1375	68.375	323380.0
2020-03-13 04:00:00	MSFT	Stock	143.9	146.1	141.9	142.7	41202.0
2020-03-13 05:00:00	MSFT	Stock	142.02	144.5	142.0	144.2	16532.0
2020-03-13 06:00:00	MSFT	Stock	144.48	145.3	143.9	145.0	21707.0
2020-03-13 07:00:00	MSFT	Stock	145.0	148.3	144.11	148.3	182491.0
2020-03-13 08:00:00	MSFT	Stock	144.505	149.3	144.2	149.03	347642.0
2020-03-13 09:00:00	MSFT	Stock	149.03	149.25	143.0	144.67	10437230.0
2020-03-13 10:00:00	MSFT	Stock	144.64	147.78	143.0	143.17	10055331.0
2020-03-13 11:00:00	MSFT	Stock	143.13	145.4	140.73	144.37	8427659.0
2020-03-13 12:00:00	MSFT	Stock	144.33	146.52	142.4	144.9	6532305.0
2020-03-13 13:00:00	MSFT	Stock	144.93	147.47	143.525	146.65	5458234.0
2020-03-13 14:00:00	MSFT	Stock	146.627	146.654	143.1	144.7	5829405.0
2020-03-13 15:00:00	MSFT	Stock	144.64	161.91	141.99	158.85	17575656.0
2020-03-13 16:00:00	MSFT	Stock	157.55	158.88	153.15	154.5	12201376.0
2020-03-13 17:00:00	MSFT	Stock	154.6	155.25	153.6	153.85	340313.0
2020-03-13 18:00:00	MSFT	Stock	153.88	158.83	153.75	153.9	182531.0
2020-03-13 19:00:00	MSFT	Stock	153.82	154.0	152.51	153.0	72961.0
2020-03-13 04:00:00	NVDA	Stock	5.57	5.663	5.55	5.55	393360.0
2020-03-13 05:00:00	NVDA	Stock	5.55	5.6375	5.55	5.6375	165560.0
2020-03-13 06:00:00	NVDA	Stock	5.6375	5.6642	5.6275	5.6275	195200.0
2020-03-13 07:00:00	NVDA	Stock	5.645	5.75	5.6255	5.75	1962240.0
2020-03-13 08:00:00	NVDA	Stock	5.643	5.853	5.628	5.8058	4122200.0
2020-03-13 09:00:00	NVDA	Stock	5.8125	5.9048	5.625	5.6625	100872400.0
2020-03-13 10:00:00	NVDA	Stock	5.6578	5.7865	5.622	5.6275	68785760.0
2020-03-13 11:00:00	NVDA	Stock	5.626	5.6822	5.4903	5.5788	62133400.0
2020-03-13 12:00:00	NVDA	Stock	5.5778	5.7025	5.505	5.6299	46865600.0
2020-03-13 13:00:00	NVDA	Stock	5.628	5.725	5.6095	5.7067	46152000.0
2020-03-13 14:00:00	NVDA	Stock	5.7063	5.7084	5.5408	5.6248	37788280.0
2020-03-13 15:00:00	NVDA	Stock	5.6248	6.0255	5.5252	6.0208	114380400.0
2020-03-13 16:00:00	NVDA	Stock	5.9948	6.0488	5.95	5.95	54652240.0
2020-03-13 17:00:00	NVDA	Stock	5.9503	5.9505	5.875	5.925	627840.0
2020-03-13 18:00:00	NVDA	Stock	5.9375	5.99	5.9263	5.94	627560.0
2020-03-13 19:00:00	NVDA	Stock	5.94	5.9495	5.925	5.925	576720.0
2020-03-13 04:00:00	AMZN	Stock	86.5	86.7	85.499	85.5	53580.0
2020-03-13 05:00:00	AMZN	Stock	85.25	86.5	85.25	86.5	22080.0

> showing 50 of 55,928 rows — these rows as CSV

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