PREVIEW / stock_1hour / 2020-04-15

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-15.parquet
  size:    1.2 MB
  rows:    54,405
  symbols: 2,368

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-04-15 04:00:00	AAPL	Stock	70.955	71.175	70.7475	70.8	107508.0
2020-04-15 05:00:00	AAPL	Stock	70.8375	70.855	70.6275	70.7525	74700.0
2020-04-15 06:00:00	AAPL	Stock	70.7675	70.95	70.6925	70.8125	74512.0
2020-04-15 07:00:00	AAPL	Stock	70.81	71.275	70.7975	71.075	313236.0
2020-04-15 08:00:00	AAPL	Stock	70.875	71.9375	69.9	70.3515	1508928.0
2020-04-15 09:00:00	AAPL	Stock	70.3625	70.795	70.143	70.605	16512516.0
2020-04-15 10:00:00	AAPL	Stock	70.6	71.1875	70.25	71.105	16822144.0
2020-04-15 11:00:00	AAPL	Stock	71.1	71.25	70.64	70.7402	13012868.0
2020-04-15 12:00:00	AAPL	Stock	70.741	71.16	70.5108	71.045	9731704.0
2020-04-15 13:00:00	AAPL	Stock	71.04	71.4	70.9625	71.0162	9058220.0
2020-04-15 14:00:00	AAPL	Stock	71.0125	71.52	71.0095	71.52	9260416.0
2020-04-15 15:00:00	AAPL	Stock	71.5125	71.5825	70.9825	71.1125	17177712.0
2020-04-15 16:00:00	AAPL	Stock	71.1075	71.225	71.0155	71.1125	14468976.0
2020-04-15 17:00:00	AAPL	Stock	71.1275	71.13	71.025	71.0375	69676.0
2020-04-15 18:00:00	AAPL	Stock	71.085	71.15	70.655	70.655	100132.0
2020-04-15 19:00:00	AAPL	Stock	70.65	70.8	70.5	70.75	71852.0
2020-04-15 04:00:00	MSFT	Stock	172.02	172.4	171.65	171.89	17865.0
2020-04-15 05:00:00	MSFT	Stock	171.9	171.9	171.4	171.7	10462.0
2020-04-15 06:00:00	MSFT	Stock	171.78	172.08	171.5	172.08	7694.0
2020-04-15 07:00:00	MSFT	Stock	171.65	172.79	171.63	172.3	50757.0
2020-04-15 08:00:00	MSFT	Stock	172.0	174.1	170.25	170.35	321205.0
2020-04-15 09:00:00	MSFT	Stock	170.39	171.55	169.24	170.452	5217985.0
2020-04-15 10:00:00	MSFT	Stock	170.43	173.48	170.02	173.095	6820874.0
2020-04-15 11:00:00	MSFT	Stock	173.08	173.4	171.53	171.64	3294451.0
2020-04-15 12:00:00	MSFT	Stock	171.64	172.92	171.42	172.53	2815339.0
2020-04-15 13:00:00	MSFT	Stock	172.51	172.7	171.53	172.0	2885702.0
2020-04-15 14:00:00	MSFT	Stock	171.99	173.5	171.987	173.475	3554636.0
2020-04-15 15:00:00	MSFT	Stock	173.47	173.57	171.68	171.94	5702437.0
2020-04-15 16:00:00	MSFT	Stock	171.961	172.18	171.8	171.8	4367403.0
2020-04-15 17:00:00	MSFT	Stock	171.98	172.07	171.833	172.0	20043.0
2020-04-15 18:00:00	MSFT	Stock	172.1	172.11	171.0	171.01	45896.0
2020-04-15 19:00:00	MSFT	Stock	171.05	171.1	170.61	170.88	42426.0
2020-04-15 04:00:00	NVDA	Stock	7.0	7.0	6.95	6.95	122200.0
2020-04-15 05:00:00	NVDA	Stock	6.95	6.95	6.95	6.95	21040.0
2020-04-15 06:00:00	NVDA	Stock	6.975	6.975	6.9722	6.9722	21600.0
2020-04-15 07:00:00	NVDA	Stock	6.975	7.039	6.9688	7.0125	755760.0
2020-04-15 08:00:00	NVDA	Stock	7.0275	7.1192	6.906	6.9338	3144520.0
2020-04-15 09:00:00	NVDA	Stock	6.9348	7.0073	6.8845	6.933	62392000.0
2020-04-15 10:00:00	NVDA	Stock	6.93	7.0183	6.8995	7.0011	57707320.0
2020-04-15 11:00:00	NVDA	Stock	7.004	7.0485	6.9662	6.9778	35827680.0
2020-04-15 12:00:00	NVDA	Stock	6.98	7.065	6.975	7.0359	32384760.0
2020-04-15 13:00:00	NVDA	Stock	7.0335	7.0595	7.0255	7.0392	19731760.0
2020-04-15 14:00:00	NVDA	Stock	7.0402	7.1042	7.038	7.0905	31075680.0
2020-04-15 15:00:00	NVDA	Stock	7.089	7.0988	7.01	7.0213	58684560.0
2020-04-15 16:00:00	NVDA	Stock	7.021	7.0395	7.0188	7.025	4187800.0
2020-04-15 17:00:00	NVDA	Stock	7.025	7.03	7.021	7.022	84920.0
2020-04-15 18:00:00	NVDA	Stock	7.0395	7.046	6.9762	6.9762	549480.0
2020-04-15 19:00:00	NVDA	Stock	6.9975	7.0	6.967	6.9698	163440.0
2020-04-15 04:00:00	AMZN	Stock	112.55	112.85	112.003	112.75	58040.0
2020-04-15 05:00:00	AMZN	Stock	112.67	112.75	112.595	112.75	22400.0

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

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