PREVIEW / stock_30min / 2011-01-13

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-01-13.parquet
  size:    1.4 MB
  rows:    75,711
  symbols: 3,506

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
2011-01-13 04:00:00	AAPL	Stock	12.3332	12.3332	12.3214	12.3218	8400.0
2011-01-13 04:30:00	AAPL	Stock	12.3336	12.3336	12.3336	12.3336	2800.0
2011-01-13 05:30:00	AAPL	Stock	12.3393	12.375	12.3393	12.35	16800.0
2011-01-13 06:00:00	AAPL	Stock	12.3704	12.3704	12.3643	12.3643	44800.0
2011-01-13 06:30:00	AAPL	Stock	12.3607	12.375	12.3607	12.375	56000.0
2011-01-13 07:00:00	AAPL	Stock	12.375	12.375	12.3261	12.3443	282240.0
2011-01-13 07:30:00	AAPL	Stock	12.3489	12.3511	12.335	12.3446	177100.0
2011-01-13 08:00:00	AAPL	Stock	12.3446	12.3446	12.3007	12.3243	1760416.0
2011-01-13 08:30:00	AAPL	Stock	12.3243	12.3243	12.2893	12.3018	3043796.0
2011-01-13 09:00:00	AAPL	Stock	12.3004	12.3264	12.3	12.3264	1569064.0
2011-01-13 09:30:00	AAPL	Stock	12.3254	12.3325	12.2804	12.295	47577404.0
2011-01-13 10:00:00	AAPL	Stock	12.2957	12.3482	12.2825	12.3479	34486004.0
2011-01-13 10:30:00	AAPL	Stock	12.3482	12.3732	12.3357	12.3691	35408324.0
2011-01-13 11:00:00	AAPL	Stock	12.3679	12.3725	12.3596	12.3661	14873432.0
2011-01-13 11:30:00	AAPL	Stock	12.3661	12.38	12.3529	12.3536	19718384.0
2011-01-13 12:00:00	AAPL	Stock	12.3539	12.3754	12.3531	12.3648	10610180.0
2011-01-13 12:30:00	AAPL	Stock	12.3654	12.3686	12.3589	12.3596	7578676.0
2011-01-13 13:00:00	AAPL	Stock	12.3589	12.3643	12.3439	12.3493	13439048.0
2011-01-13 13:30:00	AAPL	Stock	12.3489	12.3521	12.3436	12.3489	6894832.0
2011-01-13 14:00:00	AAPL	Stock	12.35	12.3557	12.3393	12.3436	12667144.0
2011-01-13 14:30:00	AAPL	Stock	12.3443	12.3457	12.3125	12.3232	17258976.0
2011-01-13 15:00:00	AAPL	Stock	12.3243	12.35	12.3232	12.326	16890104.0
2011-01-13 15:30:00	AAPL	Stock	12.3254	12.35	12.3214	12.345	29079064.0
2011-01-13 16:00:00	AAPL	Stock	12.3457	12.3668	12.3369	12.3539	11607428.0
2011-01-13 16:30:00	AAPL	Stock	12.3546	12.3671	12.3262	12.3671	1285760.0
2011-01-13 17:00:00	AAPL	Stock	12.3643	12.3739	12.3618	12.3739	630784.0
2011-01-13 17:30:00	AAPL	Stock	12.3739	12.3857	12.3718	12.3786	379456.0
2011-01-13 18:00:00	AAPL	Stock	12.3804	12.3811	12.3457	12.3732	158228.0
2011-01-13 18:30:00	AAPL	Stock	12.375	12.375	12.3696	12.3729	543368.0
2011-01-13 19:00:00	AAPL	Stock	12.375	12.375	12.3661	12.3661	372148.0
2011-01-13 19:30:00	AAPL	Stock	12.3671	12.3714	12.3643	12.3714	379512.0
2011-01-13 04:30:00	MSFT	Stock	28.51	28.51	28.51	28.51	500.0
2011-01-13 07:00:00	MSFT	Stock	28.52	28.52	28.52	28.52	300.0
2011-01-13 07:30:00	MSFT	Stock	28.54	28.55	28.53	28.53	10100.0
2011-01-13 08:00:00	MSFT	Stock	28.55	28.55	28.5	28.5	13748.0
2011-01-13 08:30:00	MSFT	Stock	28.5	28.5	28.43	28.45	20781.0
2011-01-13 09:00:00	MSFT	Stock	28.48	28.54	28.29	28.3	192459.0
2011-01-13 09:30:00	MSFT	Stock	28.33	28.39	28.05	28.05	10773448.0
2011-01-13 10:00:00	MSFT	Stock	28.06	28.17	28.01	28.15	7112155.0
2011-01-13 10:30:00	MSFT	Stock	28.145	28.21	28.05	28.17	5554290.0
2011-01-13 11:00:00	MSFT	Stock	28.175	28.27	28.175	28.25	4172482.0
2011-01-13 11:30:00	MSFT	Stock	28.25	28.29	28.215	28.22	4417352.0
2011-01-13 12:00:00	MSFT	Stock	28.22	28.24	28.21	28.235	2017693.0
2011-01-13 12:30:00	MSFT	Stock	28.233	28.26	28.22	28.238	1632529.0
2011-01-13 13:00:00	MSFT	Stock	28.23	28.25	28.15	28.23	1982989.0
2011-01-13 13:30:00	MSFT	Stock	28.23	28.24	28.17	28.17	1198686.0
2011-01-13 14:00:00	MSFT	Stock	28.18	28.2	28.15	28.16	1673883.0
2011-01-13 14:30:00	MSFT	Stock	28.17	28.2	28.1	28.12	3557370.0
2011-01-13 15:00:00	MSFT	Stock	28.12	28.17	28.09	28.11	5640299.0
2011-01-13 15:30:00	MSFT	Stock	28.11	28.22	28.08	28.2	10298199.0

> showing 50 of 75,711 rows — these rows as CSV

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