PREVIEW / stock_1hour / 2020-05-22

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-05-22.parquet
  size:    1.2 MB
  rows:    54,480
  symbols: 2,370

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-05-22 04:00:00	AAPL	Stock	78.35	78.55	78.125	78.55	29800.0
2020-05-22 05:00:00	AAPL	Stock	78.505	78.695	78.4825	78.54	34996.0
2020-05-22 06:00:00	AAPL	Stock	78.535	78.84	78.535	78.725	31852.0
2020-05-22 07:00:00	AAPL	Stock	78.75	79.2425	78.75	79.15	250392.0
2020-05-22 08:00:00	AAPL	Stock	79.2025	79.2475	78.7625	79.025	327904.0
2020-05-22 09:00:00	AAPL	Stock	79.0	79.4875	78.8375	79.435	9599672.0
2020-05-22 10:00:00	AAPL	Stock	79.4375	79.4875	79.125	79.18	12368732.0
2020-05-22 11:00:00	AAPL	Stock	79.175	79.4225	79.1325	79.3575	7304012.0
2020-05-22 12:00:00	AAPL	Stock	79.36	79.5	79.2325	79.365	6378420.0
2020-05-22 13:00:00	AAPL	Stock	79.365	79.6075	79.35	79.4625	7333456.0
2020-05-22 14:00:00	AAPL	Stock	79.465	79.65	79.4325	79.55	7483520.0
2020-05-22 15:00:00	AAPL	Stock	79.5492	79.8075	79.3125	79.7225	12732204.0
2020-05-22 16:00:00	AAPL	Stock	79.7225	79.8125	79.6825	79.7875	3996096.0
2020-05-22 17:00:00	AAPL	Stock	79.7875	79.8	79.7625	79.7625	39672.0
2020-05-22 18:00:00	AAPL	Stock	79.755	79.7775	79.725	79.75	47708.0
2020-05-22 19:00:00	AAPL	Stock	79.7325	79.765	79.7225	79.765	35780.0
2020-05-22 04:00:00	MSFT	Stock	181.9	182.17	181.45	182.17	2429.0
2020-05-22 05:00:00	MSFT	Stock	182.19	182.7	181.66	181.9	4129.0
2020-05-22 06:00:00	MSFT	Stock	182.15	182.32	182.1	182.12	2189.0
2020-05-22 07:00:00	MSFT	Stock	182.5	183.0	182.03	182.85	39355.0
2020-05-22 08:00:00	MSFT	Stock	182.7	183.43	182.1	183.0	54196.0
2020-05-22 09:00:00	MSFT	Stock	183.0	184.46	182.75	184.33	2486080.0
2020-05-22 10:00:00	MSFT	Stock	184.35	184.4	183.0	183.04	2983804.0
2020-05-22 11:00:00	MSFT	Stock	183.02	183.14	182.54	182.848	2074286.0
2020-05-22 12:00:00	MSFT	Stock	182.87	183.65	182.67	183.16	1855274.0
2020-05-22 13:00:00	MSFT	Stock	183.14	183.605	183.14	183.57	1543535.0
2020-05-22 14:00:00	MSFT	Stock	183.58	184.1	183.43	183.53	1777365.0
2020-05-22 15:00:00	MSFT	Stock	183.525	183.71	182.77	183.51	3165435.0
2020-05-22 16:00:00	MSFT	Stock	183.51	183.67	183.35	183.6	1855077.0
2020-05-22 17:00:00	MSFT	Stock	183.63	183.68	183.56	183.6	2345.0
2020-05-22 18:00:00	MSFT	Stock	183.65	183.68	183.6	183.65	2317.0
2020-05-22 19:00:00	MSFT	Stock	183.6	183.66	183.53	183.65	11251.0
2020-05-22 04:00:00	NVDA	Stock	8.7	8.775	8.6678	8.775	105880.0
2020-05-22 05:00:00	NVDA	Stock	8.7938	8.7938	8.77	8.775	433720.0
2020-05-22 06:00:00	NVDA	Stock	8.7923	8.8125	8.7923	8.8125	251400.0
2020-05-22 07:00:00	NVDA	Stock	8.8	8.9522	8.79	8.915	7238200.0
2020-05-22 08:00:00	NVDA	Stock	8.8358	8.95	8.7752	8.7995	9513400.0
2020-05-22 09:00:00	NVDA	Stock	8.7992	9.0282	8.7132	9.0126	256703320.0
2020-05-22 10:00:00	NVDA	Stock	9.0125	9.093	8.9452	8.993	213212320.0
2020-05-22 11:00:00	NVDA	Stock	8.994	9.0325	8.928	8.9705	75612680.0
2020-05-22 12:00:00	NVDA	Stock	8.9713	9.0488	8.946	9.0222	77466280.0
2020-05-22 13:00:00	NVDA	Stock	9.0225	9.075	8.995	9.0319	77268080.0
2020-05-22 14:00:00	NVDA	Stock	9.0332	9.0442	8.9658	9.0295	61769280.0
2020-05-22 15:00:00	NVDA	Stock	9.027	9.0625	8.97	9.0265	117883280.0
2020-05-22 16:00:00	NVDA	Stock	9.0263	9.0263	9.0122	9.0188	13767560.0
2020-05-22 17:00:00	NVDA	Stock	9.0188	9.0188	9.01	9.0158	322240.0
2020-05-22 18:00:00	NVDA	Stock	9.015	9.0195	9.0	9.0162	363280.0
2020-05-22 19:00:00	NVDA	Stock	9.0125	9.0152	9.005	9.01	268320.0
2020-05-22 04:00:00	AMZN	Stock	122.0	122.0	122.0	122.0	4000.0
2020-05-22 05:00:00	AMZN	Stock	122.2	122.2	122.2	122.2	2740.0

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

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