PREVIEW / stock_1hour / 2009-04-20

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-04-20.parquet
  size:    831 KB
  rows:    40,632
  symbols: 3,310

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-20 04:00:00	AAPL	Stock	4.3882	4.3882	4.3882	4.3882	2800.0
2009-04-20 05:00:00	AAPL	Stock	4.3214	4.3214	4.3214	4.3214	2800.0
2009-04-20 06:00:00	AAPL	Stock	4.3564	4.3564	4.3464	4.3464	11200.0
2009-04-20 07:00:00	AAPL	Stock	4.3464	4.3821	4.3357	4.3821	221060.0
2009-04-20 08:00:00	AAPL	Stock	4.3832	4.3946	4.3571	4.3732	1352932.0
2009-04-20 09:00:00	AAPL	Stock	4.3696	4.3925	4.3411	4.3518	71001700.0
2009-04-20 10:00:00	AAPL	Stock	4.3521	4.3707	4.2893	4.3004	79312828.0
2009-04-20 11:00:00	AAPL	Stock	4.3007	4.3139	4.2893	4.2972	44546908.0
2009-04-20 12:00:00	AAPL	Stock	4.2986	4.3107	4.2886	4.3082	34481664.0
2009-04-20 13:00:00	AAPL	Stock	4.3079	4.3082	4.2789	4.3	50178688.0
2009-04-20 14:00:00	AAPL	Stock	4.2986	4.3	4.2571	4.2645	51269652.0
2009-04-20 15:00:00	AAPL	Stock	4.265	4.3339	4.2557	4.3029	107061556.0
2009-04-20 16:00:00	AAPL	Stock	4.3029	4.3257	4.2729	4.3014	19996060.0
2009-04-20 17:00:00	AAPL	Stock	4.3	4.3125	4.3	4.3125	196420.0
2009-04-20 18:00:00	AAPL	Stock	4.3093	4.3143	4.3071	4.3071	126700.0
2009-04-20 19:00:00	AAPL	Stock	4.3043	4.3046	4.3011	4.3011	128128.0
2009-04-20 07:00:00	MSFT	Stock	19.2	19.2	19.0	19.0	2290.0
2009-04-20 08:00:00	MSFT	Stock	19.12	19.12	18.85	18.88	109857.0
2009-04-20 09:00:00	MSFT	Stock	18.88	18.95	18.7	18.727	6025042.0
2009-04-20 10:00:00	MSFT	Stock	18.72	18.87	18.61	18.7	11719220.0
2009-04-20 11:00:00	MSFT	Stock	18.7	18.83	18.65	18.68	6300176.0
2009-04-20 12:00:00	MSFT	Stock	18.69	18.85	18.62	18.844	4929572.0
2009-04-20 13:00:00	MSFT	Stock	18.84	18.89	18.75	18.85	4645248.0
2009-04-20 14:00:00	MSFT	Stock	18.85	18.87	18.68	18.68	4814570.0
2009-04-20 15:00:00	MSFT	Stock	18.69	18.8	18.57	18.61	16360013.0
2009-04-20 16:00:00	MSFT	Stock	18.58	18.737	18.56	18.63	6618311.0
2009-04-20 17:00:00	MSFT	Stock	18.63	18.68	18.61	18.68	5375.0
2009-04-20 18:00:00	MSFT	Stock	18.69	18.7	18.69	18.69	3767.0
2009-04-20 19:00:00	MSFT	Stock	18.7	18.7	18.67	18.67	2510.0
2009-04-20 08:00:00	NVDA	Stock	0.2875	0.2875	0.28	0.28	3338400.0
2009-04-20 09:00:00	NVDA	Stock	0.2835	0.2852	0.2783	0.2788	91052440.0
2009-04-20 10:00:00	NVDA	Stock	0.2788	0.279	0.2748	0.2765	112714640.0
2009-04-20 11:00:00	NVDA	Stock	0.2768	0.2778	0.275	0.276	48133200.0
2009-04-20 12:00:00	NVDA	Stock	0.2763	0.2792	0.275	0.279	49649080.0
2009-04-20 13:00:00	NVDA	Stock	0.279	0.2798	0.2769	0.2785	57423560.0
2009-04-20 14:00:00	NVDA	Stock	0.2785	0.2795	0.2763	0.2772	45528480.0
2009-04-20 15:00:00	NVDA	Stock	0.2772	0.2783	0.275	0.2765	157522000.0
2009-04-20 16:00:00	NVDA	Stock	0.2765	0.2788	0.2759	0.2763	3549440.0
2009-04-20 17:00:00	NVDA	Stock	0.2755	0.2788	0.2755	0.2788	47760.0
2009-04-20 18:00:00	NVDA	Stock	0.2808	0.2808	0.2808	0.2808	8000.0
2009-04-20 04:00:00	AMZN	Stock	3.9445	3.9495	3.9415	3.9415	22000.0
2009-04-20 05:00:00	AMZN	Stock	3.9395	3.9395	3.9395	3.9395	20000.0
2009-04-20 06:00:00	AMZN	Stock	3.939	3.939	3.91	3.91	76700.0
2009-04-20 07:00:00	AMZN	Stock	3.9165	3.93	3.871	3.9075	314000.0
2009-04-20 08:00:00	AMZN	Stock	3.8925	3.93	3.8795	3.9095	871040.0
2009-04-20 09:00:00	AMZN	Stock	3.9025	3.9895	3.899	3.9669	38092660.0
2009-04-20 10:00:00	AMZN	Stock	3.9655	3.9835	3.8875	3.903	38181040.0
2009-04-20 11:00:00	AMZN	Stock	3.903	3.9325	3.895	3.9025	17381520.0
2009-04-20 12:00:00	AMZN	Stock	3.904	3.9135	3.8785	3.9095	11448960.0
2009-04-20 13:00:00	AMZN	Stock	3.91	3.91	3.887	3.9085	9680960.0

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

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