PREVIEW / stock_1hour / 2008-11-21

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-11-21.parquet
  size:    857 KB
  rows:    44,178
  symbols: 3,379

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-11-21 04:00:00	AAPL	Stock	3.0	3.0	3.0	3.0	5600.0
2008-11-21 05:00:00	AAPL	Stock	3.0	3.0	3.0	3.0	2800.0
2008-11-21 06:00:00	AAPL	Stock	3.0	3.0	2.9629	2.9821	11200.0
2008-11-21 07:00:00	AAPL	Stock	2.9643	2.9768	2.8968	2.9107	1000944.0
2008-11-21 08:00:00	AAPL	Stock	2.9196	2.9621	2.875	2.9529	6722156.0
2008-11-21 09:00:00	AAPL	Stock	2.9532	3.0043	2.9018	2.9736	198108708.0
2008-11-21 10:00:00	AAPL	Stock	2.9736	2.9914	2.9075	2.9121	229234516.0
2008-11-21 11:00:00	AAPL	Stock	2.9125	2.9557	2.8918	2.9154	162655780.0
2008-11-21 12:00:00	AAPL	Stock	2.9157	2.9518	2.9025	2.92	135493652.0
2008-11-21 13:00:00	AAPL	Stock	2.9204	2.9239	2.8493	2.8507	165996824.0
2008-11-21 14:00:00	AAPL	Stock	2.8504	2.9014	2.8264	2.845	212374764.0
2008-11-21 15:00:00	AAPL	Stock	2.8454	2.9643	2.8432	2.9493	382198236.0
2008-11-21 16:00:00	AAPL	Stock	2.9521	2.9546	2.9029	2.9436	42775768.0
2008-11-21 17:00:00	AAPL	Stock	2.9429	2.9468	2.8625	2.9108	1173368.0
2008-11-21 18:00:00	AAPL	Stock	2.9396	2.9464	2.908	2.9396	243264.0
2008-11-21 19:00:00	AAPL	Stock	2.9411	2.9457	2.9375	2.9379	121492.0
2008-11-21 04:00:00	MSFT	Stock	17.96	19.2	17.96	19.2	3200.0
2008-11-21 07:00:00	MSFT	Stock	18.13	18.13	18.0	18.0	7600.0
2008-11-21 08:00:00	MSFT	Stock	18.0	18.1	17.9	18.0	88907.0
2008-11-21 09:00:00	MSFT	Stock	18.0	18.64	17.98	18.59	15733855.0
2008-11-21 10:00:00	MSFT	Stock	18.59	18.62	18.07	18.26	20802252.0
2008-11-21 11:00:00	MSFT	Stock	18.25	18.75	17.98	18.64	17307581.0
2008-11-21 12:00:00	MSFT	Stock	18.63	19.0	18.56	18.885	12879872.0
2008-11-21 13:00:00	MSFT	Stock	18.886	18.9	18.57	18.64	12634165.0
2008-11-21 14:00:00	MSFT	Stock	18.63	18.88	18.45	18.67	18239800.0
2008-11-21 15:00:00	MSFT	Stock	18.67	19.7	18.65	19.69	40083586.0
2008-11-21 16:00:00	MSFT	Stock	19.69	19.81	18.279	19.64	12557151.0
2008-11-21 17:00:00	MSFT	Stock	19.64	19.68	18.45	19.045	272342.0
2008-11-21 18:00:00	MSFT	Stock	19.09	19.63	19.04	19.55	26700.0
2008-11-21 19:00:00	MSFT	Stock	19.63	19.63	19.55	19.56	4459.0
2008-11-21 08:00:00	NVDA	Stock	0.152	0.1558	0.1515	0.1542	271000.0
2008-11-21 09:00:00	NVDA	Stock	0.1538	0.1542	0.146	0.1472	83842120.0
2008-11-21 10:00:00	NVDA	Stock	0.147	0.1528	0.1465	0.1502	98189520.0
2008-11-21 11:00:00	NVDA	Stock	0.1501	0.152	0.148	0.1485	54572480.0
2008-11-21 12:00:00	NVDA	Stock	0.1485	0.1525	0.148	0.1492	44020120.0
2008-11-21 13:00:00	NVDA	Stock	0.1492	0.1495	0.1445	0.1445	43472760.0
2008-11-21 14:00:00	NVDA	Stock	0.1445	0.1489	0.1438	0.1445	60579920.0
2008-11-21 15:00:00	NVDA	Stock	0.1445	0.1595	0.1444	0.1595	182620320.0
2008-11-21 16:00:00	NVDA	Stock	0.1588	0.16	0.1507	0.1595	6892680.0
2008-11-21 17:00:00	NVDA	Stock	0.1588	0.1638	0.145	0.1512	1992600.0
2008-11-21 18:00:00	NVDA	Stock	0.152	0.1632	0.152	0.1612	554800.0
2008-11-21 19:00:00	NVDA	Stock	0.1612	0.1628	0.1612	0.1628	88000.0
2008-11-21 07:00:00	AMZN	Stock	1.813	1.813	1.813	1.813	24000.0
2008-11-21 08:00:00	AMZN	Stock	1.813	1.813	1.7515	1.8105	306440.0
2008-11-21 09:00:00	AMZN	Stock	1.82	1.95	1.815	1.8825	60785320.0
2008-11-21 10:00:00	AMZN	Stock	1.882	1.915	1.813	1.817	45662600.0
2008-11-21 11:00:00	AMZN	Stock	1.8175	1.8845	1.8	1.8555	33247340.0
2008-11-21 12:00:00	AMZN	Stock	1.8578	1.898	1.8455	1.8505	20814400.0
2008-11-21 13:00:00	AMZN	Stock	1.8545	1.866	1.804	1.8075	21475000.0
2008-11-21 14:00:00	AMZN	Stock	1.8085	1.8395	1.786	1.803	30539520.0

> showing 50 of 44,178 rows — these rows as CSV

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