PREVIEW / stock_1hour / 2009-06-19

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-06-19.parquet
  size:    862 KB
  rows:    41,536
  symbols: 3,331

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-06-19 04:00:00	AAPL	Stock	4.8871	4.8871	4.8871	4.8871	2800.0
2009-06-19 07:00:00	AAPL	Stock	4.9207	4.9218	4.8843	4.9132	642180.0
2009-06-19 08:00:00	AAPL	Stock	4.9132	4.9429	4.9132	4.9375	4382868.0
2009-06-19 09:00:00	AAPL	Stock	4.9371	4.9575	4.9025	4.9518	113450960.0
2009-06-19 10:00:00	AAPL	Stock	4.9514	4.9693	4.9429	4.9552	91353248.0
2009-06-19 11:00:00	AAPL	Stock	4.9557	4.9564	4.9261	4.9386	55513976.0
2009-06-19 12:00:00	AAPL	Stock	4.9386	4.9411	4.9039	4.9084	56902216.0
2009-06-19 13:00:00	AAPL	Stock	4.9089	4.9271	4.9046	4.9193	46542748.0
2009-06-19 14:00:00	AAPL	Stock	4.9193	4.9261	4.8893	4.9236	65974412.0
2009-06-19 15:00:00	AAPL	Stock	4.9236	4.9821	4.9218	4.9796	144512816.0
2009-06-19 16:00:00	AAPL	Stock	4.9804	4.9989	4.9379	4.9954	39595500.0
2009-06-19 17:00:00	AAPL	Stock	4.9946	4.9946	4.9814	4.9893	671636.0
2009-06-19 18:00:00	AAPL	Stock	4.9893	4.9939	4.9814	4.9875	1657880.0
2009-06-19 19:00:00	AAPL	Stock	4.9904	4.995	4.9893	4.9939	171528.0
2009-06-19 05:00:00	MSFT	Stock	23.79	23.99	23.79	23.99	900.0
2009-06-19 06:00:00	MSFT	Stock	24.1	24.15	24.02	24.05	28286.0
2009-06-19 07:00:00	MSFT	Stock	24.04	24.05	23.96	23.99	252770.0
2009-06-19 08:00:00	MSFT	Stock	23.99	24.1	23.92	24.05	455410.0
2009-06-19 09:00:00	MSFT	Stock	24.03	24.34	23.75	24.19	37030461.0
2009-06-19 10:00:00	MSFT	Stock	24.19	24.31	24.13	24.298	16703418.0
2009-06-19 11:00:00	MSFT	Stock	24.29	24.32	24.13	24.15	10458704.0
2009-06-19 12:00:00	MSFT	Stock	24.15	24.19	24.0	24.09	8953711.0
2009-06-19 13:00:00	MSFT	Stock	24.1	24.21	23.95	24.15	7079672.0
2009-06-19 14:00:00	MSFT	Stock	24.15	24.19	24.07	24.12	7905501.0
2009-06-19 15:00:00	MSFT	Stock	24.112	24.28	24.06	24.09	16545116.0
2009-06-19 16:00:00	MSFT	Stock	24.08	24.148	24.05	24.06	4706841.0
2009-06-19 17:00:00	MSFT	Stock	24.05	24.12	24.05	24.1	14727.0
2009-06-19 18:00:00	MSFT	Stock	24.1	24.12	24.07	24.1	7942.0
2009-06-19 19:00:00	MSFT	Stock	24.11	24.12	24.1	24.11	9943.0
2009-06-19 09:00:00	NVDA	Stock	0.2792	0.2812	0.2758	0.281	108749640.0
2009-06-19 10:00:00	NVDA	Stock	0.2812	0.2858	0.2792	0.2848	99984960.0
2009-06-19 11:00:00	NVDA	Stock	0.2848	0.2864	0.282	0.2835	139011560.0
2009-06-19 12:00:00	NVDA	Stock	0.2835	0.284	0.2798	0.2804	84174000.0
2009-06-19 13:00:00	NVDA	Stock	0.28	0.2803	0.2778	0.2783	68483280.0
2009-06-19 14:00:00	NVDA	Stock	0.2785	0.2792	0.2763	0.2792	64335880.0
2009-06-19 15:00:00	NVDA	Stock	0.2792	0.2812	0.2783	0.2803	113246040.0
2009-06-19 16:00:00	NVDA	Stock	0.2803	0.2812	0.2778	0.2805	26897840.0
2009-06-19 17:00:00	NVDA	Stock	0.2805	0.2825	0.279	0.279	149000.0
2009-06-19 08:00:00	AMZN	Stock	4.1245	4.125	4.116	4.123	20000.0
2009-06-19 09:00:00	AMZN	Stock	4.116	4.1635	4.075	4.16	34737900.0
2009-06-19 10:00:00	AMZN	Stock	4.159	4.172	4.146	4.165	12054580.0
2009-06-19 11:00:00	AMZN	Stock	4.165	4.173	4.147	4.155	7773900.0
2009-06-19 12:00:00	AMZN	Stock	4.1555	4.1583	4.126	4.13	8517840.0
2009-06-19 13:00:00	AMZN	Stock	4.1292	4.159	4.129	4.1375	6983900.0
2009-06-19 14:00:00	AMZN	Stock	4.136	4.1455	4.1175	4.1375	8693040.0
2009-06-19 15:00:00	AMZN	Stock	4.138	4.154	4.13	4.1475	20377240.0
2009-06-19 16:00:00	AMZN	Stock	4.1475	4.1485	4.137	4.14	6607840.0
2009-06-19 17:00:00	AMZN	Stock	4.1445	4.1445	4.1445	4.1445	2000.0
2009-06-19 18:00:00	AMZN	Stock	4.1445	4.148	4.14	4.148	74700.0
2009-06-19 08:00:00	TLT	Stock	90.25	90.58	90.23	90.46	8700.0

> showing 50 of 41,536 rows — these rows as CSV

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