PREVIEW / stock_1hour / 2009-08-17

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-08-17.parquet
  size:    871 KB
  rows:    42,678
  symbols: 3,367

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
2009-08-17 04:00:00	AAPL	Stock	5.8843	5.8843	5.8286	5.8286	36400.0
2009-08-17 06:00:00	AAPL	Stock	5.8318	5.8543	5.8318	5.8318	28000.0
2009-08-17 07:00:00	AAPL	Stock	5.8425	5.8521	5.8214	5.8332	152460.0
2009-08-17 08:00:00	AAPL	Stock	5.8371	5.8621	5.8286	5.8525	1850324.0
2009-08-17 09:00:00	AAPL	Stock	5.8539	5.8561	5.7857	5.8211	76945792.0
2009-08-17 10:00:00	AAPL	Stock	5.8209	5.825	5.7854	5.7904	63332696.0
2009-08-17 11:00:00	AAPL	Stock	5.7904	5.7936	5.7682	5.7854	57859144.0
2009-08-17 12:00:00	AAPL	Stock	5.785	5.7889	5.7618	5.7632	36722140.0
2009-08-17 13:00:00	AAPL	Stock	5.7632	5.7696	5.7443	5.7611	67647608.0
2009-08-17 14:00:00	AAPL	Stock	5.7614	5.7614	5.7275	5.7318	55200432.0
2009-08-17 15:00:00	AAPL	Stock	5.7318	5.7489	5.6936	5.7007	137036032.0
2009-08-17 16:00:00	AAPL	Stock	5.7021	5.7773	5.6975	5.7107	18475128.0
2009-08-17 17:00:00	AAPL	Stock	5.7376	5.7376	5.7054	5.7132	482804.0
2009-08-17 18:00:00	AAPL	Stock	5.7132	5.7132	5.6996	5.7054	1014608.0
2009-08-17 19:00:00	AAPL	Stock	5.7057	5.7139	5.7057	5.7132	78960.0
2009-08-17 04:00:00	MSFT	Stock	23.46	23.46	23.46	23.46	200.0
2009-08-17 05:00:00	MSFT	Stock	23.23	23.23	23.2	23.2	902.0
2009-08-17 06:00:00	MSFT	Stock	23.2	23.2	23.2	23.2	150.0
2009-08-17 07:00:00	MSFT	Stock	23.3	23.3	23.16	23.25	11400.0
2009-08-17 08:00:00	MSFT	Stock	23.26	23.53	23.14	23.27	72929.0
2009-08-17 09:00:00	MSFT	Stock	23.26	23.6	23.25	23.44	6156115.0
2009-08-17 10:00:00	MSFT	Stock	23.44	23.45	23.32	23.342	6324276.0
2009-08-17 11:00:00	MSFT	Stock	23.34	23.38	23.27	23.343	4064109.0
2009-08-17 12:00:00	MSFT	Stock	23.34	23.38	23.33	23.34	2647922.0
2009-08-17 13:00:00	MSFT	Stock	23.34	23.35	23.25	23.28	3753600.0
2009-08-17 14:00:00	MSFT	Stock	23.29	23.32	23.24	23.28	3342058.0
2009-08-17 15:00:00	MSFT	Stock	23.27	23.33	23.23	23.24	10115160.0
2009-08-17 16:00:00	MSFT	Stock	23.23	23.332	23.22	23.25	3830233.0
2009-08-17 17:00:00	MSFT	Stock	23.27	23.31	23.27	23.31	8006.0
2009-08-17 18:00:00	MSFT	Stock	23.3	23.3	23.25	23.29	7100.0
2009-08-17 19:00:00	MSFT	Stock	23.29	23.29	23.29	23.29	2287.0
2009-08-17 06:00:00	NVDA	Stock	0.325	0.325	0.325	0.325	4000.0
2009-08-17 07:00:00	NVDA	Stock	0.325	0.325	0.325	0.325	48000.0
2009-08-17 08:00:00	NVDA	Stock	0.3288	0.3288	0.323	0.3238	586000.0
2009-08-17 09:00:00	NVDA	Stock	0.325	0.327	0.322	0.3225	58223240.0
2009-08-17 10:00:00	NVDA	Stock	0.3225	0.3235	0.3208	0.3213	94106400.0
2009-08-17 11:00:00	NVDA	Stock	0.3215	0.3253	0.318	0.3223	77771200.0
2009-08-17 12:00:00	NVDA	Stock	0.322	0.3223	0.321	0.3215	22378880.0
2009-08-17 13:00:00	NVDA	Stock	0.3213	0.325	0.3198	0.3233	50536960.0
2009-08-17 14:00:00	NVDA	Stock	0.323	0.3231	0.3203	0.321	23430400.0
2009-08-17 15:00:00	NVDA	Stock	0.321	0.323	0.32	0.3215	83139240.0
2009-08-17 16:00:00	NVDA	Stock	0.3215	0.323	0.3213	0.3215	22129880.0
2009-08-17 17:00:00	NVDA	Stock	0.3215	0.3215	0.3215	0.3215	10052000.0
2009-08-17 19:00:00	NVDA	Stock	0.322	0.322	0.322	0.322	7000.0
2009-08-17 04:00:00	AMZN	Stock	4.1335	4.1335	4.1	4.1	20600.0
2009-08-17 08:00:00	AMZN	Stock	4.0985	4.1	4.054	4.064	229720.0
2009-08-17 09:00:00	AMZN	Stock	4.0635	4.0965	4.0125	4.043	20986300.0
2009-08-17 10:00:00	AMZN	Stock	4.0425	4.067	4.029	4.0525	25169920.0
2009-08-17 11:00:00	AMZN	Stock	4.0525	4.0875	4.0425	4.0825	16238340.0
2009-08-17 12:00:00	AMZN	Stock	4.0815	4.089	4.0725	4.0815	9710760.0

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

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