PREVIEW / stock_1hour / 2004-07-19

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-19.parquet
  size:    501 KB
  rows:    23,704
  symbols: 1,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
2004-07-19 08:00:00	AAPL	Stock	0.5754	0.5754	0.57	0.5714	909440.0
2004-07-19 09:00:00	AAPL	Stock	0.5714	0.5734	0.5659	0.5698	109768624.0
2004-07-19 10:00:00	AAPL	Stock	0.5698	0.5732	0.5686	0.5727	78954904.0
2004-07-19 11:00:00	AAPL	Stock	0.573	0.5754	0.5707	0.5713	73733632.0
2004-07-19 12:00:00	AAPL	Stock	0.5714	0.5725	0.5689	0.5693	53148480.0
2004-07-19 13:00:00	AAPL	Stock	0.5693	0.5696	0.5654	0.5664	45308592.0
2004-07-19 14:00:00	AAPL	Stock	0.5661	0.5738	0.5661	0.5729	85681456.0
2004-07-19 15:00:00	AAPL	Stock	0.5729	0.5738	0.5693	0.5704	52675728.0
2004-07-19 16:00:00	AAPL	Stock	0.5705	0.5723	0.5696	0.5709	4538744.0
2004-07-19 17:00:00	AAPL	Stock	0.5732	0.5732	0.5729	0.5729	67200.0
2004-07-19 08:00:00	MSFT	Stock	27.55	27.6	27.5	27.57	48669.0
2004-07-19 09:00:00	MSFT	Stock	27.6	27.79	27.54	27.78	7478028.0
2004-07-19 10:00:00	MSFT	Stock	27.77	27.91	27.74	27.87	10181418.0
2004-07-19 11:00:00	MSFT	Stock	27.87	27.92	27.73	27.77	6660671.0
2004-07-19 12:00:00	MSFT	Stock	27.77	27.87	27.68	27.86	6902521.0
2004-07-19 13:00:00	MSFT	Stock	27.86	27.92	27.75	27.84	5546791.0
2004-07-19 14:00:00	MSFT	Stock	27.84	28.26	27.83	28.13	12027503.0
2004-07-19 15:00:00	MSFT	Stock	28.13	28.14	27.93	27.96	9406390.0
2004-07-19 16:00:00	MSFT	Stock	27.96	28.04	27.9	27.95	378371.0
2004-07-19 17:00:00	MSFT	Stock	27.95	28.06	27.95	28.01	37850.0
2004-07-19 18:00:00	MSFT	Stock	28.0	28.04	28.0	28.04	2600.0
2004-07-19 08:00:00	NVDA	Stock	0.1282	0.1282	0.1273	0.1275	2366040.0
2004-07-19 09:00:00	NVDA	Stock	0.1275	0.1293	0.1268	0.1282	49220760.0
2004-07-19 10:00:00	NVDA	Stock	0.1283	0.129	0.1265	0.1268	51229680.0
2004-07-19 11:00:00	NVDA	Stock	0.1267	0.1272	0.1259	0.1259	45619440.0
2004-07-19 12:00:00	NVDA	Stock	0.126	0.1263	0.1251	0.1257	38953800.0
2004-07-19 13:00:00	NVDA	Stock	0.1257	0.1262	0.1254	0.1259	34245720.0
2004-07-19 14:00:00	NVDA	Stock	0.126	0.1292	0.1256	0.1285	119392200.0
2004-07-19 15:00:00	NVDA	Stock	0.1285	0.1287	0.1273	0.1278	95684160.0
2004-07-19 16:00:00	NVDA	Stock	0.1278	0.1283	0.1277	0.1279	4473000.0
2004-07-19 17:00:00	NVDA	Stock	0.1279	0.1279	0.1279	0.1279	12000.0
2004-07-19 08:00:00	AMZN	Stock	2.3575	2.3795	2.3575	2.3575	56000.0
2004-07-19 09:00:00	AMZN	Stock	2.3565	2.364	2.322	2.3335	25778140.0
2004-07-19 10:00:00	AMZN	Stock	2.334	2.342	2.272	2.2795	53687760.0
2004-07-19 11:00:00	AMZN	Stock	2.279	2.3085	2.274	2.275	24676040.0
2004-07-19 12:00:00	AMZN	Stock	2.275	2.2885	2.2575	2.2765	22459100.0
2004-07-19 13:00:00	AMZN	Stock	2.2765	2.286	2.2645	2.27	11022040.0
2004-07-19 14:00:00	AMZN	Stock	2.269	2.3185	2.2655	2.3012	28499260.0
2004-07-19 15:00:00	AMZN	Stock	2.3005	2.31	2.295	2.3035	23857480.0
2004-07-19 16:00:00	AMZN	Stock	2.3015	2.3075	2.3	2.301	2798200.0
2004-07-19 17:00:00	AMZN	Stock	2.3051	2.3051	2.3	2.3	328860.0
2004-07-19 18:00:00	AMZN	Stock	2.2955	2.2955	2.2955	2.2955	2000.0
2004-07-19 09:00:00	CL	Stock	28.21	28.255	28.15	28.255	164400.0
2004-07-19 10:00:00	CL	Stock	28.235	28.31	28.16	28.265	209400.0
2004-07-19 11:00:00	CL	Stock	28.25	28.26	28.06	28.06	147600.0
2004-07-19 12:00:00	CL	Stock	28.065	28.11	28.015	28.055	171200.0
2004-07-19 13:00:00	CL	Stock	28.045	28.075	28.005	28.03	175400.0
2004-07-19 14:00:00	CL	Stock	28.025	28.135	28.015	28.09	305400.0
2004-07-19 15:00:00	CL	Stock	28.1	28.125	28.005	28.075	583200.0
2004-07-19 16:00:00	CL	Stock	28.115	28.115	28.05	28.065	21200.0

> showing 50 of 23,704 rows — these rows as CSV

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