PREVIEW / stock_30min / 2010-09-09

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-09-09.parquet
  size:    1.4 MB
  rows:    73,681
  symbols: 3,460

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-09 04:30:00	AAPL	Stock	9.3757	9.3757	9.3757	9.3757	4200.0
2010-09-09 05:00:00	AAPL	Stock	9.4046	9.405	9.4046	9.405	28000.0
2010-09-09 07:00:00	AAPL	Stock	9.4071	9.4196	9.4071	9.41	58800.0
2010-09-09 07:30:00	AAPL	Stock	9.4171	9.425	9.4107	9.4125	132636.0
2010-09-09 08:00:00	AAPL	Stock	9.4139	9.4193	9.3929	9.3964	928032.0
2010-09-09 08:30:00	AAPL	Stock	9.3964	9.4804	9.3964	9.4775	5079928.0
2010-09-09 09:00:00	AAPL	Stock	9.4775	9.4929	9.4646	9.4675	3143812.0
2010-09-09 09:30:00	AAPL	Stock	9.4675	9.5	9.4521	9.4907	79235716.0
2010-09-09 10:00:00	AAPL	Stock	9.49	9.5186	9.4861	9.5154	49733992.0
2010-09-09 10:30:00	AAPL	Stock	9.5153	9.5157	9.4839	9.4864	30135560.0
2010-09-09 11:00:00	AAPL	Stock	9.4882	9.5118	9.4839	9.5093	21107772.0
2010-09-09 11:30:00	AAPL	Stock	9.5096	9.5129	9.4989	9.5085	15092140.0
2010-09-09 12:00:00	AAPL	Stock	9.5084	9.5107	9.4946	9.5019	15261456.0
2010-09-09 12:30:00	AAPL	Stock	9.5018	9.5079	9.4771	9.479	17632972.0
2010-09-09 13:00:00	AAPL	Stock	9.4794	9.4796	9.4296	9.4325	40531540.0
2010-09-09 13:30:00	AAPL	Stock	9.4325	9.4518	9.4039	9.4318	35664692.0
2010-09-09 14:00:00	AAPL	Stock	9.4311	9.4454	9.4243	9.4382	18475464.0
2010-09-09 14:30:00	AAPL	Stock	9.4379	9.4643	9.4343	9.4614	18020548.0
2010-09-09 15:00:00	AAPL	Stock	9.4614	9.4679	9.4546	9.4593	17635268.0
2010-09-09 15:30:00	AAPL	Stock	9.4587	9.4625	9.3936	9.3954	49925540.0
2010-09-09 16:00:00	AAPL	Stock	9.4089	9.5006	9.3868	9.395	9467696.0
2010-09-09 16:30:00	AAPL	Stock	9.3946	9.4601	9.3893	9.3893	717528.0
2010-09-09 17:00:00	AAPL	Stock	9.3893	9.3942	9.375	9.3779	626724.0
2010-09-09 17:30:00	AAPL	Stock	9.3839	9.3911	9.375	9.3821	481096.0
2010-09-09 18:00:00	AAPL	Stock	9.3771	9.3954	9.3754	9.3786	178052.0
2010-09-09 18:30:00	AAPL	Stock	9.3811	9.3821	9.3761	9.3821	86800.0
2010-09-09 19:00:00	AAPL	Stock	9.3804	9.3804	9.3771	9.3771	24500.0
2010-09-09 19:30:00	AAPL	Stock	9.3771	9.3825	9.3768	9.3789	327348.0
2010-09-09 07:00:00	MSFT	Stock	24.05	24.05	24.05	24.05	100.0
2010-09-09 07:30:00	MSFT	Stock	24.05	24.06	24.05	24.06	1100.0
2010-09-09 08:00:00	MSFT	Stock	23.97	24.05	23.97	24.05	3593.0
2010-09-09 08:30:00	MSFT	Stock	24.05	24.15	24.05	24.09	26992.0
2010-09-09 09:00:00	MSFT	Stock	24.11	24.2	23.92	24.19	175750.0
2010-09-09 09:30:00	MSFT	Stock	24.2	24.21	24.08	24.082	7165811.0
2010-09-09 10:00:00	MSFT	Stock	24.09	24.15	24.075	24.12	3315190.0
2010-09-09 10:30:00	MSFT	Stock	24.112	24.12	24.08	24.098	3001356.0
2010-09-09 11:00:00	MSFT	Stock	24.08	24.14	24.08	24.1	2283220.0
2010-09-09 11:30:00	MSFT	Stock	24.108	24.13	24.07	24.12	3361461.0
2010-09-09 12:00:00	MSFT	Stock	24.112	24.13	24.09	24.111	1746285.0
2010-09-09 12:30:00	MSFT	Stock	24.118	24.13	24.09	24.09	2106602.0
2010-09-09 13:00:00	MSFT	Stock	24.09	24.12	24.06	24.07	2467044.0
2010-09-09 13:30:00	MSFT	Stock	24.07	24.14	24.042	24.08	2654002.0
2010-09-09 14:00:00	MSFT	Stock	24.08	24.13	24.06	24.111	2201381.0
2010-09-09 14:30:00	MSFT	Stock	24.11	24.17	24.11	24.17	1992992.0
2010-09-09 15:00:00	MSFT	Stock	24.17	24.18	24.09	24.11	3146233.0
2010-09-09 15:30:00	MSFT	Stock	24.105	24.13	23.99	24.01	6347829.0
2010-09-09 16:00:00	MSFT	Stock	24.01	24.111	23.99	24.0	2777877.0
2010-09-09 16:30:00	MSFT	Stock	24.01	24.105	23.951	24.105	20800.0
2010-09-09 17:00:00	MSFT	Stock	24.0	24.007	24.0	24.007	3225.0
2010-09-09 17:30:00	MSFT	Stock	24.0	24.0	24.0	24.0	2092.0

> showing 50 of 73,681 rows — these rows as CSV

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