PREVIEW / stock_30min / 2008-02-08

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-02-08.parquet
  size:    1.2 MB
  rows:    67,459
  symbols: 3,256

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-02-08 06:00:00	AAPL	Stock	4.3464	4.3464	4.3464	4.3464	9800.0
2008-02-08 06:30:00	AAPL	Stock	4.3382	4.3382	4.3382	4.3382	2800.0
2008-02-08 07:00:00	AAPL	Stock	4.3311	4.3429	4.295	4.3107	330064.0
2008-02-08 07:30:00	AAPL	Stock	4.3107	4.3214	4.3075	4.3089	95340.0
2008-02-08 08:00:00	AAPL	Stock	4.3157	4.3514	4.3129	4.3214	1615488.0
2008-02-08 08:30:00	AAPL	Stock	4.3211	4.345	4.3189	4.3446	2120720.0
2008-02-08 09:00:00	AAPL	Stock	4.3464	4.3736	4.3464	4.3604	4058712.0
2008-02-08 09:30:00	AAPL	Stock	4.3604	4.4243	4.3596	4.4211	168084980.0
2008-02-08 10:00:00	AAPL	Stock	4.42	4.4643	4.4061	4.4557	149279284.0
2008-02-08 10:30:00	AAPL	Stock	4.4564	4.4679	4.4232	4.4518	109489380.0
2008-02-08 11:00:00	AAPL	Stock	4.4518	4.4843	4.4475	4.4571	95934020.0
2008-02-08 11:30:00	AAPL	Stock	4.4571	4.4768	4.4332	4.4361	73689924.0
2008-02-08 12:00:00	AAPL	Stock	4.4357	4.4536	4.4146	4.4332	69829004.0
2008-02-08 12:30:00	AAPL	Stock	4.4336	4.4511	4.4207	4.4404	58611448.0
2008-02-08 13:00:00	AAPL	Stock	4.44	4.4404	4.3893	4.4046	75735492.0
2008-02-08 13:30:00	AAPL	Stock	4.4046	4.406	4.3429	4.3836	116051320.0
2008-02-08 14:00:00	AAPL	Stock	4.3839	4.4186	4.3629	4.4046	82753944.0
2008-02-08 14:30:00	AAPL	Stock	4.4046	4.4275	4.3893	4.3925	73555496.0
2008-02-08 15:00:00	AAPL	Stock	4.3929	4.4471	4.3725	4.4468	94131828.0
2008-02-08 15:30:00	AAPL	Stock	4.4471	4.4893	4.4343	4.4889	158843720.0
2008-02-08 16:00:00	AAPL	Stock	4.4893	4.4893	4.4141	4.4718	19630492.0
2008-02-08 16:30:00	AAPL	Stock	4.4746	4.4814	4.4714	4.475	576604.0
2008-02-08 17:00:00	AAPL	Stock	4.4782	4.4839	4.4754	4.4804	494284.0
2008-02-08 17:30:00	AAPL	Stock	4.485	4.4886	4.4821	4.4868	221340.0
2008-02-08 18:00:00	AAPL	Stock	4.4857	4.4975	4.4857	4.4904	446152.0
2008-02-08 18:30:00	AAPL	Stock	4.4907	4.4943	4.4907	4.4921	54236.0
2008-02-08 19:00:00	AAPL	Stock	4.4921	4.4982	4.4921	4.4961	236376.0
2008-02-08 19:30:00	AAPL	Stock	4.4957	4.4961	4.4911	4.4911	99512.0
2008-02-08 06:00:00	MSFT	Stock	28.05	28.1	28.05	28.1	10000.0
2008-02-08 06:30:00	MSFT	Stock	28.0	28.0	28.0	28.0	318.0
2008-02-08 07:00:00	MSFT	Stock	28.0	28.19	28.0	28.08	21180.0
2008-02-08 07:30:00	MSFT	Stock	28.1	28.29	28.1	28.17	20816.0
2008-02-08 08:00:00	MSFT	Stock	28.25	28.33	28.15	28.2	104088.0
2008-02-08 08:30:00	MSFT	Stock	28.21	28.25	28.1	28.17	235791.0
2008-02-08 09:00:00	MSFT	Stock	28.17	28.33	28.15	28.29	381078.0
2008-02-08 09:30:00	MSFT	Stock	28.29	28.78	28.26	28.71	16579366.0
2008-02-08 10:00:00	MSFT	Stock	28.72	29.05	28.69	29.02	20403519.0
2008-02-08 10:30:00	MSFT	Stock	29.02	29.08	28.95	28.958	10971068.0
2008-02-08 11:00:00	MSFT	Stock	28.96	29.0	28.85	28.91	6644290.0
2008-02-08 11:30:00	MSFT	Stock	28.91	28.92	28.63	28.64	7136469.0
2008-02-08 12:00:00	MSFT	Stock	28.63	28.7	28.48	28.62	5347152.0
2008-02-08 12:30:00	MSFT	Stock	28.63	28.997	28.5	28.58	4271724.0
2008-02-08 13:00:00	MSFT	Stock	28.58	28.58	28.38	28.44	5376366.0
2008-02-08 13:30:00	MSFT	Stock	28.44	28.47	28.31	28.38	9198940.0
2008-02-08 14:00:00	MSFT	Stock	28.38	28.48	28.3	28.46	5644725.0
2008-02-08 14:30:00	MSFT	Stock	28.46	28.54	28.29	28.29	5276303.0
2008-02-08 15:00:00	MSFT	Stock	28.3	28.49	28.24	28.46	8394830.0
2008-02-08 15:30:00	MSFT	Stock	28.47	28.62	28.42	28.56	16960882.0
2008-02-08 16:00:00	MSFT	Stock	28.57	28.636	28.435	28.55	2824054.0
2008-02-08 16:30:00	MSFT	Stock	28.56	28.61	28.55	28.6	13708.0

> showing 50 of 67,459 rows — these rows as CSV

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