PREVIEW / stock_1hour / 2010-02-22

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-02-22.parquet
  size:    886 KB
  rows:    42,568
  symbols: 3,472

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-22 04:00:00	AAPL	Stock	7.21	7.21	7.21	7.21	3752.0
2010-02-22 07:00:00	AAPL	Stock	7.2021	7.225	7.2021	7.2175	92904.0
2010-02-22 08:00:00	AAPL	Stock	7.2214	7.2364	7.2193	7.2214	1363768.0
2010-02-22 09:00:00	AAPL	Stock	7.2211	7.2321	7.1289	7.1511	87912216.0
2010-02-22 10:00:00	AAPL	Stock	7.1511	7.1664	7.1304	7.1443	77540176.0
2010-02-22 11:00:00	AAPL	Stock	7.1439	7.1482	7.1171	7.125	45329872.0
2010-02-22 12:00:00	AAPL	Stock	7.125	7.1464	7.1139	7.1432	28702296.0
2010-02-22 13:00:00	AAPL	Stock	7.1436	7.1693	7.1382	7.1625	38016020.0
2010-02-22 14:00:00	AAPL	Stock	7.1629	7.1825	7.1521	7.1789	35535612.0
2010-02-22 15:00:00	AAPL	Stock	7.1796	7.1964	7.1457	7.1586	66247832.0
2010-02-22 16:00:00	AAPL	Stock	7.1557	7.1821	7.1539	7.1589	4923520.0
2010-02-22 17:00:00	AAPL	Stock	7.1571	7.1579	7.1546	7.1575	116816.0
2010-02-22 18:00:00	AAPL	Stock	7.1589	7.1589	7.1525	7.1525	145936.0
2010-02-22 19:00:00	AAPL	Stock	7.1507	7.1586	7.1507	7.1568	186564.0
2010-02-22 08:00:00	MSFT	Stock	28.85	28.9	28.85	28.85	18722.0
2010-02-22 09:00:00	MSFT	Stock	28.84	28.94	28.76	28.86	3965880.0
2010-02-22 10:00:00	MSFT	Stock	28.86	28.9	28.72	28.77	7033563.0
2010-02-22 11:00:00	MSFT	Stock	28.77	28.82	28.69	28.72	4036642.0
2010-02-22 12:00:00	MSFT	Stock	28.72	28.86	28.7	28.86	3332861.0
2010-02-22 13:00:00	MSFT	Stock	28.86	28.87	28.73	28.74	3584749.0
2010-02-22 14:00:00	MSFT	Stock	28.74	28.81	28.74	28.79	4604250.0
2010-02-22 15:00:00	MSFT	Stock	28.79	28.84	28.65	28.73	6857660.0
2010-02-22 16:00:00	MSFT	Stock	28.73	28.86	28.694	28.7	1452884.0
2010-02-22 17:00:00	MSFT	Stock	28.68	28.68	28.68	28.68	650.0
2010-02-22 18:00:00	MSFT	Stock	28.7	28.7	28.66	28.68	2000.0
2010-02-22 19:00:00	MSFT	Stock	28.66	28.66	28.65	28.65	1300.0
2010-02-22 09:00:00	NVDA	Stock	0.4162	0.4225	0.416	0.421	96996280.0
2010-02-22 10:00:00	NVDA	Stock	0.4213	0.4222	0.4152	0.4168	83681160.0
2010-02-22 11:00:00	NVDA	Stock	0.4168	0.4176	0.4125	0.4133	69446840.0
2010-02-22 12:00:00	NVDA	Stock	0.4133	0.416	0.4128	0.4155	44441840.0
2010-02-22 13:00:00	NVDA	Stock	0.4154	0.4158	0.4138	0.4146	26741240.0
2010-02-22 14:00:00	NVDA	Stock	0.4148	0.418	0.4145	0.4168	46724360.0
2010-02-22 15:00:00	NVDA	Stock	0.417	0.418	0.4145	0.4152	76731080.0
2010-02-22 16:00:00	NVDA	Stock	0.415	0.4218	0.415	0.415	4238280.0
2010-02-22 18:00:00	NVDA	Stock	0.4152	0.4152	0.415	0.415	1909320.0
2010-02-22 07:00:00	AMZN	Stock	5.885	5.885	5.885	5.885	4000.0
2010-02-22 08:00:00	AMZN	Stock	5.885	5.885	5.86	5.866	787340.0
2010-02-22 09:00:00	AMZN	Stock	5.8705	5.875	5.81	5.83	17166580.0
2010-02-22 10:00:00	AMZN	Stock	5.83	5.925	5.809	5.886	33355300.0
2010-02-22 11:00:00	AMZN	Stock	5.886	5.897	5.865	5.87	12349920.0
2010-02-22 12:00:00	AMZN	Stock	5.87	5.907	5.8685	5.8975	9933260.0
2010-02-22 13:00:00	AMZN	Stock	5.897	5.9185	5.8886	5.897	10025920.0
2010-02-22 14:00:00	AMZN	Stock	5.8975	5.9485	5.8965	5.9435	19203620.0
2010-02-22 15:00:00	AMZN	Stock	5.943	5.947	5.8905	5.9005	30444780.0
2010-02-22 16:00:00	AMZN	Stock	5.9055	5.9232	5.8858	5.9095	1482200.0
2010-02-22 17:00:00	AMZN	Stock	5.909	5.909	5.9015	5.9015	26000.0
2010-02-22 18:00:00	AMZN	Stock	5.9005	5.901	5.9005	5.901	24000.0
2010-02-22 19:00:00	AMZN	Stock	5.9025	5.9025	5.9005	5.9005	18000.0
2010-02-22 08:00:00	TLT	Stock	89.26	89.26	89.12	89.21	3700.0
2010-02-22 09:00:00	TLT	Stock	89.13	89.22	89.01	89.12	494166.0

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

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