PREVIEW / stock_1hour / 2021-12-28

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-28.parquet
  size:    1.4 MB
  rows:    64,650
  symbols: 2,642

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-12-28 04:00:00	AAPL	Stock	180.25	181.16	180.24	181.12	35008.0
2021-12-28 05:00:00	AAPL	Stock	181.1	181.25	181.0	181.2	14020.0
2021-12-28 06:00:00	AAPL	Stock	181.07	181.13	180.75	180.85	17244.0
2021-12-28 07:00:00	AAPL	Stock	180.77	181.07	180.65	180.89	115311.0
2021-12-28 08:00:00	AAPL	Stock	180.8399	181.03	180.19	180.21	454415.0
2021-12-28 09:00:00	AAPL	Stock	180.23	180.43	178.9	179.98	9763221.0
2021-12-28 10:00:00	AAPL	Stock	179.99	180.16	178.53	179.9	11109116.0
2021-12-28 11:00:00	AAPL	Stock	179.89	181.33	179.6901	180.52	13250111.0
2021-12-28 12:00:00	AAPL	Stock	180.52	180.66	179.28	179.49	8177483.0
2021-12-28 13:00:00	AAPL	Stock	179.48	180.03	179.28	179.7556	5903152.0
2021-12-28 14:00:00	AAPL	Stock	179.74	179.75	179.07	179.5	6226819.0
2021-12-28 15:00:00	AAPL	Stock	179.5	179.82	179.14	179.39	10096707.0
2021-12-28 16:00:00	AAPL	Stock	179.29	179.69	179.2	179.54	4169970.0
2021-12-28 17:00:00	AAPL	Stock	179.55	179.6	179.45	179.45	25798.0
2021-12-28 18:00:00	AAPL	Stock	179.49	179.82	179.48	179.77	58389.0
2021-12-28 19:00:00	AAPL	Stock	179.78	179.85	179.63	179.85	48059.0
2021-12-28 04:00:00	MSFT	Stock	343.0	343.77	343.0	343.6	1576.0
2021-12-28 05:00:00	MSFT	Stock	343.55	344.0	343.55	343.97	1945.0
2021-12-28 06:00:00	MSFT	Stock	343.75	343.8	343.03	343.1	3562.0
2021-12-28 07:00:00	MSFT	Stock	343.68	344.32	343.55	344.2	21949.0
2021-12-28 08:00:00	MSFT	Stock	343.8962	344.4	343.1	343.3	44571.0
2021-12-28 09:00:00	MSFT	Stock	343.26	343.81	340.32	343.0	1812406.0
2021-12-28 10:00:00	MSFT	Stock	343.0	343.1272	340.93	342.37	1482188.0
2021-12-28 11:00:00	MSFT	Stock	342.38	343.11	341.02	342.71	1182550.0
2021-12-28 12:00:00	MSFT	Stock	342.7	343.01	340.77	341.5	933600.0
2021-12-28 13:00:00	MSFT	Stock	341.49	341.7257	341.02	341.19	711583.0
2021-12-28 14:00:00	MSFT	Stock	341.17	341.59	340.56	341.435	835492.0
2021-12-28 15:00:00	MSFT	Stock	341.45	342.29	340.79	341.25	1952603.0
2021-12-28 16:00:00	MSFT	Stock	341.25	341.99	341.25	341.89	2363195.0
2021-12-28 17:00:00	MSFT	Stock	341.72	341.87	341.72	341.82	3383.0
2021-12-28 18:00:00	MSFT	Stock	341.86	342.85	341.86	342.85	11362.0
2021-12-28 19:00:00	MSFT	Stock	342.77	344.6	342.44	343.29	8911.0
2021-12-28 04:00:00	NVDA	Stock	31.1	31.47	31.1	31.444	345120.0
2021-12-28 05:00:00	NVDA	Stock	31.44	31.45	31.356	31.405	76250.0
2021-12-28 06:00:00	NVDA	Stock	31.408	31.414	31.277	31.32	84620.0
2021-12-28 07:00:00	NVDA	Stock	31.341	31.455	31.227	31.381	801760.0
2021-12-28 08:00:00	NVDA	Stock	31.438	31.458	31.0223	31.271	2196110.0
2021-12-28 09:00:00	NVDA	Stock	31.266	31.375	30.441	30.8649	56200890.0
2021-12-28 10:00:00	NVDA	Stock	30.874	30.8949	30.255	30.502	53970200.0
2021-12-28 11:00:00	NVDA	Stock	30.5045	30.636	30.085	30.345	41928220.0
2021-12-28 12:00:00	NVDA	Stock	30.343	30.3866	30.02	30.167	31704360.0
2021-12-28 13:00:00	NVDA	Stock	30.166	30.2319	30.0118	30.225	23261750.0
2021-12-28 14:00:00	NVDA	Stock	30.2231	30.51	30.112	30.4348	32532780.0
2021-12-28 15:00:00	NVDA	Stock	30.44	30.569	30.259	30.322	45574200.0
2021-12-28 16:00:00	NVDA	Stock	30.322	30.405	30.23	30.37	12153460.0
2021-12-28 17:00:00	NVDA	Stock	30.37	30.37	30.33	30.33	157150.0
2021-12-28 18:00:00	NVDA	Stock	30.34	30.446	30.335	30.427	328970.0
2021-12-28 19:00:00	NVDA	Stock	30.437	30.5	30.412	30.5	444100.0
2021-12-28 04:00:00	AMZN	Stock	169.695	169.695	169.695	169.695	5800.0
2021-12-28 07:00:00	AMZN	Stock	169.9	170.0935	169.9	170.0435	18080.0

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

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