PREVIEW / stock_1hour / 2004-07-23

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-23.parquet
  size:    505 KB
  rows:    24,160
  symbols: 1,789

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
2004-07-23 08:00:00	AAPL	Stock	0.5634	0.5634	0.5634	0.5634	33600.0
2004-07-23 09:00:00	AAPL	Stock	0.5639	0.567	0.5559	0.5566	19253192.0
2004-07-23 10:00:00	AAPL	Stock	0.5564	0.5625	0.5521	0.5616	53251800.0
2004-07-23 11:00:00	AAPL	Stock	0.5616	0.5621	0.5518	0.5559	33729472.0
2004-07-23 12:00:00	AAPL	Stock	0.5557	0.5559	0.5509	0.5546	24265584.0
2004-07-23 13:00:00	AAPL	Stock	0.5543	0.558	0.5488	0.5493	25345712.0
2004-07-23 14:00:00	AAPL	Stock	0.5493	0.5507	0.5473	0.5488	39454688.0
2004-07-23 15:00:00	AAPL	Stock	0.5486	0.5511	0.5443	0.5479	65701384.0
2004-07-23 16:00:00	AAPL	Stock	0.5475	0.5482	0.5455	0.5482	3583552.0
2004-07-23 17:00:00	AAPL	Stock	0.5482	0.5482	0.5482	0.5482	234080.0
2004-07-23 18:00:00	AAPL	Stock	0.55	0.55	0.55	0.55	11200.0
2004-07-23 08:00:00	MSFT	Stock	28.1	28.5	27.99	28.15	870985.0
2004-07-23 09:00:00	MSFT	Stock	28.15	28.4	28.14	28.18	17432788.0
2004-07-23 10:00:00	MSFT	Stock	28.17	28.22	28.05	28.19	17684455.0
2004-07-23 11:00:00	MSFT	Stock	28.19	28.27	28.05	28.25	14415139.0
2004-07-23 12:00:00	MSFT	Stock	28.26	28.26	28.13	28.17	9174841.0
2004-07-23 13:00:00	MSFT	Stock	28.17	28.22	28.12	28.16	6654190.0
2004-07-23 14:00:00	MSFT	Stock	28.16	28.23	28.0704	28.2	11483337.0
2004-07-23 15:00:00	MSFT	Stock	28.19	28.2	28.03	28.05	14908658.0
2004-07-23 16:00:00	MSFT	Stock	28.03	28.17	28.0	28.08	1033029.0
2004-07-23 17:00:00	MSFT	Stock	28.08	28.1	28.03	28.07	297517.0
2004-07-23 18:00:00	MSFT	Stock	28.08	28.1	28.07	28.1	1550.0
2004-07-23 08:00:00	NVDA	Stock	0.1239	0.124	0.1239	0.124	60000.0
2004-07-23 09:00:00	NVDA	Stock	0.1238	0.1262	0.1217	0.1222	47592840.0
2004-07-23 10:00:00	NVDA	Stock	0.1221	0.1242	0.1217	0.1235	69354120.0
2004-07-23 11:00:00	NVDA	Stock	0.1233	0.1241	0.1229	0.1238	39406440.0
2004-07-23 12:00:00	NVDA	Stock	0.1239	0.1241	0.1221	0.1234	45814560.0
2004-07-23 13:00:00	NVDA	Stock	0.1233	0.1242	0.1232	0.1234	27513720.0
2004-07-23 14:00:00	NVDA	Stock	0.1233	0.1235	0.1222	0.1227	35190720.0
2004-07-23 15:00:00	NVDA	Stock	0.1227	0.1227	0.121	0.1219	85034400.0
2004-07-23 16:00:00	NVDA	Stock	0.1219	0.1222	0.1208	0.1208	3733800.0
2004-07-23 17:00:00	NVDA	Stock	0.1218	0.1218	0.1218	0.1218	192000.0
2004-07-23 18:00:00	NVDA	Stock	0.1217	0.1217	0.1217	0.1217	12000.0
2004-07-23 08:00:00	AMZN	Stock	2.125	2.289	2.125	2.15	4842320.0
2004-07-23 09:00:00	AMZN	Stock	2.15	2.153	2.0755	2.13	161916540.0
2004-07-23 10:00:00	AMZN	Stock	2.1295	2.1325	2.07	2.092	133937640.0
2004-07-23 11:00:00	AMZN	Stock	2.0925	2.0925	2.056	2.068	65822000.0
2004-07-23 12:00:00	AMZN	Stock	2.068	2.07	2.0325	2.036	66717060.0
2004-07-23 13:00:00	AMZN	Stock	2.036	2.045	2.0075	2.014	67549220.0
2004-07-23 14:00:00	AMZN	Stock	2.014	2.0205	1.99	2.0005	73411000.0
2004-07-23 15:00:00	AMZN	Stock	2.0005	2.0145	1.978	2.001	124436940.0
2004-07-23 16:00:00	AMZN	Stock	2.0	2.0065	1.9945	2.005	8775040.0
2004-07-23 17:00:00	AMZN	Stock	1.9955	2.012	1.9955	2.0015	255820.0
2004-07-23 18:00:00	AMZN	Stock	2.008	2.01	2.008	2.01	40000.0
2004-07-23 09:00:00	CL	Stock	26.825	26.945	26.63	26.635	472800.0
2004-07-23 10:00:00	CL	Stock	26.64	26.64	26.38	26.55	963600.0
2004-07-23 11:00:00	CL	Stock	26.555	26.555	26.31	26.4	627600.0
2004-07-23 12:00:00	CL	Stock	26.4	26.425	26.26	26.28	708200.0
2004-07-23 13:00:00	CL	Stock	26.26	26.375	26.26	26.305	408800.0
2004-07-23 14:00:00	CL	Stock	26.305	26.37	26.16	26.235	676800.0

> showing 50 of 24,160 rows — these rows as CSV

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