PREVIEW / stock_30min / 2007-01-12

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-01-12.parquet
  size:    969 KB
  rows:    52,235
  symbols: 2,495

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
2007-01-12 04:00:00	AAPL	Stock	3.4171	3.4171	3.4171	3.4171	14000.0
2007-01-12 04:30:00	AAPL	Stock	3.4168	3.4171	3.4161	3.4171	47600.0
2007-01-12 05:00:00	AAPL	Stock	3.4214	3.4214	3.4214	3.4214	8400.0
2007-01-12 05:30:00	AAPL	Stock	3.4196	3.4196	3.4071	3.4111	333228.0
2007-01-12 06:00:00	AAPL	Stock	3.4111	3.4193	3.4036	3.4036	198800.0
2007-01-12 06:30:00	AAPL	Stock	3.4143	3.4175	3.4018	3.4025	56000.0
2007-01-12 07:00:00	AAPL	Stock	3.4021	3.4036	3.3936	3.3964	256760.0
2007-01-12 07:30:00	AAPL	Stock	3.3968	3.3989	3.38	3.3989	2597924.0
2007-01-12 08:00:00	AAPL	Stock	3.3946	3.3946	3.3679	3.3818	7012880.0
2007-01-12 08:30:00	AAPL	Stock	3.3821	3.3929	3.3821	3.3857	7132440.0
2007-01-12 09:00:00	AAPL	Stock	3.3861	3.3914	3.3757	3.3779	6969508.0
2007-01-12 09:30:00	AAPL	Stock	3.3782	3.3786	3.3468	3.3693	291278624.0
2007-01-12 10:00:00	AAPL	Stock	3.37	3.37	3.3296	3.3439	207923520.0
2007-01-12 10:30:00	AAPL	Stock	3.3443	3.3714	3.3354	3.3693	136375092.0
2007-01-12 11:00:00	AAPL	Stock	3.3689	3.3771	3.3621	3.3689	101075436.0
2007-01-12 11:30:00	AAPL	Stock	3.3686	3.3929	3.3632	3.3861	108187380.0
2007-01-12 12:00:00	AAPL	Stock	3.3857	3.3921	3.3772	3.3871	58728404.0
2007-01-12 12:30:00	AAPL	Stock	3.3875	3.3886	3.3671	3.3711	55873664.0
2007-01-12 13:00:00	AAPL	Stock	3.3707	3.3761	3.3625	3.3625	52582908.0
2007-01-12 13:30:00	AAPL	Stock	3.3625	3.3746	3.3589	3.3668	38952816.0
2007-01-12 14:00:00	AAPL	Stock	3.3668	3.3743	3.3664	3.372	29069712.0
2007-01-12 14:30:00	AAPL	Stock	3.3721	3.3832	3.3707	3.3754	43110816.0
2007-01-12 15:00:00	AAPL	Stock	3.3754	3.3929	3.3746	3.3921	57798076.0
2007-01-12 15:30:00	AAPL	Stock	3.3925	3.395	3.3771	3.3818	91261380.0
2007-01-12 16:00:00	AAPL	Stock	3.3811	3.3821	3.3786	3.3811	1664348.0
2007-01-12 16:30:00	AAPL	Stock	3.3804	3.3811	3.3789	3.3793	392896.0
2007-01-12 17:00:00	AAPL	Stock	3.3793	3.3804	3.3786	3.38	216356.0
2007-01-12 17:30:00	AAPL	Stock	3.3804	3.3804	3.3779	3.38	135800.0
2007-01-12 18:00:00	AAPL	Stock	3.3782	3.3814	3.3782	3.3814	225428.0
2007-01-12 18:30:00	AAPL	Stock	3.3796	3.3821	3.3796	3.3821	145544.0
2007-01-12 19:00:00	AAPL	Stock	3.3818	3.3818	3.3793	3.3818	51016.0
2007-01-12 19:30:00	AAPL	Stock	3.3818	3.3821	3.3804	3.3804	121716.0
2007-01-12 04:00:00	MSFT	Stock	30.82	30.82	30.82	30.82	200.0
2007-01-12 07:00:00	MSFT	Stock	30.65	30.65	30.4	30.55	35000.0
2007-01-12 07:30:00	MSFT	Stock	30.52	30.55	30.45	30.55	53264.0
2007-01-12 08:00:00	MSFT	Stock	30.58	30.6	30.52	30.6	66900.0
2007-01-12 08:30:00	MSFT	Stock	30.6	30.6	30.57	30.6	44579.0
2007-01-12 09:00:00	MSFT	Stock	30.6	30.65	30.57	30.65	165978.0
2007-01-12 09:30:00	MSFT	Stock	30.65	30.99	30.64	30.98	13943569.0
2007-01-12 10:00:00	MSFT	Stock	30.97	30.99	30.84	30.965	9434112.0
2007-01-12 10:30:00	MSFT	Stock	30.965	30.98	30.81	30.92	7596550.0
2007-01-12 11:00:00	MSFT	Stock	30.92	30.96	30.85	30.93	6520913.0
2007-01-12 11:30:00	MSFT	Stock	30.93	31.1	30.9	31.02	12428967.0
2007-01-12 12:00:00	MSFT	Stock	31.02	31.2	31.0	31.18	5638153.0
2007-01-12 12:30:00	MSFT	Stock	31.18	31.21	31.15	31.19	4003191.0
2007-01-12 13:00:00	MSFT	Stock	31.19	31.25	31.18	31.2	5395534.0
2007-01-12 13:30:00	MSFT	Stock	31.2	31.2	31.17	31.17	3554417.0
2007-01-12 14:00:00	MSFT	Stock	31.18	31.21	31.17	31.21	3886864.0
2007-01-12 14:30:00	MSFT	Stock	31.21	31.28	31.18	31.19	5752057.0
2007-01-12 15:00:00	MSFT	Stock	31.2	31.39	31.19	31.338	10526596.0

> showing 50 of 52,235 rows — these rows as CSV

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