PREVIEW / stock_1hour / 2021-08-09

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-09.parquet
  size:    1.4 MB
  rows:    65,645
  symbols: 2,798

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-09 04:00:00	AAPL	Stock	145.98	146.05	145.74	146.0	8389.0
2021-08-09 05:00:00	AAPL	Stock	145.98	146.02	145.94	146.02	5618.0
2021-08-09 06:00:00	AAPL	Stock	146.01	146.09	145.93	146.02	5719.0
2021-08-09 07:00:00	AAPL	Stock	146.0	146.06	145.89	146.03	49826.0
2021-08-09 08:00:00	AAPL	Stock	145.9001	146.25	145.83	146.16	1263659.0
2021-08-09 09:00:00	AAPL	Stock	146.16	146.7	145.52	146.51	8030792.0
2021-08-09 10:00:00	AAPL	Stock	146.51	146.69	145.95	146.0613	7514129.0
2021-08-09 11:00:00	AAPL	Stock	146.0643	146.16	145.79	146.1369	4867271.0
2021-08-09 12:00:00	AAPL	Stock	146.1398	146.15	145.785	145.855	2952490.0
2021-08-09 13:00:00	AAPL	Stock	145.85	146.09	145.81	145.835	2702220.0
2021-08-09 14:00:00	AAPL	Stock	145.8381	146.13	145.79	146.055	3193673.0
2021-08-09 15:00:00	AAPL	Stock	146.045	146.18	145.87	146.09	5527364.0
2021-08-09 16:00:00	AAPL	Stock	146.09	146.18	146.0	146.04	7117472.0
2021-08-09 17:00:00	AAPL	Stock	146.05	146.05	146.0	146.02	11666.0
2021-08-09 18:00:00	AAPL	Stock	146.03	146.05	146.01	146.02	21531.0
2021-08-09 19:00:00	AAPL	Stock	146.04	146.04	145.95	146.02	13901.0
2021-08-09 04:00:00	MSFT	Stock	289.2	290.67	289.2	290.5	13082.0
2021-08-09 05:00:00	MSFT	Stock	290.21	290.38	290.08	290.08	1394.0
2021-08-09 06:00:00	MSFT	Stock	290.37	290.38	290.0	290.28	2953.0
2021-08-09 07:00:00	MSFT	Stock	290.02	290.38	289.93	290.3	6288.0
2021-08-09 08:00:00	MSFT	Stock	289.9601	290.36	289.8301	289.91	28986.0
2021-08-09 09:00:00	MSFT	Stock	289.95	291.55	288.8098	289.33	1897671.0
2021-08-09 10:00:00	MSFT	Stock	289.35	289.65	288.54	288.8	1824640.0
2021-08-09 11:00:00	MSFT	Stock	288.8001	289.02	288.2	288.46	1119856.0
2021-08-09 12:00:00	MSFT	Stock	288.47	288.6	287.81	287.91	1024872.0
2021-08-09 13:00:00	MSFT	Stock	287.92	288.24	287.92	288.145	774189.0
2021-08-09 14:00:00	MSFT	Stock	288.14	288.575	288.03	288.385	822947.0
2021-08-09 15:00:00	MSFT	Stock	288.38	288.5773	288.13	288.36	1485693.0
2021-08-09 16:00:00	MSFT	Stock	288.33	288.41	288.17	288.24	2750844.0
2021-08-09 17:00:00	MSFT	Stock	288.3	288.44	288.3	288.3	1815.0
2021-08-09 18:00:00	MSFT	Stock	288.39	288.39	288.21	288.21	3309.0
2021-08-09 19:00:00	MSFT	Stock	288.3299	288.35	288.18	288.28	5571.0
2021-08-09 04:00:00	NVDA	Stock	20.335	20.53	20.285	20.51	35110.0
2021-08-09 05:00:00	NVDA	Stock	20.524	20.524	20.445	20.512	46790.0
2021-08-09 06:00:00	NVDA	Stock	20.524	20.599	20.51	20.536	85790.0
2021-08-09 07:00:00	NVDA	Stock	20.531	20.572	20.44	20.475	428660.0
2021-08-09 08:00:00	NVDA	Stock	20.545	20.566	20.401	20.458	490190.0
2021-08-09 09:00:00	NVDA	Stock	20.4474	20.508	20.143	20.473	19596920.0
2021-08-09 10:00:00	NVDA	Stock	20.468	20.495	20.311	20.378	24509600.0
2021-08-09 11:00:00	NVDA	Stock	20.378	20.408	20.295	20.361	12722240.0
2021-08-09 12:00:00	NVDA	Stock	20.363	20.409	20.288	20.319	9396490.0
2021-08-09 13:00:00	NVDA	Stock	20.32	20.345	20.264	20.31	8574870.0
2021-08-09 14:00:00	NVDA	Stock	20.3105	20.334	20.269	20.311	6621170.0
2021-08-09 15:00:00	NVDA	Stock	20.3055	20.348	20.282	20.295	13582050.0
2021-08-09 16:00:00	NVDA	Stock	20.295	20.297	20.264	20.279	11726130.0
2021-08-09 17:00:00	NVDA	Stock	20.268	20.292	20.268	20.281	15250.0
2021-08-09 18:00:00	NVDA	Stock	20.288	20.292	20.281	20.29	36580.0
2021-08-09 19:00:00	NVDA	Stock	20.29	20.33	20.28	20.33	52380.0
2021-08-09 04:00:00	AMZN	Stock	167.245	167.245	167.245	167.245	2000.0
2021-08-09 05:00:00	AMZN	Stock	167.45	167.45	167.45	167.45	2000.0

> showing 50 of 65,645 rows — these rows as CSV

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