PREVIEW / stock_1hour / 2020-12-30

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-30.parquet
  size:    1.4 MB
  rows:    64,659
  symbols: 2,672

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-12-30 04:00:00	AAPL	Stock	135.41	135.5	135.3	135.44	16293.0
2020-12-30 05:00:00	AAPL	Stock	135.49	135.7	135.47	135.68	6342.0
2020-12-30 06:00:00	AAPL	Stock	135.7	135.8	135.4	135.8	18992.0
2020-12-30 07:00:00	AAPL	Stock	135.75	135.84	135.19	135.639	209448.0
2020-12-30 08:00:00	AAPL	Stock	135.66	135.82	135.19	135.62	408038.0
2020-12-30 09:00:00	AAPL	Stock	135.6	135.99	134.43	134.8	13155930.0
2020-12-30 10:00:00	AAPL	Stock	134.79	134.88	133.565	134.391	16446627.0
2020-12-30 11:00:00	AAPL	Stock	134.39	135.14	134.1	135.126	10638345.0
2020-12-30 12:00:00	AAPL	Stock	135.12	135.18	134.2	134.36	8440329.0
2020-12-30 13:00:00	AAPL	Stock	134.355	134.62	134.235	134.544	6109088.0
2020-12-30 14:00:00	AAPL	Stock	134.54	134.589	133.69	133.774	8959886.0
2020-12-30 15:00:00	AAPL	Stock	133.765	134.18	133.4	133.72	14010548.0
2020-12-30 16:00:00	AAPL	Stock	133.72	133.87	133.67	133.67	6443338.0
2020-12-30 17:00:00	AAPL	Stock	133.67	133.75	133.53	133.75	107290.0
2020-12-30 18:00:00	AAPL	Stock	133.74	133.85	133.69	133.74	67591.0
2020-12-30 19:00:00	AAPL	Stock	133.75	133.82	133.68	133.82	97433.0
2020-12-30 04:00:00	MSFT	Stock	224.72	225.0	224.72	224.72	901.0
2020-12-30 05:00:00	MSFT	Stock	225.0	225.0	224.97	224.97	1076.0
2020-12-30 06:00:00	MSFT	Stock	224.86	224.87	224.83	224.83	1434.0
2020-12-30 07:00:00	MSFT	Stock	224.77	224.9	224.5	224.82	17360.0
2020-12-30 08:00:00	MSFT	Stock	224.85	225.09	224.6	224.92	30388.0
2020-12-30 09:00:00	MSFT	Stock	225.14	225.63	222.88	223.254	2285384.0
2020-12-30 10:00:00	MSFT	Stock	223.25	223.32	222.3	223.029	2347543.0
2020-12-30 11:00:00	MSFT	Stock	223.02	223.099	222.31	222.53	1430854.0
2020-12-30 12:00:00	MSFT	Stock	222.522	222.72	222.32	222.717	1236426.0
2020-12-30 13:00:00	MSFT	Stock	222.71	223.055	222.54	222.68	1159113.0
2020-12-30 14:00:00	MSFT	Stock	222.68	222.74	222.08	222.211	1375659.0
2020-12-30 15:00:00	MSFT	Stock	222.21	222.29	221.47	221.68	3253548.0
2020-12-30 16:00:00	MSFT	Stock	221.68	221.75	221.537	221.75	3944270.0
2020-12-30 17:00:00	MSFT	Stock	221.72	221.75	221.63	221.63	127965.0
2020-12-30 18:00:00	MSFT	Stock	221.63	221.99	221.62	221.75	3723.0
2020-12-30 19:00:00	MSFT	Stock	222.0	222.1	221.8	221.85	11077.0
2020-12-30 04:00:00	NVDA	Stock	12.9433	12.9433	12.925	12.925	27600.0
2020-12-30 05:00:00	NVDA	Stock	12.9378	12.9378	12.9378	12.9378	4200.0
2020-12-30 06:00:00	NVDA	Stock	12.9248	12.9248	12.9248	12.9248	9520.0
2020-12-30 07:00:00	NVDA	Stock	12.96	13.01	12.96	13.01	449520.0
2020-12-30 08:00:00	NVDA	Stock	13.01	13.02	12.9575	13.0	582040.0
2020-12-30 09:00:00	NVDA	Stock	13.0	13.0175	12.9	12.9282	19801760.0
2020-12-30 10:00:00	NVDA	Stock	12.9298	12.9995	12.8968	12.9528	22163440.0
2020-12-30 11:00:00	NVDA	Stock	12.9562	13.036	12.9378	13.014	20603280.0
2020-12-30 12:00:00	NVDA	Stock	13.0148	13.0815	12.9965	13.053	17482800.0
2020-12-30 13:00:00	NVDA	Stock	13.0532	13.1722	13.053	13.165	25379840.0
2020-12-30 14:00:00	NVDA	Stock	13.1668	13.2138	13.1295	13.1862	26621320.0
2020-12-30 15:00:00	NVDA	Stock	13.1862	13.1864	13.1108	13.1363	33652560.0
2020-12-30 16:00:00	NVDA	Stock	13.1458	13.1458	13.133	13.145	1085640.0
2020-12-30 17:00:00	NVDA	Stock	13.1458	13.1525	13.1458	13.1498	1302840.0
2020-12-30 18:00:00	NVDA	Stock	13.1458	13.1613	13.1425	13.155	235880.0
2020-12-30 19:00:00	NVDA	Stock	13.16	13.17	13.15	13.15	60560.0
2020-12-30 05:00:00	AMZN	Stock	166.695	166.695	166.695	166.695	2000.0
2020-12-30 06:00:00	AMZN	Stock	166.84	166.9	166.84	166.9	5300.0

> showing 50 of 64,659 rows — these rows as CSV

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