PREVIEW / stock_1hour / 2021-06-28

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-28.parquet
  size:    1.5 MB
  rows:    67,920
  symbols: 2,973

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-06-28 04:00:00	AAPL	Stock	133.11	133.48	133.02	133.19	7847.0
2021-06-28 05:00:00	AAPL	Stock	133.14	133.16	133.1	133.15	2296.0
2021-06-28 06:00:00	AAPL	Stock	133.11	133.11	133.01	133.07	4637.0
2021-06-28 07:00:00	AAPL	Stock	133.08	133.3	133.0	133.17	84474.0
2021-06-28 08:00:00	AAPL	Stock	133.19	133.28	132.778	133.11	331541.0
2021-06-28 09:00:00	AAPL	Stock	133.22	135.04	133.13	134.9981	11676021.0
2021-06-28 10:00:00	AAPL	Stock	135.0	135.22	134.8	134.84	9798132.0
2021-06-28 11:00:00	AAPL	Stock	134.84	135.1783	134.78	134.885	5234744.0
2021-06-28 12:00:00	AAPL	Stock	134.89	135.2	134.84	134.9688	4026875.0
2021-06-28 13:00:00	AAPL	Stock	134.97	134.97	134.67	134.815	3695378.0
2021-06-28 14:00:00	AAPL	Stock	134.81	135.245	134.7	135.098	5165547.0
2021-06-28 15:00:00	AAPL	Stock	135.095	135.1	134.71	134.75	8796789.0
2021-06-28 16:00:00	AAPL	Stock	134.74	134.78	134.59	134.61	6456211.0
2021-06-28 17:00:00	AAPL	Stock	134.65	134.78	134.61	134.72	43573.0
2021-06-28 18:00:00	AAPL	Stock	134.7	134.7	134.6	134.65	27882.0
2021-06-28 19:00:00	AAPL	Stock	134.61	134.67	134.6	134.65	30595.0
2021-06-28 04:00:00	MSFT	Stock	265.83	265.99	265.8	265.89	1577.0
2021-06-28 05:00:00	MSFT	Stock	266.47	266.47	266.05	266.17	769.0
2021-06-28 06:00:00	MSFT	Stock	266.07	266.07	266.0	266.0	493.0
2021-06-28 07:00:00	MSFT	Stock	266.29	266.45	266.12	266.42	6743.0
2021-06-28 08:00:00	MSFT	Stock	266.4199	266.75	266.28	266.59	19591.0
2021-06-28 09:00:00	MSFT	Stock	266.655	268.47	265.91	267.75	2278076.0
2021-06-28 10:00:00	MSFT	Stock	267.79	268.39	267.44	267.55	1654089.0
2021-06-28 11:00:00	MSFT	Stock	267.5661	268.545	267.4441	268.3	1401496.0
2021-06-28 12:00:00	MSFT	Stock	268.3	268.59	267.9799	268.025	1147247.0
2021-06-28 13:00:00	MSFT	Stock	268.025	268.1583	267.735	267.7983	970666.0
2021-06-28 14:00:00	MSFT	Stock	267.79	268.29	267.64	268.26	1035266.0
2021-06-28 15:00:00	MSFT	Stock	268.265	268.9	267.72	268.72	3069246.0
2021-06-28 16:00:00	MSFT	Stock	268.72	268.89	268.68	268.72	3181481.0
2021-06-28 17:00:00	MSFT	Stock	268.73	268.7799	268.7	268.74	10005.0
2021-06-28 18:00:00	MSFT	Stock	268.72	268.72	268.45	268.56	4186.0
2021-06-28 19:00:00	MSFT	Stock	268.64	268.71	268.45	268.45	3099.0
2021-06-28 04:00:00	NVDA	Stock	19.15	19.1813	19.14	19.1813	67280.0
2021-06-28 05:00:00	NVDA	Stock	19.1963	19.1963	19.1788	19.1788	16000.0
2021-06-28 06:00:00	NVDA	Stock	19.1725	19.1725	19.1525	19.1525	26000.0
2021-06-28 07:00:00	NVDA	Stock	19.1285	19.2275	19.1285	19.2275	571560.0
2021-06-28 08:00:00	NVDA	Stock	19.2013	19.2978	19.1375	19.2978	1703840.0
2021-06-28 09:00:00	NVDA	Stock	19.2758	19.8038	19.2525	19.8038	76949920.0
2021-06-28 10:00:00	NVDA	Stock	19.7999	19.941	19.7828	19.8564	77513400.0
2021-06-28 11:00:00	NVDA	Stock	19.8575	20.022	19.8529	19.9762	40873880.0
2021-06-28 12:00:00	NVDA	Stock	19.9785	20.0788	19.9315	19.9949	27493080.0
2021-06-28 13:00:00	NVDA	Stock	19.9968	20.05	19.9438	19.978	22129160.0
2021-06-28 14:00:00	NVDA	Stock	19.975	20.0638	19.9585	20.0601	18540280.0
2021-06-28 15:00:00	NVDA	Stock	20.057	20.07	19.952	19.9855	31591920.0
2021-06-28 16:00:00	NVDA	Stock	19.997	20.0488	19.978	20.0218	26651040.0
2021-06-28 17:00:00	NVDA	Stock	20.0188	20.0443	19.9998	20.025	409640.0
2021-06-28 18:00:00	NVDA	Stock	20.0125	20.0125	19.9625	19.9625	315320.0
2021-06-28 19:00:00	NVDA	Stock	19.9675	19.9712	19.95	19.9583	292640.0
2021-06-28 07:00:00	AMZN	Stock	170.8495	170.85	170.7	170.75	18400.0
2021-06-28 08:00:00	AMZN	Stock	170.7	170.8975	170.6	170.735	78520.0

> showing 50 of 67,920 rows — these rows as CSV

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