PREVIEW / stock_1hour / 2006-09-01

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-09-01.parquet
  size:    608 KB
  rows:    29,790
  symbols: 2,349

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
2006-09-01 07:00:00	AAPL	Stock	2.4339	2.4339	2.4339	2.4339	2800.0
2006-09-01 08:00:00	AAPL	Stock	2.4304	2.4457	2.4232	2.4346	4431700.0
2006-09-01 09:00:00	AAPL	Stock	2.4357	2.4518	2.4357	2.4493	76223644.0
2006-09-01 10:00:00	AAPL	Stock	2.4493	2.4496	2.4268	2.4296	89096252.0
2006-09-01 11:00:00	AAPL	Stock	2.43	2.4368	2.4221	2.4354	71855504.0
2006-09-01 12:00:00	AAPL	Stock	2.4354	2.4379	2.4304	2.4372	34852384.0
2006-09-01 13:00:00	AAPL	Stock	2.4375	2.4389	2.4289	2.4339	28501256.0
2006-09-01 14:00:00	AAPL	Stock	2.4339	2.4368	2.4304	2.4357	33215532.0
2006-09-01 15:00:00	AAPL	Stock	2.4357	2.4425	2.4336	2.4411	59718008.0
2006-09-01 16:00:00	AAPL	Stock	2.4421	2.4425	2.4382	2.4396	1812076.0
2006-09-01 17:00:00	AAPL	Stock	2.4396	2.4421	2.4396	2.4421	52696.0
2006-09-01 18:00:00	AAPL	Stock	2.4421	2.4429	2.4421	2.4425	127960.0
2006-09-01 05:00:00	MSFT	Stock	25.71	25.71	25.71	25.71	100.0
2006-09-01 08:00:00	MSFT	Stock	25.65	25.75	25.65	25.75	179376.0
2006-09-01 09:00:00	MSFT	Stock	25.73	25.97	25.73	25.85	5907238.0
2006-09-01 10:00:00	MSFT	Stock	25.85	25.9	25.64	25.7	6522091.0
2006-09-01 11:00:00	MSFT	Stock	25.69	25.74	25.64	25.73	3471427.0
2006-09-01 12:00:00	MSFT	Stock	25.73	25.83	25.67	25.71	2589738.0
2006-09-01 13:00:00	MSFT	Stock	25.71	25.73	25.66	25.67	1685342.0
2006-09-01 14:00:00	MSFT	Stock	25.668	25.7	25.64	25.68	3223414.0
2006-09-01 15:00:00	MSFT	Stock	25.68	25.9	25.68	25.83	6392043.0
2006-09-01 16:00:00	MSFT	Stock	25.84	25.85	25.705	25.83	82418.0
2006-09-01 17:00:00	MSFT	Stock	25.81	25.81	25.8	25.8	3651.0
2006-09-01 18:00:00	MSFT	Stock	25.81	25.81	25.8	25.8	990.0
2006-09-01 08:00:00	NVDA	Stock	0.4852	0.49	0.4852	0.4852	1299480.0
2006-09-01 09:00:00	NVDA	Stock	0.4878	0.4895	0.4728	0.477	118118220.0
2006-09-01 10:00:00	NVDA	Stock	0.477	0.477	0.4637	0.4685	148236840.0
2006-09-01 11:00:00	NVDA	Stock	0.4683	0.47	0.463	0.4657	99885180.0
2006-09-01 12:00:00	NVDA	Stock	0.4657	0.4683	0.4643	0.4677	62460240.0
2006-09-01 13:00:00	NVDA	Stock	0.4677	0.4685	0.465	0.4662	45624300.0
2006-09-01 14:00:00	NVDA	Stock	0.4662	0.4677	0.464	0.4665	50111640.0
2006-09-01 15:00:00	NVDA	Stock	0.4665	0.4778	0.4645	0.4655	69177000.0
2006-09-01 16:00:00	NVDA	Stock	0.4647	0.47	0.4637	0.4637	252000.0
2006-09-01 17:00:00	NVDA	Stock	0.4655	0.4655	0.4638	0.465	214500.0
2006-09-01 18:00:00	NVDA	Stock	0.465	0.465	0.465	0.465	30000.0
2006-09-01 08:00:00	AMZN	Stock	1.5415	1.549	1.5415	1.5415	905000.0
2006-09-01 09:00:00	AMZN	Stock	1.5445	1.5775	1.54	1.577	24780680.0
2006-09-01 10:00:00	AMZN	Stock	1.577	1.58	1.5575	1.5655	22330320.0
2006-09-01 11:00:00	AMZN	Stock	1.5655	1.5735	1.5625	1.57	18951820.0
2006-09-01 12:00:00	AMZN	Stock	1.57	1.58	1.569	1.5785	10711140.0
2006-09-01 13:00:00	AMZN	Stock	1.5785	1.5835	1.577	1.582	12684060.0
2006-09-01 14:00:00	AMZN	Stock	1.582	1.589	1.5805	1.5875	14416100.0
2006-09-01 15:00:00	AMZN	Stock	1.5875	1.59	1.585	1.5895	20705500.0
2006-09-01 16:00:00	AMZN	Stock	1.589	1.5905	1.5732	1.589	136020.0
2006-09-01 18:00:00	AMZN	Stock	1.59	1.59	1.59	1.59	10000.0
2006-09-01 08:00:00	CL	Stock	29.93	29.93	29.93	29.93	11400.0
2006-09-01 09:00:00	CL	Stock	30.16	30.175	29.99	30.055	366800.0
2006-09-01 10:00:00	CL	Stock	30.07	30.15	30.035	30.04	488800.0
2006-09-01 11:00:00	CL	Stock	30.04	30.15	30.0	30.105	403600.0
2006-09-01 12:00:00	CL	Stock	30.105	30.22	30.085	30.22	324800.0

> showing 50 of 29,790 rows — these rows as CSV

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