PREVIEW / stock_1hour / 2008-09-02

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-09-02.parquet
  size:    835 KB
  rows:    40,292
  symbols: 3,324

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-09-02 04:00:00	AAPL	Stock	6.1071	6.1536	6.1071	6.1536	24948.0
2008-09-02 07:00:00	AAPL	Stock	6.1071	6.1536	6.1071	6.1321	926744.0
2008-09-02 08:00:00	AAPL	Stock	6.13	6.1561	6.1204	6.1321	4835880.0
2008-09-02 09:00:00	AAPL	Stock	6.1321	6.1964	6.1321	6.1782	105555072.0
2008-09-02 10:00:00	AAPL	Stock	6.1782	6.185	6.1268	6.1454	91810096.0
2008-09-02 11:00:00	AAPL	Stock	6.145	6.1561	6.1132	6.1361	54137272.0
2008-09-02 12:00:00	AAPL	Stock	6.1361	6.1534	6.1046	6.1204	62569584.0
2008-09-02 13:00:00	AAPL	Stock	6.1204	6.1207	5.92	5.9418	152158160.0
2008-09-02 14:00:00	AAPL	Stock	5.9411	5.9649	5.8929	5.9136	160304452.0
2008-09-02 15:00:00	AAPL	Stock	5.9136	5.9664	5.9071	5.9357	127956948.0
2008-09-02 16:00:00	AAPL	Stock	5.9371	6.1497	5.9329	5.9404	9601200.0
2008-09-02 17:00:00	AAPL	Stock	5.94	6.0546	5.9354	5.9486	3496864.0
2008-09-02 18:00:00	AAPL	Stock	5.945	5.9521	5.9393	5.9521	502768.0
2008-09-02 19:00:00	AAPL	Stock	5.9518	5.9579	5.95	5.9579	180516.0
2008-09-02 05:00:00	MSFT	Stock	27.42	27.42	27.42	27.42	900.0
2008-09-02 06:00:00	MSFT	Stock	27.42	27.42	27.42	27.42	100.0
2008-09-02 07:00:00	MSFT	Stock	27.3	27.5	27.3	27.5	2000.0
2008-09-02 08:00:00	MSFT	Stock	27.49	27.51	27.45	27.45	12946.0
2008-09-02 09:00:00	MSFT	Stock	27.41	27.76	27.4	27.72	7050768.0
2008-09-02 10:00:00	MSFT	Stock	27.73	27.75	27.52	27.622	10386547.0
2008-09-02 11:00:00	MSFT	Stock	27.63	27.7	27.56	27.58	8660635.0
2008-09-02 12:00:00	MSFT	Stock	27.59	27.59	27.47	27.5	7520030.0
2008-09-02 13:00:00	MSFT	Stock	27.5	27.54	27.17	27.29	7673697.0
2008-09-02 14:00:00	MSFT	Stock	27.28	27.33	27.08	27.12	9899281.0
2008-09-02 15:00:00	MSFT	Stock	27.12	27.17	27.06	27.09	9426730.0
2008-09-02 16:00:00	MSFT	Stock	27.11	27.446	27.05	27.1	1747548.0
2008-09-02 17:00:00	MSFT	Stock	27.1	27.649	27.01	27.01	23655.0
2008-09-02 18:00:00	MSFT	Stock	27.01	27.01	27.01	27.01	150.0
2008-09-02 19:00:00	MSFT	Stock	27.05	27.05	27.01	27.01	2935.0
2008-09-02 08:00:00	NVDA	Stock	0.3163	0.3225	0.3163	0.321	1295440.0
2008-09-02 09:00:00	NVDA	Stock	0.321	0.3245	0.3188	0.3188	86168880.0
2008-09-02 10:00:00	NVDA	Stock	0.3189	0.3213	0.3165	0.3176	81050600.0
2008-09-02 11:00:00	NVDA	Stock	0.3176	0.318	0.315	0.3153	62862680.0
2008-09-02 12:00:00	NVDA	Stock	0.315	0.3153	0.3105	0.3125	60533920.0
2008-09-02 13:00:00	NVDA	Stock	0.3125	0.3128	0.3038	0.306	106813240.0
2008-09-02 14:00:00	NVDA	Stock	0.3062	0.3085	0.3038	0.306	130907440.0
2008-09-02 15:00:00	NVDA	Stock	0.306	0.3085	0.3058	0.308	132159120.0
2008-09-02 16:00:00	NVDA	Stock	0.3083	0.3132	0.3068	0.308	25463400.0
2008-09-02 17:00:00	NVDA	Stock	0.3075	0.3075	0.3075	0.3075	100000.0
2008-09-02 18:00:00	NVDA	Stock	0.309	0.309	0.3075	0.3075	54000.0
2008-09-02 08:00:00	AMZN	Stock	4.082	4.1375	4.082	4.13	143340.0
2008-09-02 09:00:00	AMZN	Stock	4.1055	4.2005	4.1	4.1615	19258780.0
2008-09-02 10:00:00	AMZN	Stock	4.161	4.225	4.1555	4.174	20887500.0
2008-09-02 11:00:00	AMZN	Stock	4.1725	4.1825	4.1605	4.177	6912500.0
2008-09-02 12:00:00	AMZN	Stock	4.177	4.185	4.125	4.1555	14574120.0
2008-09-02 13:00:00	AMZN	Stock	4.1545	4.1595	4.0825	4.0975	11188480.0
2008-09-02 14:00:00	AMZN	Stock	4.0955	4.113	4.0605	4.083	17571220.0
2008-09-02 15:00:00	AMZN	Stock	4.0835	4.089	4.064	4.073	23013560.0
2008-09-02 16:00:00	AMZN	Stock	4.0755	4.158	4.0705	4.0705	5081340.0
2008-09-02 17:00:00	AMZN	Stock	4.068	4.158	4.0675	4.0675	251220.0

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

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