PREVIEW / stock_1hour / 2010-02-12

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-02-12.parquet
  size:    900 KB
  rows:    42,637
  symbols: 3,433

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
2010-02-12 04:00:00	AAPL	Stock	7.0964	7.0964	7.0964	7.0964	2800.0
2010-02-12 05:00:00	AAPL	Stock	7.0604	7.0604	7.0511	7.0511	10892.0
2010-02-12 06:00:00	AAPL	Stock	7.0439	7.0439	7.0236	7.0236	19600.0
2010-02-12 07:00:00	AAPL	Stock	7.0511	7.0779	7.0511	7.0682	423136.0
2010-02-12 08:00:00	AAPL	Stock	7.0714	7.0811	7.0496	7.0729	2549820.0
2010-02-12 09:00:00	AAPL	Stock	7.075	7.0868	7.0279	7.0521	75812268.0
2010-02-12 10:00:00	AAPL	Stock	7.0529	7.0786	7.0268	7.0543	83936748.0
2010-02-12 11:00:00	AAPL	Stock	7.0536	7.1314	7.0496	7.1254	70790188.0
2010-02-12 12:00:00	AAPL	Stock	7.1254	7.2014	7.125	7.175	112564172.0
2010-02-12 13:00:00	AAPL	Stock	7.1739	7.175	7.1121	7.1456	77723856.0
2010-02-12 14:00:00	AAPL	Stock	7.1443	7.1857	7.1411	7.1686	71298108.0
2010-02-12 15:00:00	AAPL	Stock	7.1696	7.1743	6.9821	7.1643	107920652.0
2010-02-12 16:00:00	AAPL	Stock	7.1575	7.1661	7.1018	7.1632	28670180.0
2010-02-12 17:00:00	AAPL	Stock	7.1614	7.1657	7.1614	7.1646	160132.0
2010-02-12 18:00:00	AAPL	Stock	7.1646	7.1664	7.1564	7.1664	137676.0
2010-02-12 19:00:00	AAPL	Stock	7.165	7.1679	7.1625	7.1625	275072.0
2010-02-12 05:00:00	MSFT	Stock	27.85	27.85	27.85	27.85	100.0
2010-02-12 06:00:00	MSFT	Stock	27.84	27.84	27.75	27.8	1000.0
2010-02-12 07:00:00	MSFT	Stock	27.91	27.96	27.9	27.9	1602.0
2010-02-12 08:00:00	MSFT	Stock	27.94	28.12	27.9	28.04	37015.0
2010-02-12 09:00:00	MSFT	Stock	28.02	28.04	27.6	27.7	8194541.0
2010-02-12 10:00:00	MSFT	Stock	27.7	27.73	27.58	27.678	10527789.0
2010-02-12 11:00:00	MSFT	Stock	27.67	27.75	27.63	27.7	8236679.0
2010-02-12 12:00:00	MSFT	Stock	27.7	28.06	27.7	27.98	10463574.0
2010-02-12 13:00:00	MSFT	Stock	27.97	27.98	27.65	27.778	8907591.0
2010-02-12 14:00:00	MSFT	Stock	27.78	28.04	27.75	27.912	6878166.0
2010-02-12 15:00:00	MSFT	Stock	27.91	27.99	27.8	27.94	13461195.0
2010-02-12 16:00:00	MSFT	Stock	27.94	28.021	27.656	27.932	6535246.0
2010-02-12 17:00:00	MSFT	Stock	27.97	27.98	27.97	27.97	1900.0
2010-02-12 18:00:00	MSFT	Stock	27.93	27.97	27.93	27.97	2172.0
2010-02-12 19:00:00	MSFT	Stock	27.95	27.97	27.95	27.97	2222.0
2010-02-12 08:00:00	NVDA	Stock	0.4238	0.4275	0.4238	0.4245	283680.0
2010-02-12 09:00:00	NVDA	Stock	0.4242	0.4288	0.4201	0.4253	66073000.0
2010-02-12 10:00:00	NVDA	Stock	0.4253	0.4355	0.4222	0.4332	182957280.0
2010-02-12 11:00:00	NVDA	Stock	0.4332	0.4395	0.432	0.4388	118674400.0
2010-02-12 12:00:00	NVDA	Stock	0.4386	0.4425	0.438	0.4402	77002120.0
2010-02-12 13:00:00	NVDA	Stock	0.4402	0.4402	0.4354	0.4368	71142920.0
2010-02-12 14:00:00	NVDA	Stock	0.4366	0.4395	0.4352	0.4359	53921560.0
2010-02-12 15:00:00	NVDA	Stock	0.4358	0.4362	0.4328	0.434	156046960.0
2010-02-12 16:00:00	NVDA	Stock	0.434	0.44	0.4334	0.4338	28289320.0
2010-02-12 17:00:00	NVDA	Stock	0.434	0.434	0.434	0.434	32000.0
2010-02-12 18:00:00	NVDA	Stock	0.4338	0.4342	0.4338	0.4342	1424200.0
2010-02-12 19:00:00	NVDA	Stock	0.4355	0.4355	0.4355	0.4355	6000.0
2010-02-12 04:00:00	AMZN	Stock	5.9945	5.9945	5.9945	5.9945	2000.0
2010-02-12 06:00:00	AMZN	Stock	5.9375	5.9375	5.9375	5.9375	2000.0
2010-02-12 08:00:00	AMZN	Stock	5.966	5.9925	5.9575	5.97	481500.0
2010-02-12 09:00:00	AMZN	Stock	5.97	5.973	5.9028	5.925	23077640.0
2010-02-12 10:00:00	AMZN	Stock	5.9255	5.9365	5.875	5.9005	30898020.0
2010-02-12 11:00:00	AMZN	Stock	5.8975	5.944	5.895	5.931	15114440.0
2010-02-12 12:00:00	AMZN	Stock	5.9305	5.9945	5.9305	5.966	18859220.0

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

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