PREVIEW / stock_1hour / 2006-07-20

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-07-20.parquet
  size:    616 KB
  rows:    29,495
  symbols: 2,302

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-07-20 04:00:00	AAPL	Stock	2.1071	2.1214	2.1071	2.1214	16800.0
2006-07-20 05:00:00	AAPL	Stock	2.1218	2.1218	2.1071	2.1125	126000.0
2006-07-20 06:00:00	AAPL	Stock	2.125	2.1264	2.1229	2.1264	86800.0
2006-07-20 07:00:00	AAPL	Stock	2.1232	2.1482	2.1179	2.1439	2479652.0
2006-07-20 08:00:00	AAPL	Stock	2.1436	2.185	2.1275	2.1757	69608084.0
2006-07-20 09:00:00	AAPL	Stock	2.1757	2.1875	2.1443	2.1475	470429652.0
2006-07-20 10:00:00	AAPL	Stock	2.1475	2.1825	2.1329	2.1768	411886580.0
2006-07-20 11:00:00	AAPL	Stock	2.1775	2.1832	2.1618	2.1675	224933380.0
2006-07-20 12:00:00	AAPL	Stock	2.1671	2.1996	2.1579	2.1868	151695880.0
2006-07-20 13:00:00	AAPL	Stock	2.1868	2.1929	2.1614	2.1714	189163856.0
2006-07-20 14:00:00	AAPL	Stock	2.1711	2.1821	2.1657	2.1768	183032052.0
2006-07-20 15:00:00	AAPL	Stock	2.1768	2.1814	2.1596	2.1618	245575848.0
2006-07-20 16:00:00	AAPL	Stock	2.1618	2.1732	2.1586	2.1721	6720252.0
2006-07-20 17:00:00	AAPL	Stock	2.1696	2.1754	2.1679	2.1679	1656060.0
2006-07-20 18:00:00	AAPL	Stock	2.1696	2.1714	2.1679	2.1714	194320.0
2006-07-20 08:00:00	MSFT	Stock	23.49	23.54	23.4	23.49	49798.0
2006-07-20 09:00:00	MSFT	Stock	23.44	23.5	22.97	22.99	7425348.0
2006-07-20 10:00:00	MSFT	Stock	22.99	23.04	22.84	23.0	11526197.0
2006-07-20 11:00:00	MSFT	Stock	22.99	23.1	22.87	23.07	5341118.0
2006-07-20 12:00:00	MSFT	Stock	23.079	23.09	22.94	22.99	5173939.0
2006-07-20 13:00:00	MSFT	Stock	22.99	23.01	22.89	22.99	6262698.0
2006-07-20 14:00:00	MSFT	Stock	22.99	23.04	22.9	22.9	6661575.0
2006-07-20 15:00:00	MSFT	Stock	22.9	23.09	22.78	22.86	16590058.0
2006-07-20 16:00:00	MSFT	Stock	22.88	24.62	22.6	24.2	11757517.0
2006-07-20 17:00:00	MSFT	Stock	24.2	24.26	24.15	24.2	3932666.0
2006-07-20 18:00:00	MSFT	Stock	24.2	24.2	24.1	24.11	118675.0
2006-07-20 06:00:00	NVDA	Stock	0.3417	0.3417	0.3417	0.3417	30000.0
2006-07-20 07:00:00	NVDA	Stock	0.3417	0.3417	0.3383	0.3383	54000.0
2006-07-20 08:00:00	NVDA	Stock	0.3383	0.3383	0.3297	0.3303	2615220.0
2006-07-20 09:00:00	NVDA	Stock	0.3308	0.3383	0.3268	0.328	78743160.0
2006-07-20 10:00:00	NVDA	Stock	0.3283	0.3322	0.3215	0.3315	120579840.0
2006-07-20 11:00:00	NVDA	Stock	0.3315	0.3328	0.3278	0.3317	62266380.0
2006-07-20 12:00:00	NVDA	Stock	0.3318	0.332	0.3275	0.33	56402220.0
2006-07-20 13:00:00	NVDA	Stock	0.3298	0.3367	0.3215	0.3228	48795120.0
2006-07-20 14:00:00	NVDA	Stock	0.323	0.3267	0.3223	0.3232	45657120.0
2006-07-20 15:00:00	NVDA	Stock	0.3232	0.326	0.3197	0.3202	70743360.0
2006-07-20 16:00:00	NVDA	Stock	0.3202	0.3225	0.3165	0.3177	2251620.0
2006-07-20 17:00:00	NVDA	Stock	0.322	0.322	0.3168	0.3175	234780.0
2006-07-20 18:00:00	NVDA	Stock	0.3175	0.3175	0.3175	0.3175	137220.0
2006-07-20 08:00:00	AMZN	Stock	1.7265	1.7265	1.7205	1.7205	18000.0
2006-07-20 09:00:00	AMZN	Stock	1.7235	1.74	1.6965	1.6995	11786400.0
2006-07-20 10:00:00	AMZN	Stock	1.7	1.7405	1.6915	1.724	23823500.0
2006-07-20 11:00:00	AMZN	Stock	1.7235	1.726	1.7105	1.7145	10211460.0
2006-07-20 12:00:00	AMZN	Stock	1.715	1.7185	1.7	1.7095	8601820.0
2006-07-20 13:00:00	AMZN	Stock	1.7095	1.7315	1.7085	1.713	11129620.0
2006-07-20 14:00:00	AMZN	Stock	1.713	1.7285	1.7105	1.7205	18772660.0
2006-07-20 15:00:00	AMZN	Stock	1.72	1.7285	1.709	1.71	30152960.0
2006-07-20 16:00:00	AMZN	Stock	1.709	1.716	1.709	1.7125	472380.0
2006-07-20 09:00:00	CL	Stock	31.04	31.09	30.805	30.925	328600.0
2006-07-20 10:00:00	CL	Stock	30.925	31.345	30.905	31.345	371800.0

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

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