PREVIEW / stock_1hour / 2020-04-23

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-23.parquet
  size:    1.2 MB
  rows:    54,084
  symbols: 2,383

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-23 04:00:00	AAPL	Stock	68.565	68.565	68.55	68.55	1200.0
2020-04-23 05:00:00	AAPL	Stock	68.7	68.99	68.675	68.99	8340.0
2020-04-23 06:00:00	AAPL	Stock	68.95	68.95	68.5	68.685	9680.0
2020-04-23 07:00:00	AAPL	Stock	68.7475	68.8775	68.5825	68.8275	119860.0
2020-04-23 08:00:00	AAPL	Stock	68.8127	69.1225	68.5825	69.005	453156.0
2020-04-23 09:00:00	AAPL	Stock	69.0725	69.7525	68.7925	69.64	12959928.0
2020-04-23 10:00:00	AAPL	Stock	69.6325	70.4375	69.6325	70.18	16891692.0
2020-04-23 11:00:00	AAPL	Stock	70.1925	70.1975	69.7825	69.92	9621512.0
2020-04-23 12:00:00	AAPL	Stock	69.9212	70.085	68.99	69.624	13403516.0
2020-04-23 13:00:00	AAPL	Stock	69.625	69.89	68.895	69.14	11389268.0
2020-04-23 14:00:00	AAPL	Stock	69.13	69.5225	68.775	69.44	10642176.0
2020-04-23 15:00:00	AAPL	Stock	69.45	69.4825	68.7175	68.7175	15194280.0
2020-04-23 16:00:00	AAPL	Stock	68.7425	68.8625	68.475	68.6325	10650036.0
2020-04-23 17:00:00	AAPL	Stock	68.6275	68.6275	68.5	68.5625	48284.0
2020-04-23 18:00:00	AAPL	Stock	68.555	68.7225	68.2825	68.325	153096.0
2020-04-23 19:00:00	AAPL	Stock	68.3675	68.375	68.275	68.275	120480.0
2020-04-23 04:00:00	MSFT	Stock	172.62	172.62	172.62	172.62	300.0
2020-04-23 05:00:00	MSFT	Stock	172.9	172.9	172.9	172.9	100.0
2020-04-23 06:00:00	MSFT	Stock	173.7	173.7	173.35	173.48	3579.0
2020-04-23 07:00:00	MSFT	Stock	173.39	173.5	173.0	173.3	31197.0
2020-04-23 08:00:00	MSFT	Stock	173.03	174.5	172.81	174.48	68504.0
2020-04-23 09:00:00	MSFT	Stock	174.5	175.06	173.55	174.35	3229896.0
2020-04-23 10:00:00	MSFT	Stock	174.32	175.04	173.61	174.62	3927711.0
2020-04-23 11:00:00	MSFT	Stock	174.63	174.67	173.3	173.575	3171497.0
2020-04-23 12:00:00	MSFT	Stock	173.57	174.22	170.91	172.918	3618541.0
2020-04-23 13:00:00	MSFT	Stock	172.91	173.59	171.42	171.87	3066701.0
2020-04-23 14:00:00	MSFT	Stock	171.86	173.17	171.12	173.15	2989947.0
2020-04-23 15:00:00	MSFT	Stock	173.12	173.18	171.2	171.43	4439596.0
2020-04-23 16:00:00	MSFT	Stock	171.42	171.48	170.75	171.0	3220185.0
2020-04-23 17:00:00	MSFT	Stock	171.0	171.17	170.82	170.98	26952.0
2020-04-23 18:00:00	MSFT	Stock	170.96	171.5	170.47	170.67	38079.0
2020-04-23 19:00:00	MSFT	Stock	170.7	170.88	170.32	170.55	13172.0
2020-04-23 04:00:00	NVDA	Stock	7.125	7.125	7.125	7.125	30520.0
2020-04-23 06:00:00	NVDA	Stock	7.15	7.15	7.15	7.15	15080.0
2020-04-23 07:00:00	NVDA	Stock	7.1425	7.189	7.13	7.1655	488600.0
2020-04-23 08:00:00	NVDA	Stock	7.1752	7.2595	7.13	7.245	1331560.0
2020-04-23 09:00:00	NVDA	Stock	7.2498	7.3	7.1565	7.2351	70833120.0
2020-04-23 10:00:00	NVDA	Stock	7.235	7.3284	7.226	7.2653	62686840.0
2020-04-23 11:00:00	NVDA	Stock	7.2658	7.2793	7.2213	7.2395	37846040.0
2020-04-23 12:00:00	NVDA	Stock	7.2402	7.2775	7.075	7.1911	59232480.0
2020-04-23 13:00:00	NVDA	Stock	7.1952	7.2322	7.095	7.1195	43149960.0
2020-04-23 14:00:00	NVDA	Stock	7.1188	7.1875	7.0935	7.1782	31541320.0
2020-04-23 15:00:00	NVDA	Stock	7.1783	7.1812	7.09	7.1005	51131040.0
2020-04-23 16:00:00	NVDA	Stock	7.1002	7.139	6.973	7.0325	12720240.0
2020-04-23 17:00:00	NVDA	Stock	7.0325	7.0552	6.9918	6.998	1290200.0
2020-04-23 18:00:00	NVDA	Stock	7.0	7.0348	6.9942	6.999	1413200.0
2020-04-23 19:00:00	NVDA	Stock	6.9988	7.0145	6.9832	6.995	655240.0
2020-04-23 04:00:00	AMZN	Stock	118.217	118.217	118.217	118.217	2260.0
2020-04-23 05:00:00	AMZN	Stock	118.436	118.6205	118.4335	118.6205	13980.0
2020-04-23 06:00:00	AMZN	Stock	118.6	118.656	118.6	118.653	15600.0

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

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