PREVIEW / stock_1hour / 2008-10-13

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-13.parquet
  size:    860 KB
  rows:    42,737
  symbols: 3,369

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
2008-10-13 05:00:00	AAPL	Stock	3.6786	3.6786	3.6571	3.6786	60480.0
2008-10-13 06:00:00	AAPL	Stock	3.6786	3.6786	3.6786	3.6786	10080.0
2008-10-13 07:00:00	AAPL	Stock	3.6607	3.6786	3.6379	3.6468	1105076.0
2008-10-13 08:00:00	AAPL	Stock	3.6429	3.7311	3.6129	3.7179	8471736.0
2008-10-13 09:00:00	AAPL	Stock	3.7179	3.7857	3.6196	3.6671	277754316.0
2008-10-13 10:00:00	AAPL	Stock	3.6668	3.7321	3.6079	3.6893	213885392.0
2008-10-13 11:00:00	AAPL	Stock	3.6889	3.7393	3.6821	3.7271	135467612.0
2008-10-13 12:00:00	AAPL	Stock	3.7271	3.7857	3.7193	3.7564	156217320.0
2008-10-13 13:00:00	AAPL	Stock	3.7564	3.78	3.725	3.7397	111922160.0
2008-10-13 14:00:00	AAPL	Stock	3.7404	3.81	3.6771	3.8046	204538656.0
2008-10-13 15:00:00	AAPL	Stock	3.8046	3.9475	3.7939	3.9421	371588840.0
2008-10-13 16:00:00	AAPL	Stock	3.9443	3.9643	3.7626	3.95	48115564.0
2008-10-13 17:00:00	AAPL	Stock	3.9496	3.9586	3.9343	3.9586	1038576.0
2008-10-13 18:00:00	AAPL	Stock	3.9593	3.9593	3.9486	3.9536	369852.0
2008-10-13 19:00:00	AAPL	Stock	3.9536	4.0625	3.9536	4.0625	1180480.0
2008-10-13 06:00:00	MSFT	Stock	22.73	22.73	22.73	22.73	200.0
2008-10-13 07:00:00	MSFT	Stock	22.7	22.84	22.6	22.65	11931.0
2008-10-13 08:00:00	MSFT	Stock	22.66	22.9	22.62	22.71	187966.0
2008-10-13 09:00:00	MSFT	Stock	22.73	23.22	22.63	23.12	15278676.0
2008-10-13 10:00:00	MSFT	Stock	23.12	23.63	22.9	23.508	18095105.0
2008-10-13 11:00:00	MSFT	Stock	23.505	23.98	23.46	23.82	16334897.0
2008-10-13 12:00:00	MSFT	Stock	23.82	24.24	23.71	24.07	15470555.0
2008-10-13 13:00:00	MSFT	Stock	24.05	24.11	23.84	23.87	11249354.0
2008-10-13 14:00:00	MSFT	Stock	23.86	24.25	23.79	24.24	17135927.0
2008-10-13 15:00:00	MSFT	Stock	24.242	25.5	24.2	25.49	38632195.0
2008-10-13 16:00:00	MSFT	Stock	25.49	25.5	22.948	25.35	11127695.0
2008-10-13 17:00:00	MSFT	Stock	25.27	25.48	25.23	25.33	52793.0
2008-10-13 18:00:00	MSFT	Stock	25.33	25.38	25.27	25.35	29692.0
2008-10-13 19:00:00	MSFT	Stock	25.3	25.7	25.29	25.7	37204.0
2008-10-13 07:00:00	NVDA	Stock	0.1825	0.1825	0.1813	0.1825	1631440.0
2008-10-13 08:00:00	NVDA	Stock	0.1813	0.185	0.1813	0.185	1956000.0
2008-10-13 09:00:00	NVDA	Stock	0.1845	0.1972	0.1825	0.1873	120772840.0
2008-10-13 10:00:00	NVDA	Stock	0.187	0.1903	0.1828	0.1898	130746280.0
2008-10-13 11:00:00	NVDA	Stock	0.1895	0.191	0.1878	0.1901	69505280.0
2008-10-13 12:00:00	NVDA	Stock	0.1903	0.199	0.1898	0.1958	106673200.0
2008-10-13 13:00:00	NVDA	Stock	0.196	0.2	0.1952	0.1955	69576560.0
2008-10-13 14:00:00	NVDA	Stock	0.1955	0.1965	0.192	0.1935	119491880.0
2008-10-13 15:00:00	NVDA	Stock	0.1938	0.2015	0.1935	0.2015	254685040.0
2008-10-13 16:00:00	NVDA	Stock	0.202	0.2025	0.193	0.2	8679040.0
2008-10-13 17:00:00	NVDA	Stock	0.202	0.2023	0.2002	0.2002	140640.0
2008-10-13 18:00:00	NVDA	Stock	0.202	0.202	0.2	0.2	212000.0
2008-10-13 19:00:00	NVDA	Stock	0.202	0.2038	0.2	0.2018	191720.0
2008-10-13 07:00:00	AMZN	Stock	2.95	2.95	2.925	2.925	40400.0
2008-10-13 08:00:00	AMZN	Stock	2.925	2.975	2.925	2.965	122960.0
2008-10-13 09:00:00	AMZN	Stock	2.954	2.982	2.9175	2.928	32376760.0
2008-10-13 10:00:00	AMZN	Stock	2.928	2.955	2.87	2.8815	35956800.0
2008-10-13 11:00:00	AMZN	Stock	2.881	2.941	2.8685	2.8975	17553600.0
2008-10-13 12:00:00	AMZN	Stock	2.8995	2.9465	2.89	2.929	15880340.0
2008-10-13 13:00:00	AMZN	Stock	2.929	2.969	2.92	2.953	18919940.0
2008-10-13 14:00:00	AMZN	Stock	2.9525	2.994	2.9385	2.991	29756500.0

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

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