PREVIEW / stock_30min / 2010-09-10

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-09-10.parquet
  size:    1.3 MB
  rows:    70,351
  symbols: 3,445

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
2010-09-10 04:00:00	AAPL	Stock	9.4375	9.4375	9.4375	9.4375	2800.0
2010-09-10 06:00:00	AAPL	Stock	9.4286	9.4286	9.4286	9.4286	2800.0
2010-09-10 07:00:00	AAPL	Stock	9.4357	9.4357	9.42	9.42	86800.0
2010-09-10 07:30:00	AAPL	Stock	9.4257	9.4257	9.4107	9.4171	86968.0
2010-09-10 08:00:00	AAPL	Stock	9.4132	9.4164	9.4071	9.4125	579880.0
2010-09-10 08:30:00	AAPL	Stock	9.4146	9.4386	9.4039	9.4039	1855588.0
2010-09-10 09:00:00	AAPL	Stock	9.4036	9.4118	9.3954	9.3957	714700.0
2010-09-10 09:30:00	AAPL	Stock	9.3961	9.4185	9.3357	9.3839	90402368.0
2010-09-10 10:00:00	AAPL	Stock	9.3846	9.4312	9.3696	9.4286	39083604.0
2010-09-10 10:30:00	AAPL	Stock	9.4286	9.4464	9.4139	9.4432	29153712.0
2010-09-10 11:00:00	AAPL	Stock	9.4436	9.4457	9.4036	9.4211	20424404.0
2010-09-10 11:30:00	AAPL	Stock	9.4211	9.4261	9.3871	9.3978	14719824.0
2010-09-10 12:00:00	AAPL	Stock	9.3964	9.3976	9.3607	9.3761	24118080.0
2010-09-10 12:30:00	AAPL	Stock	9.3764	9.3918	9.3554	9.3839	19666584.0
2010-09-10 13:00:00	AAPL	Stock	9.3846	9.3914	9.3693	9.3832	15568672.0
2010-09-10 13:30:00	AAPL	Stock	9.3832	9.3929	9.3757	9.3868	17196368.0
2010-09-10 14:00:00	AAPL	Stock	9.3864	9.4121	9.3839	9.4093	23089752.0
2010-09-10 14:30:00	AAPL	Stock	9.4103	9.425	9.4082	9.4154	18669028.0
2010-09-10 15:00:00	AAPL	Stock	9.415	9.4233	9.4086	9.4214	19521348.0
2010-09-10 15:30:00	AAPL	Stock	9.4211	9.4246	9.3905	9.4071	39820200.0
2010-09-10 16:00:00	AAPL	Stock	9.4075	9.4186	9.3679	9.4107	7123284.0
2010-09-10 16:30:00	AAPL	Stock	9.4111	9.4143	9.3997	9.4007	342524.0
2010-09-10 17:00:00	AAPL	Stock	9.4004	9.4107	9.4	9.4096	56476.0
2010-09-10 17:30:00	AAPL	Stock	9.4036	9.4071	9.4018	9.4029	72800.0
2010-09-10 18:00:00	AAPL	Stock	9.4029	9.4075	9.4021	9.4036	123032.0
2010-09-10 18:30:00	AAPL	Stock	9.4018	9.4025	9.4004	9.4025	57876.0
2010-09-10 19:00:00	AAPL	Stock	9.4036	9.4125	9.4036	9.4125	104608.0
2010-09-10 19:30:00	AAPL	Stock	9.4125	9.4125	9.4043	9.4043	5600.0
2010-09-10 05:30:00	MSFT	Stock	23.91	23.91	23.89	23.89	2900.0
2010-09-10 06:00:00	MSFT	Stock	23.93	23.93	23.91	23.91	1000.0
2010-09-10 06:30:00	MSFT	Stock	23.92	23.99	23.9	23.99	4700.0
2010-09-10 07:00:00	MSFT	Stock	23.95	23.95	23.94	23.94	2800.0
2010-09-10 07:30:00	MSFT	Stock	23.99	23.99	23.97	23.99	2100.0
2010-09-10 08:00:00	MSFT	Stock	23.99	24.08	23.97	24.05	20236.0
2010-09-10 08:30:00	MSFT	Stock	24.04	24.06	24.03	24.05	149700.0
2010-09-10 09:00:00	MSFT	Stock	24.04	24.04	23.98	23.98	32809.0
2010-09-10 09:30:00	MSFT	Stock	23.99	24.03	23.87	23.94	5691748.0
2010-09-10 10:00:00	MSFT	Stock	23.94	23.94	23.85	23.92	6697750.0
2010-09-10 10:30:00	MSFT	Stock	23.93	23.93	23.85	23.9	3586199.0
2010-09-10 11:00:00	MSFT	Stock	23.9	23.9	23.82	23.88	4098593.0
2010-09-10 11:30:00	MSFT	Stock	23.88	23.9	23.79	23.81	3406308.0
2010-09-10 12:00:00	MSFT	Stock	23.81	23.87	23.8	23.84	2407334.0
2010-09-10 12:30:00	MSFT	Stock	23.835	23.84	23.79	23.795	2539093.0
2010-09-10 13:00:00	MSFT	Stock	23.8	23.84	23.79	23.84	2282284.0
2010-09-10 13:30:00	MSFT	Stock	23.84	23.86	23.81	23.825	1607456.0
2010-09-10 14:00:00	MSFT	Stock	23.825	23.88	23.81	23.85	3622604.0
2010-09-10 14:30:00	MSFT	Stock	23.85	23.86	23.82	23.825	2985604.0
2010-09-10 15:00:00	MSFT	Stock	23.83	23.85	23.8	23.845	4333169.0
2010-09-10 15:30:00	MSFT	Stock	23.85	23.88	23.8	23.85	8117508.0
2010-09-10 16:00:00	MSFT	Stock	23.85	23.9	23.81	23.83	1706369.0

> showing 50 of 70,351 rows — these rows as CSV

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