PREVIEW / stock_1hour / 2021-04-12

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-12.parquet
  size:    1.4 MB
  rows:    64,507
  symbols: 2,924

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-04-12 04:00:00	AAPL	Stock	132.99	132.99	132.56	132.6	39499.0
2021-04-12 05:00:00	AAPL	Stock	132.6	132.69	132.57	132.65	14322.0
2021-04-12 06:00:00	AAPL	Stock	132.66	132.68	132.06	132.18	45170.0
2021-04-12 07:00:00	AAPL	Stock	132.27	132.88	132.11	132.68	203039.0
2021-04-12 08:00:00	AAPL	Stock	132.3299	132.86	132.15	132.53	409699.0
2021-04-12 09:00:00	AAPL	Stock	132.52	132.85	131.37	131.65	12553802.0
2021-04-12 10:00:00	AAPL	Stock	131.64	132.235	131.05	131.175	11546228.0
2021-04-12 11:00:00	AAPL	Stock	131.18	131.43	130.63	130.98	9480053.0
2021-04-12 12:00:00	AAPL	Stock	130.98	131.86	130.84	131.85	7269204.0
2021-04-12 13:00:00	AAPL	Stock	131.84	132.27	131.45	131.5089	7604912.0
2021-04-12 14:00:00	AAPL	Stock	131.5	131.83	130.92	131.015	6312091.0
2021-04-12 15:00:00	AAPL	Stock	131.01	131.53	130.85	131.26	12607751.0
2021-04-12 16:00:00	AAPL	Stock	131.26	131.46	131.21	131.32	10944024.0
2021-04-12 17:00:00	AAPL	Stock	131.32	131.35	131.22	131.23	62043.0
2021-04-12 18:00:00	AAPL	Stock	131.24	131.39	131.22	131.26	40183.0
2021-04-12 19:00:00	AAPL	Stock	131.25	131.36	131.03	131.03	88914.0
2021-04-12 04:00:00	MSFT	Stock	256.16	256.5	256.0	256.5	3148.0
2021-04-12 05:00:00	MSFT	Stock	256.63	256.68	256.5	256.5	930.0
2021-04-12 06:00:00	MSFT	Stock	256.68	256.7	255.29	255.41	7777.0
2021-04-12 07:00:00	MSFT	Stock	255.5	255.98	255.25	255.25	15856.0
2021-04-12 08:00:00	MSFT	Stock	255.9999	256.5	255.01	255.87	36211.0
2021-04-12 09:00:00	MSFT	Stock	255.79	256.99	254.62	255.02	2932251.0
2021-04-12 10:00:00	MSFT	Stock	255.02	256.23	254.64	255.97	2169068.0
2021-04-12 11:00:00	MSFT	Stock	255.98	257.255	255.97	256.85	2115961.0
2021-04-12 12:00:00	MSFT	Stock	256.85	257.59	256.59	257.37	1533147.0
2021-04-12 13:00:00	MSFT	Stock	257.375	257.67	256.74	256.79	1520129.0
2021-04-12 14:00:00	MSFT	Stock	256.7925	257.0399	255.84	256.0663	1471962.0
2021-04-12 15:00:00	MSFT	Stock	256.0601	256.81	255.275	255.92	3606194.0
2021-04-12 16:00:00	MSFT	Stock	255.91	256.38	255.6	255.95	5132908.0
2021-04-12 17:00:00	MSFT	Stock	256.18	256.18	255.92	256.0	5016.0
2021-04-12 18:00:00	MSFT	Stock	256.04	256.15	255.91	255.97	5286.0
2021-04-12 19:00:00	MSFT	Stock	255.97	255.97	255.82	255.82	6243.0
2021-04-12 04:00:00	NVDA	Stock	14.3425	14.3425	14.3425	14.3425	4680.0
2021-04-12 06:00:00	NVDA	Stock	14.3475	14.3475	14.3188	14.325	12000.0
2021-04-12 07:00:00	NVDA	Stock	14.3188	14.375	14.3188	14.375	71240.0
2021-04-12 08:00:00	NVDA	Stock	14.375	14.375	14.3498	14.35	129800.0
2021-04-12 09:00:00	NVDA	Stock	14.3395	14.4122	14.192	14.2398	20306960.0
2021-04-12 10:00:00	NVDA	Stock	14.2429	14.2868	14.1393	14.2295	20970280.0
2021-04-12 11:00:00	NVDA	Stock	14.2295	14.3038	14.2162	14.275	17163800.0
2021-04-12 12:00:00	NVDA	Stock	14.2739	14.85	14.267	14.8322	137893520.0
2021-04-12 13:00:00	NVDA	Stock	14.8312	15.037	14.8008	14.932	117778600.0
2021-04-12 14:00:00	NVDA	Stock	14.9292	15.329	14.9235	15.2328	149076760.0
2021-04-12 15:00:00	NVDA	Stock	15.2303	15.3525	15.1848	15.2072	108786400.0
2021-04-12 16:00:00	NVDA	Stock	15.209	15.245	15.209	15.2282	24548960.0
2021-04-12 17:00:00	NVDA	Stock	15.2358	15.2375	15.171	15.1925	954400.0
2021-04-12 18:00:00	NVDA	Stock	15.1925	15.2235	15.175	15.19	878840.0
2021-04-12 19:00:00	NVDA	Stock	15.19	15.1948	15.1508	15.1512	790000.0
2021-04-12 04:00:00	AMZN	Stock	167.8	167.8	167.8	167.8	2000.0
2021-04-12 06:00:00	AMZN	Stock	168.0	168.0	167.997	167.997	4040.0
2021-04-12 07:00:00	AMZN	Stock	167.95	168.2575	167.9	168.0255	46620.0

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

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