PREVIEW / stock_30min / 2008-05-22

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-05-22.parquet
  size:    1.3 MB
  rows:    69,463
  symbols: 3,296

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-05-22 04:30:00	AAPL	Stock	6.3571	6.3586	6.3564	6.3586	11200.0
2008-05-22 06:30:00	AAPL	Stock	6.3668	6.37	6.3668	6.37	55300.0
2008-05-22 07:00:00	AAPL	Stock	6.3768	6.3929	6.3707	6.3875	124264.0
2008-05-22 07:30:00	AAPL	Stock	6.3911	6.4125	6.3718	6.3843	619724.0
2008-05-22 08:00:00	AAPL	Stock	6.3886	6.4089	6.3839	6.3929	2799496.0
2008-05-22 08:30:00	AAPL	Stock	6.3929	6.4125	6.3329	6.4071	3597496.0
2008-05-22 09:00:00	AAPL	Stock	6.4064	6.4221	6.3954	6.4036	2724344.0
2008-05-22 09:30:00	AAPL	Stock	6.4032	6.4536	6.3529	6.3757	146339704.0
2008-05-22 10:00:00	AAPL	Stock	6.3768	6.46	6.3757	6.44	91470120.0
2008-05-22 10:30:00	AAPL	Stock	6.44	6.4761	6.4107	6.4414	86264920.0
2008-05-22 11:00:00	AAPL	Stock	6.4418	6.4675	6.4214	6.4418	49117292.0
2008-05-22 11:30:00	AAPL	Stock	6.4411	6.4446	6.3754	6.3989	63900284.0
2008-05-22 12:00:00	AAPL	Stock	6.3989	6.4018	6.3529	6.3854	50007720.0
2008-05-22 12:30:00	AAPL	Stock	6.3857	6.4143	6.3643	6.3882	36931468.0
2008-05-22 13:00:00	AAPL	Stock	6.3882	6.3939	6.3232	6.3536	52611552.0
2008-05-22 13:30:00	AAPL	Stock	6.3536	6.3893	6.3404	6.3571	52511004.0
2008-05-22 14:00:00	AAPL	Stock	6.3575	6.3682	6.1429	6.2146	210777196.0
2008-05-22 14:30:00	AAPL	Stock	6.2152	6.2857	6.1911	6.2746	143553732.0
2008-05-22 15:00:00	AAPL	Stock	6.2757	6.2982	6.2236	6.2296	90513808.0
2008-05-22 15:30:00	AAPL	Stock	6.2291	6.3393	6.2236	6.3232	95586960.0
2008-05-22 16:00:00	AAPL	Stock	6.3232	6.3344	6.2609	6.3232	10694460.0
2008-05-22 16:30:00	AAPL	Stock	6.3225	6.3339	6.3214	6.3339	1206100.0
2008-05-22 17:00:00	AAPL	Stock	6.3321	6.35	6.2765	6.3379	657580.0
2008-05-22 17:30:00	AAPL	Stock	6.3361	6.3429	6.3343	6.3393	71624.0
2008-05-22 18:00:00	AAPL	Stock	6.3393	6.3429	6.3393	6.3393	48468.0
2008-05-22 18:30:00	AAPL	Stock	6.3361	6.3393	6.3354	6.3393	20132.0
2008-05-22 19:00:00	AAPL	Stock	6.3393	6.3404	6.3386	6.3393	47068.0
2008-05-22 19:30:00	AAPL	Stock	6.3361	6.3464	6.3361	6.3375	133028.0
2008-05-22 08:00:00	MSFT	Stock	28.35	28.35	28.31	28.31	900.0
2008-05-22 08:30:00	MSFT	Stock	28.33	28.39	28.33	28.37	8540.0
2008-05-22 09:00:00	MSFT	Stock	28.35	28.38	28.26	28.29	29691.0
2008-05-22 09:30:00	MSFT	Stock	28.28	28.44	28.19	28.36	8609420.0
2008-05-22 10:00:00	MSFT	Stock	28.36	28.52	28.35	28.46	7080733.0
2008-05-22 10:30:00	MSFT	Stock	28.47	28.6	28.32	28.47	4432694.0
2008-05-22 11:00:00	MSFT	Stock	28.47	28.5	28.37	28.465	2644903.0
2008-05-22 11:30:00	MSFT	Stock	28.46	28.5	28.39	28.49	2824708.0
2008-05-22 12:00:00	MSFT	Stock	28.49	28.58	28.43	28.56	2558348.0
2008-05-22 12:30:00	MSFT	Stock	28.559	28.68	28.52	28.67	2130319.0
2008-05-22 13:00:00	MSFT	Stock	28.68	28.7	28.55	28.56	1820315.0
2008-05-22 13:30:00	MSFT	Stock	28.568	28.64	28.53	28.54	2190035.0
2008-05-22 14:00:00	MSFT	Stock	28.54	28.62	28.49	28.54	3050699.0
2008-05-22 14:30:00	MSFT	Stock	28.55	28.58	28.47	28.55	2904723.0
2008-05-22 15:00:00	MSFT	Stock	28.54	28.59	28.34	28.36	3279309.0
2008-05-22 15:30:00	MSFT	Stock	28.37	28.53	28.35	28.45	6194084.0
2008-05-22 16:00:00	MSFT	Stock	28.45	28.47	28.42	28.42	1336608.0
2008-05-22 16:30:00	MSFT	Stock	28.43	28.47	28.43	28.44	224982.0
2008-05-22 17:00:00	MSFT	Stock	28.45	28.506	28.42	28.47	10091.0
2008-05-22 17:30:00	MSFT	Stock	28.42	28.47	28.42	28.45	8750.0
2008-05-22 18:00:00	MSFT	Stock	28.47	28.47	28.47	28.47	500.0
2008-05-22 18:30:00	MSFT	Stock	28.46	28.46	28.46	28.46	3050.0

> showing 50 of 69,463 rows — these rows as CSV

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