PREVIEW / stock_30min / 2009-02-17

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-02-17.parquet
  size:    1.2 MB
  rows:    70,407
  symbols: 3,303

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-17 04:00:00	AAPL	Stock	3.5182	3.5182	3.5182	3.5182	2800.0
2009-02-17 05:30:00	AAPL	Stock	3.4821	3.4821	3.4821	3.4821	2800.0
2009-02-17 07:30:00	AAPL	Stock	3.4714	3.4714	3.4571	3.4643	53144.0
2009-02-17 08:00:00	AAPL	Stock	3.4696	3.4821	3.4575	3.475	352884.0
2009-02-17 08:30:00	AAPL	Stock	3.4764	3.4779	3.4454	3.4582	1500128.0
2009-02-17 09:00:00	AAPL	Stock	3.4582	3.47	3.4393	3.4629	3006892.0
2009-02-17 09:30:00	AAPL	Stock	3.4596	3.4657	3.3764	3.4071	112194460.0
2009-02-17 10:00:00	AAPL	Stock	3.4071	3.4186	3.3896	3.405	46728220.0
2009-02-17 10:30:00	AAPL	Stock	3.405	3.4332	3.4021	3.4236	56063420.0
2009-02-17 11:00:00	AAPL	Stock	3.4232	3.4236	3.3979	3.4018	38451868.0
2009-02-17 11:30:00	AAPL	Stock	3.4021	3.4021	3.3857	3.3868	31587332.0
2009-02-17 12:00:00	AAPL	Stock	3.3868	3.3996	3.3825	3.3886	28485856.0
2009-02-17 12:30:00	AAPL	Stock	3.3889	3.3964	3.3861	3.3932	19345256.0
2009-02-17 13:00:00	AAPL	Stock	3.3936	3.395	3.3779	3.3821	26807536.0
2009-02-17 13:30:00	AAPL	Stock	3.3818	3.4043	3.3775	3.3896	37801764.0
2009-02-17 14:00:00	AAPL	Stock	3.39	3.4014	3.3825	3.389	29200388.0
2009-02-17 14:30:00	AAPL	Stock	3.3886	3.4129	3.3857	3.3896	43754676.0
2009-02-17 15:00:00	AAPL	Stock	3.3896	3.4	3.3671	3.38	59698352.0
2009-02-17 15:30:00	AAPL	Stock	3.38	3.4196	3.3757	3.3761	101070340.0
2009-02-17 16:00:00	AAPL	Stock	3.3761	3.4072	3.376	3.3886	15839880.0
2009-02-17 16:30:00	AAPL	Stock	3.3893	3.3893	3.3761	3.3786	4703440.0
2009-02-17 17:00:00	AAPL	Stock	3.3786	3.3829	3.3771	3.3789	95200.0
2009-02-17 17:30:00	AAPL	Stock	3.3804	3.3818	3.3661	3.3782	89040.0
2009-02-17 18:00:00	AAPL	Stock	3.3768	3.3786	3.3761	3.3768	17488072.0
2009-02-17 18:30:00	AAPL	Stock	3.3768	3.3768	3.3746	3.3746	59640.0
2009-02-17 19:00:00	AAPL	Stock	3.3804	3.3804	3.3661	3.3661	197400.0
2009-02-17 19:30:00	AAPL	Stock	3.3664	3.3696	3.3661	3.3696	53060.0
2009-02-17 07:00:00	MSFT	Stock	18.66	18.67	18.66	18.66	1630.0
2009-02-17 07:30:00	MSFT	Stock	18.7	18.7	18.7	18.7	500.0
2009-02-17 08:00:00	MSFT	Stock	18.7	18.86	18.69	18.7	17508.0
2009-02-17 08:30:00	MSFT	Stock	18.74	18.74	18.38	18.4	35488.0
2009-02-17 09:00:00	MSFT	Stock	18.53	18.78	18.38	18.4	60190.0
2009-02-17 09:30:00	MSFT	Stock	18.45	18.5	17.89	17.96	12074144.0
2009-02-17 10:00:00	MSFT	Stock	17.97	18.08	17.93	18.05	6654015.0
2009-02-17 10:30:00	MSFT	Stock	18.05	18.21	18.04	18.15	6732088.0
2009-02-17 11:00:00	MSFT	Stock	18.14	18.25	18.07	18.15	5760148.0
2009-02-17 11:30:00	MSFT	Stock	18.15	18.23	18.12	18.185	4426115.0
2009-02-17 12:00:00	MSFT	Stock	18.185	18.26	18.15	18.21	3512349.0
2009-02-17 12:30:00	MSFT	Stock	18.218	18.26	18.19	18.26	2350429.0
2009-02-17 13:00:00	MSFT	Stock	18.255	18.26	18.14	18.21	3215678.0
2009-02-17 13:30:00	MSFT	Stock	18.2	18.37	18.18	18.241	3945475.0
2009-02-17 14:00:00	MSFT	Stock	18.25	18.43	18.22	18.36	3782797.0
2009-02-17 14:30:00	MSFT	Stock	18.36	18.5	18.35	18.38	4310310.0
2009-02-17 15:00:00	MSFT	Stock	18.385	18.43	18.23	18.272	3444273.0
2009-02-17 15:30:00	MSFT	Stock	18.27	18.5	18.1	18.1	10731018.0
2009-02-17 16:00:00	MSFT	Stock	18.09	18.35	18.01	18.11	3301583.0
2009-02-17 16:30:00	MSFT	Stock	18.11	18.21	18.09	18.13	478374.0
2009-02-17 17:00:00	MSFT	Stock	18.13	18.207	18.12	18.15	385609.0
2009-02-17 17:30:00	MSFT	Stock	18.19	18.19	18.19	18.19	300.0
2009-02-17 18:00:00	MSFT	Stock	18.09	18.15	18.09	18.12	19812.0

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

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