PREVIEW / stock_1hour / 2021-07-08

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-08.parquet
  size:    1.5 MB
  rows:    68,258
  symbols: 2,871

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-07-08 04:00:00	AAPL	Stock	142.52	143.43	141.39	142.2	176515.0
2021-07-08 05:00:00	AAPL	Stock	142.23	142.61	141.9	142.28	177402.0
2021-07-08 06:00:00	AAPL	Stock	142.2	142.75	141.6	142.48	211854.0
2021-07-08 07:00:00	AAPL	Stock	142.42	142.7	141.75	141.75	464000.0
2021-07-08 08:00:00	AAPL	Stock	142.48	142.65	141.2	141.69	1362419.0
2021-07-08 09:00:00	AAPL	Stock	141.675	143.15	140.665	141.97	21241796.0
2021-07-08 10:00:00	AAPL	Stock	141.9666	142.35	141.48	141.58	13940471.0
2021-07-08 11:00:00	AAPL	Stock	141.61	142.73	141.49	142.6489	9057610.0
2021-07-08 12:00:00	AAPL	Stock	142.645	143.34	142.32	143.275	8121579.0
2021-07-08 13:00:00	AAPL	Stock	143.27	144.06	143.12	143.81	9077407.0
2021-07-08 14:00:00	AAPL	Stock	143.81	143.97	142.87	143.19	8149953.0
2021-07-08 15:00:00	AAPL	Stock	143.18	143.33	142.45	143.32	12061238.0
2021-07-08 16:00:00	AAPL	Stock	143.26	143.49	142.5322	143.29	6880338.0
2021-07-08 17:00:00	AAPL	Stock	143.29	143.32	143.25	143.28	29926.0
2021-07-08 18:00:00	AAPL	Stock	143.28	143.28	143.05	143.1	62853.0
2021-07-08 19:00:00	AAPL	Stock	143.08	143.25	143.0	143.0	77518.0
2021-07-08 04:00:00	MSFT	Stock	277.77	277.77	276.55	277.4	25022.0
2021-07-08 05:00:00	MSFT	Stock	277.5	278.3	276.14	276.8	28895.0
2021-07-08 06:00:00	MSFT	Stock	276.44	277.0	275.06	277.0	42961.0
2021-07-08 07:00:00	MSFT	Stock	277.18	277.41	276.0	276.0	80252.0
2021-07-08 08:00:00	MSFT	Stock	277.08	277.44	275.25	276.34	121414.0
2021-07-08 09:00:00	MSFT	Stock	276.42	278.73	276.08	277.65	3138133.0
2021-07-08 10:00:00	MSFT	Stock	277.63	277.93	275.27	275.39	2707907.0
2021-07-08 11:00:00	MSFT	Stock	275.41	277.48	274.87	277.39	2272940.0
2021-07-08 12:00:00	MSFT	Stock	277.4	277.74	276.92	277.525	1334147.0
2021-07-08 13:00:00	MSFT	Stock	277.53	278.22	277.26	278.03	1234750.0
2021-07-08 14:00:00	MSFT	Stock	278.03	278.135	277.25	277.54	1106123.0
2021-07-08 15:00:00	MSFT	Stock	277.56	277.8	276.64	277.53	3110923.0
2021-07-08 16:00:00	MSFT	Stock	277.42	277.79	277.42	277.79	3416315.0
2021-07-08 17:00:00	MSFT	Stock	277.7	277.8	277.7	277.8	400.0
2021-07-08 18:00:00	MSFT	Stock	277.7	277.7	277.49	277.49	6387.0
2021-07-08 19:00:00	MSFT	Stock	277.65	277.65	277.31	277.39	6430.0
2021-07-08 04:00:00	NVDA	Stock	20.0005	20.0005	19.775	19.9	321680.0
2021-07-08 05:00:00	NVDA	Stock	19.885	19.8993	19.845	19.8993	106760.0
2021-07-08 06:00:00	NVDA	Stock	19.9	19.9	19.6725	19.8385	480640.0
2021-07-08 07:00:00	NVDA	Stock	19.8025	19.9248	19.6978	19.7498	2068560.0
2021-07-08 08:00:00	NVDA	Stock	19.75	19.925	19.6888	19.8312	2976880.0
2021-07-08 09:00:00	NVDA	Stock	19.8252	20.05	19.7008	19.898	67557160.0
2021-07-08 10:00:00	NVDA	Stock	19.8964	19.9612	19.8	19.8379	46053160.0
2021-07-08 11:00:00	NVDA	Stock	19.8408	20.133	19.8058	20.1135	38322200.0
2021-07-08 12:00:00	NVDA	Stock	20.1173	20.12	19.9765	20.01	26812520.0
2021-07-08 13:00:00	NVDA	Stock	20.0173	20.0785	19.95	19.9682	26854880.0
2021-07-08 14:00:00	NVDA	Stock	19.9715	19.9908	19.8425	19.8966	25402240.0
2021-07-08 15:00:00	NVDA	Stock	19.8948	19.9163	19.7412	19.907	44514680.0
2021-07-08 16:00:00	NVDA	Stock	19.9028	19.9202	19.8648	19.8975	26319040.0
2021-07-08 17:00:00	NVDA	Stock	19.9	19.902	19.895	19.9005	78280.0
2021-07-08 18:00:00	NVDA	Stock	19.893	19.8963	19.89	19.89	36280.0
2021-07-08 19:00:00	NVDA	Stock	19.875	19.8975	19.875	19.8875	111040.0
2021-07-08 04:00:00	AMZN	Stock	182.5	182.5	181.49	181.49	24020.0
2021-07-08 05:00:00	AMZN	Stock	181.775	182.0025	181.775	182.0	15400.0

> showing 50 of 68,258 rows — these rows as CSV

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