PREVIEW / stock_30min / 2009-02-04

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-02-04.parquet
  size:    1.2 MB
  rows:    67,191
  symbols: 3,304

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-02-04 06:30:00	AAPL	Stock	3.2968	3.3054	3.2743	3.2743	30800.0
2009-02-04 07:00:00	AAPL	Stock	3.3143	3.3143	3.3036	3.3036	8400.0
2009-02-04 07:30:00	AAPL	Stock	3.3036	3.3036	3.3036	3.3036	27160.0
2009-02-04 08:00:00	AAPL	Stock	3.3089	3.3207	3.3036	3.3096	217756.0
2009-02-04 08:30:00	AAPL	Stock	3.3096	3.3304	3.3096	3.3286	473984.0
2009-02-04 09:00:00	AAPL	Stock	3.3293	3.335	3.3207	3.3321	4138064.0
2009-02-04 09:30:00	AAPL	Stock	3.3304	3.3907	3.325	3.3864	89166700.0
2009-02-04 10:00:00	AAPL	Stock	3.3864	3.4196	3.3864	3.4186	92737988.0
2009-02-04 10:30:00	AAPL	Stock	3.4182	3.4279	3.4118	3.4207	56461776.0
2009-02-04 11:00:00	AAPL	Stock	3.4207	3.4304	3.4157	3.4232	51589104.0
2009-02-04 11:30:00	AAPL	Stock	3.4236	3.4348	3.4143	3.4246	53144056.0
2009-02-04 12:00:00	AAPL	Stock	3.4254	3.4375	3.4232	3.4304	48263488.0
2009-02-04 12:30:00	AAPL	Stock	3.4304	3.4339	3.4161	3.42	37824080.0
2009-02-04 13:00:00	AAPL	Stock	3.4204	3.4204	3.3875	3.4074	53841844.0
2009-02-04 13:30:00	AAPL	Stock	3.4075	3.41	3.3607	3.3761	63446516.0
2009-02-04 14:00:00	AAPL	Stock	3.3757	3.3829	3.3404	3.3507	55373696.0
2009-02-04 14:30:00	AAPL	Stock	3.3507	3.3739	3.3446	3.3725	44902004.0
2009-02-04 15:00:00	AAPL	Stock	3.3729	3.3807	3.3468	3.3689	61407864.0
2009-02-04 15:30:00	AAPL	Stock	3.3682	3.3729	3.3393	3.3418	68069232.0
2009-02-04 16:00:00	AAPL	Stock	3.34	3.3912	3.3393	3.3554	7369180.0
2009-02-04 16:30:00	AAPL	Stock	3.3536	3.3536	3.3382	3.3393	621264.0
2009-02-04 17:00:00	AAPL	Stock	3.3332	3.3375	3.2982	3.3	1309756.0
2009-02-04 17:30:00	AAPL	Stock	3.2996	3.3107	3.2996	3.3071	317996.0
2009-02-04 18:00:00	AAPL	Stock	3.3071	3.3411	3.3036	3.3039	3975244.0
2009-02-04 18:30:00	AAPL	Stock	3.3039	3.3111	3.3036	3.3057	44660.0
2009-02-04 19:00:00	AAPL	Stock	3.3071	3.3075	3.3071	3.3075	11200.0
2009-02-04 19:30:00	AAPL	Stock	3.3118	3.315	3.3114	3.3121	33040.0
2009-02-04 07:30:00	MSFT	Stock	18.41	18.62	18.38	18.51	3500.0
2009-02-04 08:00:00	MSFT	Stock	18.51	18.61	18.5	18.58	17005.0
2009-02-04 08:30:00	MSFT	Stock	18.57	18.58	18.5	18.51	12196.0
2009-02-04 09:00:00	MSFT	Stock	18.51	18.54	18.43	18.52	279067.0
2009-02-04 09:30:00	MSFT	Stock	18.54	18.8	18.5	18.79	6351879.0
2009-02-04 10:00:00	MSFT	Stock	18.79	18.97	18.72	18.79	8896745.0
2009-02-04 10:30:00	MSFT	Stock	18.78	18.94	18.75	18.79	7006939.0
2009-02-04 11:00:00	MSFT	Stock	18.79	18.91	18.74	18.85	5008120.0
2009-02-04 11:30:00	MSFT	Stock	18.85	18.94	18.79	18.94	3635232.0
2009-02-04 12:00:00	MSFT	Stock	18.94	19.0	18.82	18.82	3406819.0
2009-02-04 12:30:00	MSFT	Stock	18.822	18.92	18.81	18.85	3670588.0
2009-02-04 13:00:00	MSFT	Stock	18.85	18.88	18.77	18.87	3324083.0
2009-02-04 13:30:00	MSFT	Stock	18.86	18.87	18.61	18.74	7120544.0
2009-02-04 14:00:00	MSFT	Stock	18.73	18.8	18.55	18.658	5348013.0
2009-02-04 14:30:00	MSFT	Stock	18.652	18.82	18.63	18.79	4446510.0
2009-02-04 15:00:00	MSFT	Stock	18.78	18.84	18.73	18.81	5507934.0
2009-02-04 15:30:00	MSFT	Stock	18.805	18.84	18.64	18.64	7273031.0
2009-02-04 16:00:00	MSFT	Stock	18.64	18.873	18.586	18.69	2099274.0
2009-02-04 16:30:00	MSFT	Stock	18.69	18.73	18.6	18.6	39131.0
2009-02-04 17:00:00	MSFT	Stock	18.56	18.8	18.33	18.33	47018.0
2009-02-04 17:30:00	MSFT	Stock	18.31	18.4	18.31	18.37	11300.0
2009-02-04 18:00:00	MSFT	Stock	18.36	18.49	18.32	18.44	19400.0
2009-02-04 18:30:00	MSFT	Stock	18.44	18.47	18.44	18.44	1400.0

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

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