PREVIEW / stock_1hour / 2009-05-15

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-05-15.parquet
  size:    828 KB
  rows:    40,601
  symbols: 3,333

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-05-15 08:00:00	AAPL	Stock	4.3746	4.3907	4.3721	4.3786	382424.0
2009-05-15 09:00:00	AAPL	Stock	4.385	4.4293	4.3432	4.4132	78782928.0
2009-05-15 10:00:00	AAPL	Stock	4.4125	4.4507	4.3979	4.4421	66681860.0
2009-05-15 11:00:00	AAPL	Stock	4.4407	4.4475	4.4121	4.4125	38602508.0
2009-05-15 12:00:00	AAPL	Stock	4.4121	4.425	4.3929	4.4005	28585340.0
2009-05-15 13:00:00	AAPL	Stock	4.4007	4.4246	4.3914	4.3982	26071416.0
2009-05-15 14:00:00	AAPL	Stock	4.3975	4.4082	4.3761	4.3779	38474044.0
2009-05-15 15:00:00	AAPL	Stock	4.3782	4.3993	4.3689	4.3693	66136952.0
2009-05-15 16:00:00	AAPL	Stock	4.3721	4.4373	4.3639	4.3693	16308348.0
2009-05-15 17:00:00	AAPL	Stock	4.3643	4.3764	4.3643	4.3646	72576.0
2009-05-15 18:00:00	AAPL	Stock	4.3679	4.3721	4.3643	4.3643	762188.0
2009-05-15 19:00:00	AAPL	Stock	4.3639	4.3679	4.3639	4.3679	139944.0
2009-05-15 08:00:00	MSFT	Stock	20.1	20.1	19.9	20.05	10143.0
2009-05-15 09:00:00	MSFT	Stock	20.05	20.5	19.975	20.448	10146239.0
2009-05-15 10:00:00	MSFT	Stock	20.46	20.5	20.36	20.47	8271005.0
2009-05-15 11:00:00	MSFT	Stock	20.48	20.5	20.31	20.32	7172902.0
2009-05-15 12:00:00	MSFT	Stock	20.32	20.42	20.26	20.34	6595962.0
2009-05-15 13:00:00	MSFT	Stock	20.34	20.4	20.28	20.35	4213641.0
2009-05-15 14:00:00	MSFT	Stock	20.35	20.39	20.26	20.272	5707707.0
2009-05-15 15:00:00	MSFT	Stock	20.27	20.38	20.2	20.2	10633462.0
2009-05-15 16:00:00	MSFT	Stock	20.22	20.466	20.19	20.22	4176953.0
2009-05-15 17:00:00	MSFT	Stock	20.21	20.22	20.18	20.18	4050.0
2009-05-15 18:00:00	MSFT	Stock	20.22	20.23	20.22	20.23	53742.0
2009-05-15 19:00:00	MSFT	Stock	20.23	20.23	20.23	20.23	100.0
2009-05-15 06:00:00	NVDA	Stock	0.2112	0.2112	0.2112	0.2112	4000.0
2009-05-15 07:00:00	NVDA	Stock	0.213	0.213	0.213	0.213	16000.0
2009-05-15 08:00:00	NVDA	Stock	0.214	0.22	0.2108	0.2115	296800.0
2009-05-15 09:00:00	NVDA	Stock	0.2128	0.221	0.212	0.219	133218040.0
2009-05-15 10:00:00	NVDA	Stock	0.219	0.226	0.2183	0.2242	160315040.0
2009-05-15 11:00:00	NVDA	Stock	0.224	0.2245	0.22	0.2203	89080240.0
2009-05-15 12:00:00	NVDA	Stock	0.22	0.2212	0.2188	0.2195	58675920.0
2009-05-15 13:00:00	NVDA	Stock	0.2195	0.2205	0.2175	0.2183	64558440.0
2009-05-15 14:00:00	NVDA	Stock	0.2183	0.2192	0.2175	0.2188	52396280.0
2009-05-15 15:00:00	NVDA	Stock	0.2186	0.2212	0.218	0.219	191702960.0
2009-05-15 16:00:00	NVDA	Stock	0.2195	0.22	0.2183	0.2185	12771480.0
2009-05-15 17:00:00	NVDA	Stock	0.2185	0.2185	0.2185	0.2185	4000.0
2009-05-15 18:00:00	NVDA	Stock	0.22	0.2208	0.22	0.2208	198000.0
2009-05-15 19:00:00	NVDA	Stock	0.2223	0.2223	0.2208	0.2208	84560.0
2009-05-15 07:00:00	AMZN	Stock	3.74	3.74	3.74	3.74	4000.0
2009-05-15 08:00:00	AMZN	Stock	3.753	3.753	3.7425	3.7425	38200.0
2009-05-15 09:00:00	AMZN	Stock	3.7485	3.7675	3.7	3.744	27295920.0
2009-05-15 10:00:00	AMZN	Stock	3.7465	3.8105	3.7395	3.7875	26759700.0
2009-05-15 11:00:00	AMZN	Stock	3.7876	3.7885	3.74	3.74	15925460.0
2009-05-15 12:00:00	AMZN	Stock	3.74	3.769	3.7275	3.7375	15335560.0
2009-05-15 13:00:00	AMZN	Stock	3.7365	3.737	3.695	3.697	18197160.0
2009-05-15 14:00:00	AMZN	Stock	3.697	3.712	3.684	3.6925	17902780.0
2009-05-15 15:00:00	AMZN	Stock	3.6935	3.702	3.671	3.671	33375640.0
2009-05-15 16:00:00	AMZN	Stock	3.68	3.7272	3.667	3.6725	4427620.0
2009-05-15 17:00:00	AMZN	Stock	3.6675	3.67	3.6675	3.67	4000.0
2009-05-15 18:00:00	AMZN	Stock	3.668	3.668	3.6655	3.6655	58000.0

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

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