PREVIEW / stock_1hour / 2009-04-21

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-04-21.parquet
  size:    828 KB
  rows:    40,638
  symbols: 3,307

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-04-21 07:00:00	AAPL	Stock	4.3036	4.3036	4.3036	4.3036	2800.0
2009-04-21 08:00:00	AAPL	Stock	4.3025	4.3061	4.2589	4.2607	844312.0
2009-04-21 09:00:00	AAPL	Stock	4.2618	4.3436	4.2357	4.335	74106816.0
2009-04-21 10:00:00	AAPL	Stock	4.335	4.3364	4.2832	4.3311	64008000.0
2009-04-21 11:00:00	AAPL	Stock	4.3311	4.3621	4.3214	4.347	63173852.0
2009-04-21 12:00:00	AAPL	Stock	4.3471	4.3596	4.3396	4.3486	41711740.0
2009-04-21 13:00:00	AAPL	Stock	4.3486	4.3565	4.3336	4.3489	43315272.0
2009-04-21 14:00:00	AAPL	Stock	4.3493	4.3536	4.3161	4.3193	70362628.0
2009-04-21 15:00:00	AAPL	Stock	4.3211	4.3611	4.3175	4.3489	95394432.0
2009-04-21 16:00:00	AAPL	Stock	4.3482	4.3586	4.3314	4.3518	7230412.0
2009-04-21 17:00:00	AAPL	Stock	4.3536	4.3536	4.3289	4.3382	676396.0
2009-04-21 18:00:00	AAPL	Stock	4.3339	4.3554	4.3321	4.35	971320.0
2009-04-21 19:00:00	AAPL	Stock	4.35	4.3554	4.3496	4.3504	249508.0
2009-04-21 20:00:00	AAPL	Stock	4.3036	4.3036	4.3036	4.3036	14000.0
2009-04-21 08:00:00	MSFT	Stock	18.63	18.7	18.6	18.64	40487.0
2009-04-21 09:00:00	MSFT	Stock	18.64	19.08	18.57	18.94	9420415.0
2009-04-21 10:00:00	MSFT	Stock	18.93	18.94	18.73	18.85	10874725.0
2009-04-21 11:00:00	MSFT	Stock	18.86	18.98	18.81	18.98	8173979.0
2009-04-21 12:00:00	MSFT	Stock	18.98	18.98	18.72	18.8	6836206.0
2009-04-21 13:00:00	MSFT	Stock	18.79	18.82	18.7	18.78	5018172.0
2009-04-21 14:00:00	MSFT	Stock	18.77	18.88	18.73	18.8	5489243.0
2009-04-21 15:00:00	MSFT	Stock	18.81	18.98	18.8	18.97	11491061.0
2009-04-21 16:00:00	MSFT	Stock	18.96	18.972	18.81	18.87	1965546.0
2009-04-21 17:00:00	MSFT	Stock	18.87	18.94	18.87	18.91	3561.0
2009-04-21 18:00:00	MSFT	Stock	18.97	18.97	18.9	18.93	38842.0
2009-04-21 19:00:00	MSFT	Stock	18.9	18.93	18.89	18.89	2500.0
2009-04-21 20:00:00	MSFT	Stock	18.61	18.61	18.61	18.61	46900.0
2009-04-21 08:00:00	NVDA	Stock	0.2788	0.2788	0.27	0.27	482480.0
2009-04-21 09:00:00	NVDA	Stock	0.27	0.287	0.2672	0.2858	76903520.0
2009-04-21 10:00:00	NVDA	Stock	0.2858	0.2861	0.2744	0.2763	180414200.0
2009-04-21 11:00:00	NVDA	Stock	0.2763	0.2803	0.2761	0.2792	89651440.0
2009-04-21 12:00:00	NVDA	Stock	0.279	0.2812	0.277	0.2772	84057760.0
2009-04-21 13:00:00	NVDA	Stock	0.2772	0.2775	0.272	0.2728	151701360.0
2009-04-21 14:00:00	NVDA	Stock	0.2728	0.2735	0.2685	0.27	133191920.0
2009-04-21 15:00:00	NVDA	Stock	0.2698	0.28	0.2698	0.2752	184926920.0
2009-04-21 16:00:00	NVDA	Stock	0.2755	0.276	0.274	0.2755	15096840.0
2009-04-21 19:00:00	NVDA	Stock	0.2755	0.2755	0.2755	0.2755	10000.0
2009-04-21 05:00:00	AMZN	Stock	3.8815	3.9	3.8815	3.9	15000.0
2009-04-21 07:00:00	AMZN	Stock	3.8605	3.8605	3.8605	3.8605	3500.0
2009-04-21 08:00:00	AMZN	Stock	3.875	3.885	3.865	3.865	72000.0
2009-04-21 09:00:00	AMZN	Stock	3.87	3.949	3.85	3.9345	19621920.0
2009-04-21 10:00:00	AMZN	Stock	3.9355	3.942	3.88	3.8975	32993960.0
2009-04-21 11:00:00	AMZN	Stock	3.8975	3.9425	3.8955	3.9152	13810260.0
2009-04-21 12:00:00	AMZN	Stock	3.9165	3.935	3.915	3.921	10517080.0
2009-04-21 13:00:00	AMZN	Stock	3.921	3.9425	3.91	3.9245	15547900.0
2009-04-21 14:00:00	AMZN	Stock	3.9245	3.934	3.9065	3.924	16179740.0
2009-04-21 15:00:00	AMZN	Stock	3.9235	3.955	3.92	3.938	30447640.0
2009-04-21 16:00:00	AMZN	Stock	3.9365	3.9615	3.9215	3.945	1153740.0
2009-04-21 17:00:00	AMZN	Stock	3.945	3.949	3.94	3.94	20000.0
2009-04-21 18:00:00	AMZN	Stock	3.9475	3.9475	3.94	3.94	6000.0

> showing 50 of 40,638 rows — these rows as CSV

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