PREVIEW / stock_30min / 2008-01-14

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-01-14.parquet
  size:    1.2 MB
  rows:    69,155
  symbols: 3,266

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-01-14 04:30:00	AAPL	Stock	6.2143	6.2143	6.2086	6.2096	19600.0
2008-01-14 05:00:00	AAPL	Stock	6.2096	6.2143	6.1971	6.1971	23240.0
2008-01-14 05:30:00	AAPL	Stock	6.2143	6.2321	6.2143	6.2282	121352.0
2008-01-14 06:00:00	AAPL	Stock	6.2271	6.2411	6.2229	6.2229	50400.0
2008-01-14 06:30:00	AAPL	Stock	6.2143	6.2232	6.2143	6.2232	45640.0
2008-01-14 07:00:00	AAPL	Stock	6.2232	6.2232	6.2143	6.2143	355712.0
2008-01-14 07:30:00	AAPL	Stock	6.225	6.3	6.225	6.2804	1340724.0
2008-01-14 08:00:00	AAPL	Stock	6.2857	6.3107	6.2646	6.2875	8577688.0
2008-01-14 08:30:00	AAPL	Stock	6.2911	6.345	6.2843	6.3225	11070136.0
2008-01-14 09:00:00	AAPL	Stock	6.3225	6.3554	6.3196	6.3393	11919460.0
2008-01-14 09:30:00	AAPL	Stock	6.3393	6.3446	6.2561	6.3046	180505612.0
2008-01-14 10:00:00	AAPL	Stock	6.3054	6.3246	6.2786	6.3157	94299184.0
2008-01-14 10:30:00	AAPL	Stock	6.3157	6.3575	6.3143	6.3429	96564132.0
2008-01-14 11:00:00	AAPL	Stock	6.3429	6.3657	6.3325	6.3532	75592888.0
2008-01-14 11:30:00	AAPL	Stock	6.3521	6.3557	6.3221	6.3311	51768948.0
2008-01-14 12:00:00	AAPL	Stock	6.3311	6.3311	6.2946	6.3146	62826820.0
2008-01-14 12:30:00	AAPL	Stock	6.3153	6.3304	6.3007	6.3175	36857632.0
2008-01-14 13:00:00	AAPL	Stock	6.3175	6.3336	6.3071	6.31	37514064.0
2008-01-14 13:30:00	AAPL	Stock	6.3086	6.3411	6.3085	6.3282	41056540.0
2008-01-14 14:00:00	AAPL	Stock	6.3278	6.3421	6.3125	6.3395	39918088.0
2008-01-14 14:30:00	AAPL	Stock	6.3389	6.3743	6.3243	6.3639	82400808.0
2008-01-14 15:00:00	AAPL	Stock	6.3636	6.4029	6.355	6.3786	108042872.0
2008-01-14 15:30:00	AAPL	Stock	6.38	6.4079	6.3664	6.3835	115703000.0
2008-01-14 16:00:00	AAPL	Stock	6.3807	6.3854	6.321	6.3732	38001992.0
2008-01-14 16:30:00	AAPL	Stock	6.3761	6.3875	6.337	6.3857	2340156.0
2008-01-14 17:00:00	AAPL	Stock	6.3871	6.3964	6.3857	6.3857	1193696.0
2008-01-14 17:30:00	AAPL	Stock	6.3832	6.3996	6.3832	6.3968	713748.0
2008-01-14 18:00:00	AAPL	Stock	6.3982	6.4014	6.3929	6.4	504420.0
2008-01-14 18:30:00	AAPL	Stock	6.4007	6.4046	6.3929	6.3929	275940.0
2008-01-14 19:00:00	AAPL	Stock	6.3996	6.4	6.3929	6.4	187600.0
2008-01-14 19:30:00	AAPL	Stock	6.3964	6.3986	6.3857	6.3875	670376.0
2008-01-14 07:00:00	MSFT	Stock	34.0	34.0	34.0	34.0	600.0
2008-01-14 07:30:00	MSFT	Stock	34.0	34.4	34.0	34.27	37360.0
2008-01-14 08:00:00	MSFT	Stock	34.28	34.7	34.27	34.62	150555.0
2008-01-14 08:30:00	MSFT	Stock	34.62	34.75	34.61	34.69	108433.0
2008-01-14 09:00:00	MSFT	Stock	34.69	34.75	34.4	34.43	271369.0
2008-01-14 09:30:00	MSFT	Stock	34.47	34.57	34.16	34.3	4788141.0
2008-01-14 10:00:00	MSFT	Stock	34.3	34.5	34.29	34.46	3775798.0
2008-01-14 10:30:00	MSFT	Stock	34.47	34.47	34.26	34.4	4131625.0
2008-01-14 11:00:00	MSFT	Stock	34.41	34.53	34.4	34.45	4141559.0
2008-01-14 11:30:00	MSFT	Stock	34.449	34.47	34.29	34.31	2497263.0
2008-01-14 12:00:00	MSFT	Stock	34.31	34.321	34.14	34.14	3672264.0
2008-01-14 12:30:00	MSFT	Stock	34.13	34.25	34.08	34.24	2489894.0
2008-01-14 13:00:00	MSFT	Stock	34.24	34.3	34.2	34.2	2399691.0
2008-01-14 13:30:00	MSFT	Stock	34.2	34.37	34.17	34.27	3858598.0
2008-01-14 14:00:00	MSFT	Stock	34.27	34.29	34.2	34.26	2360151.0
2008-01-14 14:30:00	MSFT	Stock	34.26	34.37	34.24	34.352	4387808.0
2008-01-14 15:00:00	MSFT	Stock	34.36	34.39	34.26	34.36	3947757.0
2008-01-14 15:30:00	MSFT	Stock	34.36	34.52	34.3	34.39	7480112.0
2008-01-14 16:00:00	MSFT	Stock	34.39	34.425	33.856	34.338	2680656.0

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

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