PREVIEW / stock_1hour / 2021-09-29

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-29.parquet
  size:    1.4 MB
  rows:    64,721
  symbols: 2,717

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
2021-09-29 04:00:00	AAPL	Stock	143.6	143.94	143.22	143.57	52465.0
2021-09-29 05:00:00	AAPL	Stock	143.6	143.63	143.27	143.6	13097.0
2021-09-29 06:00:00	AAPL	Stock	143.6	143.68	143.3	143.3	13583.0
2021-09-29 07:00:00	AAPL	Stock	143.26	143.4	142.75	142.86	353979.0
2021-09-29 08:00:00	AAPL	Stock	142.9501	143.39	142.264	142.83	543977.0
2021-09-29 09:00:00	AAPL	Stock	142.82	144.26	142.03	143.96	11411015.0
2021-09-29 10:00:00	AAPL	Stock	143.96	144.45	143.59	144.19	11032954.0
2021-09-29 11:00:00	AAPL	Stock	144.195	144.25	142.96	143.4201	6386477.0
2021-09-29 12:00:00	AAPL	Stock	143.43	143.6381	142.885	143.405	5936025.0
2021-09-29 13:00:00	AAPL	Stock	143.41	143.4955	142.535	143.15	5603893.0
2021-09-29 14:00:00	AAPL	Stock	143.14	144.06	143.07	143.9445	6033372.0
2021-09-29 15:00:00	AAPL	Stock	143.94	144.01	142.51	142.84	9586914.0
2021-09-29 16:00:00	AAPL	Stock	142.84	143.06	142.8	142.95	5356353.0
2021-09-29 17:00:00	AAPL	Stock	142.9886	143.2	142.9201	143.2	116802.0
2021-09-29 18:00:00	AAPL	Stock	143.2	143.45	143.0	143.14	66321.0
2021-09-29 19:00:00	AAPL	Stock	143.15	143.4	143.12	143.37	63602.0
2021-09-29 04:00:00	MSFT	Stock	285.87	286.8	285.87	286.6	6420.0
2021-09-29 05:00:00	MSFT	Stock	286.54	286.82	286.2	286.35	16412.0
2021-09-29 06:00:00	MSFT	Stock	286.45	287.0	286.45	286.5	18053.0
2021-09-29 07:00:00	MSFT	Stock	286.5	286.7	285.24	285.93	39034.0
2021-09-29 08:00:00	MSFT	Stock	285.91	286.49	284.228	285.27	86723.0
2021-09-29 09:00:00	MSFT	Stock	285.0	286.32	283.14	286.025	2931182.0
2021-09-29 10:00:00	MSFT	Stock	286.0234	286.68	283.94	285.2	3034002.0
2021-09-29 11:00:00	MSFT	Stock	285.22	285.25	283.48	284.0909	1664934.0
2021-09-29 12:00:00	MSFT	Stock	284.13	284.43	283.01	283.96	1640200.0
2021-09-29 13:00:00	MSFT	Stock	283.98	285.2899	283.56	284.8146	1864394.0
2021-09-29 14:00:00	MSFT	Stock	284.8	286.77	284.75	286.2701	2100589.0
2021-09-29 15:00:00	MSFT	Stock	286.31	286.42	283.32	284.0	3367133.0
2021-09-29 16:00:00	MSFT	Stock	284.01	284.48	283.96	284.35	2543651.0
2021-09-29 17:00:00	MSFT	Stock	284.37	284.39	284.1	284.2	26370.0
2021-09-29 18:00:00	MSFT	Stock	284.25	284.42	284.11	284.15	5658.0
2021-09-29 19:00:00	MSFT	Stock	284.3	285.2	284.3	284.86	25636.0
2021-09-29 04:00:00	NVDA	Stock	20.9	21.04	20.883	21.012	107150.0
2021-09-29 05:00:00	NVDA	Stock	21.0	21.012	20.956	20.972	15770.0
2021-09-29 06:00:00	NVDA	Stock	20.995	21.027	20.971	20.971	30450.0
2021-09-29 07:00:00	NVDA	Stock	20.966	21.0	20.875	20.975	656310.0
2021-09-29 08:00:00	NVDA	Stock	20.9387	21.013	20.865	20.938	1608590.0
2021-09-29 09:00:00	NVDA	Stock	20.926	21.017	20.71	20.9607	30384060.0
2021-09-29 10:00:00	NVDA	Stock	20.956	21.0096	20.738	20.888	24407750.0
2021-09-29 11:00:00	NVDA	Stock	20.886	20.898	20.467	20.611	28212080.0
2021-09-29 12:00:00	NVDA	Stock	20.614	20.651	20.499	20.595	15500860.0
2021-09-29 13:00:00	NVDA	Stock	20.594	20.675	20.4736	20.598	15892420.0
2021-09-29 14:00:00	NVDA	Stock	20.595	20.77	20.588	20.715	16599070.0
2021-09-29 15:00:00	NVDA	Stock	20.713	20.7339	20.468	20.517	20166330.0
2021-09-29 16:00:00	NVDA	Stock	20.517	20.574	20.513	20.567	12028940.0
2021-09-29 17:00:00	NVDA	Stock	20.557	20.565	20.531	20.54	60740.0
2021-09-29 18:00:00	NVDA	Stock	20.55	20.57	20.535	20.57	96460.0
2021-09-29 19:00:00	NVDA	Stock	20.564	20.649	20.552	20.646	233710.0
2021-09-29 04:00:00	AMZN	Stock	167.5	167.5	167.1	167.1	8480.0
2021-09-29 05:00:00	AMZN	Stock	167.5	167.5	167.3	167.3	10500.0

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

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