PREVIEW / stock_1hour / 2021-08-06

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-06.parquet
  size:    1.4 MB
  rows:    64,636
  symbols: 2,804

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-08-06 04:00:00	AAPL	Stock	146.5	146.95	146.5	146.76	13973.0
2021-08-06 05:00:00	AAPL	Stock	146.76	146.84	146.57	146.72	5641.0
2021-08-06 06:00:00	AAPL	Stock	146.7	146.7	146.53	146.53	4753.0
2021-08-06 07:00:00	AAPL	Stock	146.65	146.82	146.6	146.65	47925.0
2021-08-06 08:00:00	AAPL	Stock	146.6001	146.85	146.06	146.34	415085.0
2021-08-06 09:00:00	AAPL	Stock	146.33	146.86	145.9	146.59	8213133.0
2021-08-06 10:00:00	AAPL	Stock	146.59	147.11	146.4	146.53	6686653.0
2021-08-06 11:00:00	AAPL	Stock	146.54	146.7	145.97	146.29	5816869.0
2021-08-06 12:00:00	AAPL	Stock	146.2891	146.33	145.91	146.1	3571460.0
2021-08-06 13:00:00	AAPL	Stock	146.1006	146.235	145.72	145.94	3453359.0
2021-08-06 14:00:00	AAPL	Stock	145.9414	145.97	145.63	145.71	3385888.0
2021-08-06 15:00:00	AAPL	Stock	145.71	146.16	145.66	146.14	7527963.0
2021-08-06 16:00:00	AAPL	Stock	146.09	146.14	145.97	146.0	6759036.0
2021-08-06 17:00:00	AAPL	Stock	146.0	146.01	145.92	145.94	43728.0
2021-08-06 18:00:00	AAPL	Stock	145.97	145.97	145.9	145.95	16888.0
2021-08-06 19:00:00	AAPL	Stock	145.94	145.99	145.92	145.96	20174.0
2021-08-06 04:00:00	MSFT	Stock	289.8	290.02	289.5	290.02	12383.0
2021-08-06 05:00:00	MSFT	Stock	290.09	290.3	289.91	290.3	7594.0
2021-08-06 06:00:00	MSFT	Stock	290.06	290.06	289.55	289.61	6598.0
2021-08-06 07:00:00	MSFT	Stock	289.79	289.79	289.45	289.51	5765.0
2021-08-06 08:00:00	MSFT	Stock	289.6001	290.243	288.06	288.5	56591.0
2021-08-06 09:00:00	MSFT	Stock	288.5	289.5	288.05	288.5499	1628144.0
2021-08-06 10:00:00	MSFT	Stock	288.54	288.92	287.6238	287.91	1461350.0
2021-08-06 11:00:00	MSFT	Stock	287.93	288.45	287.71	288.415	997289.0
2021-08-06 12:00:00	MSFT	Stock	288.42	288.5182	287.97	288.33	661001.0
2021-08-06 13:00:00	MSFT	Stock	288.34	288.47	288.09	288.25	561980.0
2021-08-06 14:00:00	MSFT	Stock	288.27	288.48	288.025	288.1599	796081.0
2021-08-06 15:00:00	MSFT	Stock	288.14	289.49	288.06	289.46	2057042.0
2021-08-06 16:00:00	MSFT	Stock	289.46	289.46	289.0	289.23	2464211.0
2021-08-06 17:00:00	MSFT	Stock	289.12	289.3	289.12	289.25	7463.0
2021-08-06 18:00:00	MSFT	Stock	289.3	289.3	289.2	289.25	4712.0
2021-08-06 19:00:00	MSFT	Stock	289.15	289.25	289.12	289.12	1220.0
2021-08-06 04:00:00	NVDA	Stock	20.675	20.719	20.675	20.7	7140.0
2021-08-06 05:00:00	NVDA	Stock	20.704	20.704	20.66	20.675	22280.0
2021-08-06 06:00:00	NVDA	Stock	20.69	20.69	20.656	20.656	22370.0
2021-08-06 07:00:00	NVDA	Stock	20.675	20.721	20.625	20.688	233280.0
2021-08-06 08:00:00	NVDA	Stock	20.65	20.73	20.47	20.502	904080.0
2021-08-06 09:00:00	NVDA	Stock	20.52	20.574	20.345	20.4711	29498480.0
2021-08-06 10:00:00	NVDA	Stock	20.471	20.562	20.365	20.374	28313200.0
2021-08-06 11:00:00	NVDA	Stock	20.375	20.449	20.21	20.4365	24358710.0
2021-08-06 12:00:00	NVDA	Stock	20.439	20.466	20.373	20.454	10219860.0
2021-08-06 13:00:00	NVDA	Stock	20.4544	20.491	20.382	20.42	7287830.0
2021-08-06 14:00:00	NVDA	Stock	20.416	20.459	20.342	20.3615	8444150.0
2021-08-06 15:00:00	NVDA	Stock	20.36	20.431	20.351	20.364	14757440.0
2021-08-06 16:00:00	NVDA	Stock	20.366	20.366	20.33	20.351	10592210.0
2021-08-06 17:00:00	NVDA	Stock	20.355	20.366	20.336	20.366	297820.0
2021-08-06 18:00:00	NVDA	Stock	20.345	20.356	20.345	20.356	34680.0
2021-08-06 19:00:00	NVDA	Stock	20.354	20.356	20.275	20.336	157920.0
2021-08-06 07:00:00	AMZN	Stock	168.993	168.993	168.9425	168.9425	10760.0
2021-08-06 08:00:00	AMZN	Stock	168.805	169.2214	168.1	168.35	178560.0

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

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