PREVIEW / stock_1hour / 2020-03-30

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-30.parquet
  size:    1.2 MB
  rows:    54,339
  symbols: 2,411

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-30 04:00:00	AAPL	Stock	61.75	62.025	61.38	62.025	72420.0
2020-03-30 05:00:00	AAPL	Stock	61.875	62.4975	61.7875	62.125	21848.0
2020-03-30 06:00:00	AAPL	Stock	62.0425	62.225	61.8875	62.125	23232.0
2020-03-30 07:00:00	AAPL	Stock	62.13	62.4075	61.75	62.25	588992.0
2020-03-30 08:00:00	AAPL	Stock	61.8315	62.8475	61.8275	62.775	1233788.0
2020-03-30 09:00:00	AAPL	Stock	62.825	63.415	62.375	62.4755	21071056.0
2020-03-30 10:00:00	AAPL	Stock	62.49	63.15	62.35	62.8488	21647172.0
2020-03-30 11:00:00	AAPL	Stock	62.8488	63.375	62.8075	63.1425	14547324.0
2020-03-30 12:00:00	AAPL	Stock	63.1325	63.5	62.815	63.4325	14417016.0
2020-03-30 13:00:00	AAPL	Stock	63.435	63.435	62.9625	63.1375	11128604.0
2020-03-30 14:00:00	AAPL	Stock	63.1462	63.5475	62.8675	63.4425	14669004.0
2020-03-30 15:00:00	AAPL	Stock	63.4392	63.88	62.9875	63.6975	28597344.0
2020-03-30 16:00:00	AAPL	Stock	63.6975	63.7025	61.935	63.5375	13444632.0
2020-03-30 17:00:00	AAPL	Stock	63.55	63.5725	63.5	63.5	54248.0
2020-03-30 18:00:00	AAPL	Stock	63.5	63.7025	63.475	63.55	87352.0
2020-03-30 19:00:00	AAPL	Stock	63.55	63.6925	63.5	63.625	95688.0
2020-03-30 04:00:00	MSFT	Stock	148.79	150.95	148.79	150.0	9637.0
2020-03-30 05:00:00	MSFT	Stock	150.8	151.23	149.82	150.28	9248.0
2020-03-30 06:00:00	MSFT	Stock	150.6	151.6	150.26	151.6	8615.0
2020-03-30 07:00:00	MSFT	Stock	151.15	151.5	150.6	151.1	47777.0
2020-03-30 08:00:00	MSFT	Stock	151.27	152.1	149.7	152.0	391545.0
2020-03-30 09:00:00	MSFT	Stock	152.2	156.93	150.01	156.08	8157620.0
2020-03-30 10:00:00	MSFT	Stock	156.12	158.25	156.06	157.34	7428692.0
2020-03-30 11:00:00	MSFT	Stock	157.315	159.29	157.22	158.61	5879814.0
2020-03-30 12:00:00	MSFT	Stock	158.62	160.0	157.6	159.92	5758265.0
2020-03-30 13:00:00	MSFT	Stock	159.91	160.07	158.9	159.513	5179935.0
2020-03-30 14:00:00	MSFT	Stock	159.5	160.58	158.59	159.935	5098050.0
2020-03-30 15:00:00	MSFT	Stock	159.93	160.6	158.65	160.3	9696933.0
2020-03-30 16:00:00	MSFT	Stock	160.3	160.36	149.7	160.0	5206488.0
2020-03-30 17:00:00	MSFT	Stock	160.11	160.5	160.0	160.19	35389.0
2020-03-30 18:00:00	MSFT	Stock	160.01	162.45	160.0	161.83	162222.0
2020-03-30 19:00:00	MSFT	Stock	161.82	162.69	161.25	162.6	81903.0
2020-03-30 04:00:00	NVDA	Stock	6.275	6.2948	6.275	6.2778	47480.0
2020-03-30 05:00:00	NVDA	Stock	6.344	6.3682	6.3255	6.3255	41440.0
2020-03-30 06:00:00	NVDA	Stock	6.3233	6.3688	6.3233	6.3688	24400.0
2020-03-30 07:00:00	NVDA	Stock	6.325	6.362	6.3035	6.342	522920.0
2020-03-30 08:00:00	NVDA	Stock	6.349	6.44	6.3128	6.4278	2271640.0
2020-03-30 09:00:00	NVDA	Stock	6.43	6.485	6.3398	6.4395	75013800.0
2020-03-30 10:00:00	NVDA	Stock	6.443	6.5625	6.3958	6.4972	92580560.0
2020-03-30 11:00:00	NVDA	Stock	6.4958	6.5895	6.4907	6.573	69067280.0
2020-03-30 12:00:00	NVDA	Stock	6.57	6.615	6.518	6.61	61831120.0
2020-03-30 13:00:00	NVDA	Stock	6.6111	6.6398	6.57	6.6048	67445680.0
2020-03-30 14:00:00	NVDA	Stock	6.6052	6.63	6.5793	6.6032	52520240.0
2020-03-30 15:00:00	NVDA	Stock	6.6042	6.649	6.55	6.6406	95074320.0
2020-03-30 16:00:00	NVDA	Stock	6.6398	6.6415	6.6188	6.6412	3534160.0
2020-03-30 17:00:00	NVDA	Stock	6.6392	6.645	6.6332	6.6412	3659480.0
2020-03-30 18:00:00	NVDA	Stock	6.6375	6.6625	6.637	6.6625	441320.0
2020-03-30 19:00:00	NVDA	Stock	6.6565	6.672	6.6433	6.672	850200.0
2020-03-30 04:00:00	AMZN	Stock	94.8	94.9335	94.8	94.8735	8280.0
2020-03-30 05:00:00	AMZN	Stock	95.6145	95.752	95.6145	95.752	6000.0

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

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