PREVIEW / stock_30min / 2008-10-14

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-10-14.parquet
  size:    1.3 MB
  rows:    73,643
  symbols: 3,373

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
2008-10-14 04:00:00	AAPL	Stock	4.1071	4.1071	4.1068	4.1071	61600.0
2008-10-14 04:30:00	AAPL	Stock	4.1071	4.1071	4.0804	4.0943	68600.0
2008-10-14 05:00:00	AAPL	Stock	4.0946	4.1046	4.0714	4.0714	109200.0
2008-10-14 05:30:00	AAPL	Stock	4.1043	4.1046	4.1043	4.1046	13300.0
2008-10-14 06:00:00	AAPL	Stock	4.1046	4.125	4.1046	4.125	66108.0
2008-10-14 06:30:00	AAPL	Stock	4.1246	4.125	4.1171	4.125	230384.0
2008-10-14 07:00:00	AAPL	Stock	4.1168	4.1357	4.0804	4.0821	834932.0
2008-10-14 07:30:00	AAPL	Stock	4.0893	4.1	4.0	4.0768	1439200.0
2008-10-14 08:00:00	AAPL	Stock	4.0821	4.1036	4.0714	4.1018	4610256.0
2008-10-14 08:30:00	AAPL	Stock	4.1018	4.1486	4.0893	4.1207	6076952.0
2008-10-14 09:00:00	AAPL	Stock	4.1207	4.1607	4.0736	4.1511	16458792.0
2008-10-14 09:30:00	AAPL	Stock	4.1521	4.1571	3.9371	3.9379	265066536.0
2008-10-14 10:00:00	AAPL	Stock	3.9372	4.0268	3.9132	4.0132	213432520.0
2008-10-14 10:30:00	AAPL	Stock	4.0132	4.0304	3.8393	3.9335	170248036.0
2008-10-14 11:00:00	AAPL	Stock	3.9321	3.9321	3.8179	3.8857	138120304.0
2008-10-14 11:30:00	AAPL	Stock	3.8857	3.9786	3.8575	3.9325	107375352.0
2008-10-14 12:00:00	AAPL	Stock	3.9336	3.9345	3.8886	3.9329	83424768.0
2008-10-14 12:30:00	AAPL	Stock	3.9282	3.9854	3.9075	3.9086	69694464.0
2008-10-14 13:00:00	AAPL	Stock	3.9089	3.9357	3.7971	3.8382	91262444.0
2008-10-14 13:30:00	AAPL	Stock	3.8393	3.8821	3.7682	3.7954	126757288.0
2008-10-14 14:00:00	AAPL	Stock	3.7954	3.8126	3.6836	3.7679	154107884.0
2008-10-14 14:30:00	AAPL	Stock	3.7679	3.7771	3.6893	3.745	124132176.0
2008-10-14 15:00:00	AAPL	Stock	3.7439	3.8354	3.725	3.7986	137765292.0
2008-10-14 15:30:00	AAPL	Stock	3.7968	4.135	3.7143	3.7143	175138488.0
2008-10-14 16:00:00	AAPL	Stock	3.7143	4.0545	3.7039	3.77	32442704.0
2008-10-14 16:30:00	AAPL	Stock	3.7779	3.7993	3.7171	3.7929	13343652.0
2008-10-14 17:00:00	AAPL	Stock	3.7921	3.7929	3.7171	3.7171	10673404.0
2008-10-14 17:30:00	AAPL	Stock	3.7479	3.7482	3.7171	3.745	1691620.0
2008-10-14 18:00:00	AAPL	Stock	3.7411	3.7568	3.7411	3.7568	262724.0
2008-10-14 18:30:00	AAPL	Stock	3.7568	3.7589	3.74	3.7446	352660.0
2008-10-14 19:00:00	AAPL	Stock	3.7446	3.7657	3.725	3.7268	223384.0
2008-10-14 19:30:00	AAPL	Stock	3.7254	3.7393	3.7211	3.7211	441280.0
2008-10-14 05:30:00	MSFT	Stock	25.85	25.88	25.85	25.88	300.0
2008-10-14 06:00:00	MSFT	Stock	25.89	26.0	25.89	26.0	800.0
2008-10-14 06:30:00	MSFT	Stock	25.95	25.95	25.95	25.95	100.0
2008-10-14 07:00:00	MSFT	Stock	26.0	26.0	25.86	25.95	12033.0
2008-10-14 07:30:00	MSFT	Stock	25.89	26.42	25.8	25.9	48700.0
2008-10-14 08:00:00	MSFT	Stock	25.9	25.95	25.7	25.8	97524.0
2008-10-14 08:30:00	MSFT	Stock	25.88	26.0	25.75	25.75	178650.0
2008-10-14 09:00:00	MSFT	Stock	25.77	25.84	25.54	25.63	258648.0
2008-10-14 09:30:00	MSFT	Stock	25.63	25.73	24.14	24.32	26118798.0
2008-10-14 10:00:00	MSFT	Stock	24.32	24.7	24.13	24.64	14816806.0
2008-10-14 10:30:00	MSFT	Stock	24.64	24.74	24.1	24.4	11510652.0
2008-10-14 11:00:00	MSFT	Stock	24.4	24.41	23.96	24.35	9813342.0
2008-10-14 11:30:00	MSFT	Stock	24.34	24.8	24.22	24.62	8111049.0
2008-10-14 12:00:00	MSFT	Stock	24.62	24.9	24.42	24.8	8090354.0
2008-10-14 12:30:00	MSFT	Stock	24.791	24.98	24.68	24.68	7649650.0
2008-10-14 13:00:00	MSFT	Stock	24.69	24.76	24.5	24.52	5659877.0
2008-10-14 13:30:00	MSFT	Stock	24.52	24.64	24.28	24.358	6258781.0
2008-10-14 14:00:00	MSFT	Stock	24.35	24.4	23.99	24.29	8230523.0

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

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