PREVIEW / stock_1hour / 2009-06-01

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-06-01.parquet
  size:    878 KB
  rows:    42,737
  symbols: 3,347

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-01 04:00:00	AAPL	Stock	4.8457	4.8643	4.8457	4.8643	7000.0
2009-06-01 06:00:00	AAPL	Stock	4.9018	4.9018	4.9018	4.9018	2800.0
2009-06-01 07:00:00	AAPL	Stock	4.9107	4.9146	4.8946	4.9036	133980.0
2009-06-01 08:00:00	AAPL	Stock	4.8357	4.9125	4.8357	4.9089	1349852.0
2009-06-01 09:00:00	AAPL	Stock	4.9086	4.94	4.8504	4.9243	86795576.0
2009-06-01 10:00:00	AAPL	Stock	4.9243	4.9607	4.9243	4.9568	73432128.0
2009-06-01 11:00:00	AAPL	Stock	4.9568	4.9732	4.9357	4.9711	48371680.0
2009-06-01 12:00:00	AAPL	Stock	4.97	4.9954	4.9657	4.9764	43313732.0
2009-06-01 13:00:00	AAPL	Stock	4.9764	4.9996	4.9696	4.9954	38306660.0
2009-06-01 14:00:00	AAPL	Stock	4.9954	4.9996	4.9846	4.9904	45229100.0
2009-06-01 15:00:00	AAPL	Stock	4.99	4.9918	4.9554	4.9764	100401420.0
2009-06-01 16:00:00	AAPL	Stock	4.9764	4.9857	4.8615	4.975	10351152.0
2009-06-01 17:00:00	AAPL	Stock	4.9725	4.9754	4.8504	4.9729	221424.0
2009-06-01 18:00:00	AAPL	Stock	4.975	4.9775	4.9718	4.9775	1816444.0
2009-06-01 19:00:00	AAPL	Stock	4.9768	4.9804	4.9757	4.9782	123480.0
2009-06-01 04:00:00	MSFT	Stock	20.91	20.91	20.91	20.91	12000.0
2009-06-01 05:00:00	MSFT	Stock	21.1	21.1	21.1	21.1	2100.0
2009-06-01 06:00:00	MSFT	Stock	21.18	21.24	21.18	21.18	4600.0
2009-06-01 07:00:00	MSFT	Stock	21.1	21.16	21.08	21.08	6270.0
2009-06-01 08:00:00	MSFT	Stock	21.0	21.15	20.95	21.15	95670.0
2009-06-01 09:00:00	MSFT	Stock	21.15	21.22	20.86	21.1	6631608.0
2009-06-01 10:00:00	MSFT	Stock	21.11	21.28	21.11	21.2	7590845.0
2009-06-01 11:00:00	MSFT	Stock	21.2	21.3	21.19	21.263	3777924.0
2009-06-01 12:00:00	MSFT	Stock	21.26	21.37	21.2	21.22	6343452.0
2009-06-01 13:00:00	MSFT	Stock	21.21	21.385	21.12	21.365	6044881.0
2009-06-01 14:00:00	MSFT	Stock	21.37	21.44	21.2	21.39	6209652.0
2009-06-01 15:00:00	MSFT	Stock	21.392	21.5	21.34	21.39	14252300.0
2009-06-01 16:00:00	MSFT	Stock	21.4	21.47	20.938	21.35	5250710.0
2009-06-01 17:00:00	MSFT	Stock	21.34	21.35	20.89	21.35	16239.0
2009-06-01 18:00:00	MSFT	Stock	21.4	21.4	21.33	21.33	16493.0
2009-06-01 19:00:00	MSFT	Stock	21.36	21.38	21.36	21.36	4286.0
2009-06-01 20:00:00	MSFT	Stock	21.19	21.19	21.19	21.19	111.0
2009-06-01 04:00:00	NVDA	Stock	0.2612	0.2612	0.2612	0.2612	32000.0
2009-06-01 06:00:00	NVDA	Stock	0.2612	0.2612	0.2612	0.2612	4000.0
2009-06-01 08:00:00	NVDA	Stock	0.2625	0.2645	0.26	0.2643	362400.0
2009-06-01 09:00:00	NVDA	Stock	0.2643	0.27	0.2628	0.269	129552840.0
2009-06-01 10:00:00	NVDA	Stock	0.269	0.273	0.2685	0.271	231403240.0
2009-06-01 11:00:00	NVDA	Stock	0.2712	0.2723	0.269	0.2712	111779680.0
2009-06-01 12:00:00	NVDA	Stock	0.2715	0.273	0.2703	0.2715	113671840.0
2009-06-01 13:00:00	NVDA	Stock	0.2715	0.2745	0.2708	0.2743	112087120.0
2009-06-01 14:00:00	NVDA	Stock	0.2743	0.275	0.2732	0.2738	100755240.0
2009-06-01 15:00:00	NVDA	Stock	0.2738	0.2748	0.2708	0.2738	196736800.0
2009-06-01 16:00:00	NVDA	Stock	0.2732	0.2735	0.2695	0.2735	11060080.0
2009-06-01 17:00:00	NVDA	Stock	0.2608	0.2712	0.2608	0.27	2961640.0
2009-06-01 18:00:00	NVDA	Stock	0.2705	0.2705	0.2705	0.2705	8000.0
2009-06-01 07:00:00	AMZN	Stock	3.91	3.91	3.91	3.91	4000.0
2009-06-01 08:00:00	AMZN	Stock	3.925	3.945	3.9075	3.9375	71820.0
2009-06-01 09:00:00	AMZN	Stock	3.944	4.05	3.8745	4.0308	38390640.0
2009-06-01 10:00:00	AMZN	Stock	4.0315	4.0745	4.03	4.0627	30033920.0
2009-06-01 11:00:00	AMZN	Stock	4.0625	4.105	4.0585	4.0985	17492220.0

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

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