PREVIEW / stock_1hour / 2009-12-04

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-12-04.parquet
  size:    890 KB
  rows:    42,176
  symbols: 3,435

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
2009-12-04 04:00:00	AAPL	Stock	7.0136	7.0136	7.0136	7.0136	2800.0
2009-12-04 07:00:00	AAPL	Stock	7.0104	7.0107	7.0004	7.0004	168504.0
2009-12-04 08:00:00	AAPL	Stock	7.0039	7.1429	6.9911	7.1179	10299800.0
2009-12-04 09:00:00	AAPL	Stock	7.1193	7.1411	7.0929	7.1214	75227516.0
2009-12-04 10:00:00	AAPL	Stock	7.1225	7.1254	7.0382	7.0538	94228400.0
2009-12-04 11:00:00	AAPL	Stock	7.0532	7.0554	6.7957	6.871	240175964.0
2009-12-04 12:00:00	AAPL	Stock	6.8704	6.9204	6.8464	6.9071	120193556.0
2009-12-04 13:00:00	AAPL	Stock	6.9071	6.9111	6.8575	6.8632	71538348.0
2009-12-04 14:00:00	AAPL	Stock	6.8629	6.9057	6.8436	6.9039	83447532.0
2009-12-04 15:00:00	AAPL	Stock	6.9046	6.9286	6.8904	6.9043	114008132.0
2009-12-04 16:00:00	AAPL	Stock	6.9032	6.9423	6.9032	6.915	9293172.0
2009-12-04 17:00:00	AAPL	Stock	6.9121	6.9154	6.9089	6.9104	315196.0
2009-12-04 18:00:00	AAPL	Stock	6.9104	6.9154	6.9043	6.9154	441728.0
2009-12-04 19:00:00	AAPL	Stock	6.9114	6.9161	6.9111	6.9154	181636.0
2009-12-04 08:00:00	MSFT	Stock	29.85	30.1	29.8	30.08	151661.0
2009-12-04 09:00:00	MSFT	Stock	30.08	30.28	30.0	30.27	7468326.0
2009-12-04 10:00:00	MSFT	Stock	30.27	30.37	30.22	30.24	9225775.0
2009-12-04 11:00:00	MSFT	Stock	30.245	30.27	29.85	29.97	13653568.0
2009-12-04 12:00:00	MSFT	Stock	29.97	30.09	29.94	29.95	5324658.0
2009-12-04 13:00:00	MSFT	Stock	29.95	30.03	29.87	29.9	4901276.0
2009-12-04 14:00:00	MSFT	Stock	29.92	29.99	29.83	29.98	6421996.0
2009-12-04 15:00:00	MSFT	Stock	29.97	30.11	29.94	29.98	8988788.0
2009-12-04 16:00:00	MSFT	Stock	29.98	30.118	29.97	29.98	1486297.0
2009-12-04 17:00:00	MSFT	Stock	29.96	30.0	29.87	29.87	1300.0
2009-12-04 18:00:00	MSFT	Stock	29.87	29.87	29.85	29.85	1021.0
2009-12-04 19:00:00	MSFT	Stock	29.92	29.98	29.9	29.98	4299.0
2009-12-04 20:00:00	MSFT	Stock	30.03	30.03	30.03	30.03	4874.0
2009-12-04 08:00:00	NVDA	Stock	0.3448	0.3533	0.325	0.3533	181000.0
2009-12-04 09:00:00	NVDA	Stock	0.3528	0.3542	0.3518	0.353	83534600.0
2009-12-04 10:00:00	NVDA	Stock	0.353	0.358	0.3515	0.3572	158335080.0
2009-12-04 11:00:00	NVDA	Stock	0.3574	0.3574	0.3468	0.3542	198573840.0
2009-12-04 12:00:00	NVDA	Stock	0.354	0.3572	0.3528	0.355	78711440.0
2009-12-04 13:00:00	NVDA	Stock	0.355	0.3572	0.352	0.3522	84749840.0
2009-12-04 14:00:00	NVDA	Stock	0.3525	0.3553	0.351	0.3553	55481640.0
2009-12-04 15:00:00	NVDA	Stock	0.355	0.3572	0.3545	0.3565	139015360.0
2009-12-04 16:00:00	NVDA	Stock	0.3568	0.3578	0.3543	0.3565	11978840.0
2009-12-04 17:00:00	NVDA	Stock	0.3562	0.3562	0.3562	0.3562	4000.0
2009-12-04 19:00:00	NVDA	Stock	0.3555	0.3555	0.3555	0.3555	8000.0
2009-12-04 07:00:00	AMZN	Stock	7.08	7.08	7.0585	7.06	10000.0
2009-12-04 08:00:00	AMZN	Stock	7.065	7.175	7.06	7.152	3177540.0
2009-12-04 09:00:00	AMZN	Stock	7.1535	7.173	7.041	7.045	48763740.0
2009-12-04 10:00:00	AMZN	Stock	7.045	7.1025	7.021	7.0227	42861680.0
2009-12-04 11:00:00	AMZN	Stock	7.0233	7.024	6.7555	6.8465	84533780.0
2009-12-04 12:00:00	AMZN	Stock	6.8465	6.914	6.834	6.887	28859880.0
2009-12-04 13:00:00	AMZN	Stock	6.885	6.8942	6.797	6.833	23880280.0
2009-12-04 14:00:00	AMZN	Stock	6.8365	7.085	6.8295	6.8515	18615180.0
2009-12-04 15:00:00	AMZN	Stock	6.8515	6.8985	6.8405	6.8775	35076380.0
2009-12-04 16:00:00	AMZN	Stock	6.875	7.0761	6.8716	6.901	7935380.0
2009-12-04 17:00:00	AMZN	Stock	6.9015	6.9245	6.9015	6.9245	268180.0
2009-12-04 18:00:00	AMZN	Stock	6.92	6.923	6.912	6.9175	65940.0

> showing 50 of 42,176 rows — these rows as CSV

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