PREVIEW / stock_30min / 2006-04-20

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-04-20.parquet
  size:    895 KB
  rows:    48,131
  symbols: 2,241

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
2006-04-20 04:00:00	AAPL	Stock	2.4482	2.4482	2.37	2.37	16800.0
2006-04-20 05:30:00	AAPL	Stock	2.4464	2.4464	2.4464	2.4464	2800.0
2006-04-20 06:00:00	AAPL	Stock	2.4625	2.4643	2.4621	2.4643	134400.0
2006-04-20 06:30:00	AAPL	Stock	2.4468	2.4468	2.4468	2.4468	2800.0
2006-04-20 07:00:00	AAPL	Stock	2.4518	2.4643	2.4518	2.4593	285600.0
2006-04-20 07:30:00	AAPL	Stock	2.4575	2.4575	2.4246	2.4518	542612.0
2006-04-20 08:00:00	AAPL	Stock	2.4504	2.4929	2.4482	2.4882	20792520.0
2006-04-20 08:30:00	AAPL	Stock	2.4875	2.4929	2.4757	2.4811	19486152.0
2006-04-20 09:00:00	AAPL	Stock	2.4804	2.4843	2.4732	2.4818	23816352.0
2006-04-20 09:30:00	AAPL	Stock	2.4825	2.5	2.4554	2.4736	300306776.0
2006-04-20 10:00:00	AAPL	Stock	2.4736	2.4843	2.4475	2.46	172654888.0
2006-04-20 10:30:00	AAPL	Stock	2.46	2.4604	2.4204	2.4346	189258552.0
2006-04-20 11:00:00	AAPL	Stock	2.4346	2.4479	2.4296	2.445	84821380.0
2006-04-20 11:30:00	AAPL	Stock	2.4454	2.4479	2.4161	2.4232	74743872.0
2006-04-20 12:00:00	AAPL	Stock	2.4232	2.4821	2.4193	2.4293	61251064.0
2006-04-20 12:30:00	AAPL	Stock	2.4293	2.4329	2.4254	2.4296	34735176.0
2006-04-20 13:00:00	AAPL	Stock	2.4296	2.4304	2.415	2.4154	44964836.0
2006-04-20 13:30:00	AAPL	Stock	2.415	2.4755	2.3954	2.3975	76300952.0
2006-04-20 14:00:00	AAPL	Stock	2.3975	2.4018	2.3643	2.3839	164859268.0
2006-04-20 14:30:00	AAPL	Stock	2.3839	2.4157	2.3779	2.4043	124027484.0
2006-04-20 15:00:00	AAPL	Stock	2.4043	2.4557	2.4014	2.4282	80302852.0
2006-04-20 15:30:00	AAPL	Stock	2.4282	2.4389	2.4079	2.4154	122326036.0
2006-04-20 16:00:00	AAPL	Stock	2.4132	2.4179	2.4086	2.4118	1726788.0
2006-04-20 16:30:00	AAPL	Stock	2.4136	2.4264	2.4107	2.4143	21330232.0
2006-04-20 17:00:00	AAPL	Stock	2.4143	2.4182	2.4129	2.4171	689976.0
2006-04-20 17:30:00	AAPL	Stock	2.4175	2.4193	2.4161	2.4182	702940.0
2006-04-20 18:00:00	AAPL	Stock	2.4179	2.4214	2.4171	2.4211	391804.0
2006-04-20 06:30:00	MSFT	Stock	27.08	27.08	26.99	26.99	1000.0
2006-04-20 07:30:00	MSFT	Stock	27.03	27.03	27.03	27.03	150.0
2006-04-20 08:00:00	MSFT	Stock	27.06	27.1	27.06	27.1	12820.0
2006-04-20 08:30:00	MSFT	Stock	27.1	27.1	27.1	27.1	2600.0
2006-04-20 09:00:00	MSFT	Stock	27.08	27.08	27.03	27.05	44372.0
2006-04-20 09:30:00	MSFT	Stock	27.05	27.06	26.7	26.96	3896547.0
2006-04-20 10:00:00	MSFT	Stock	26.96	27.13	26.94	27.1	7328893.0
2006-04-20 10:30:00	MSFT	Stock	27.102	27.19	27.07	27.09	4886705.0
2006-04-20 11:00:00	MSFT	Stock	27.09	27.11	26.97	27.02	3269626.0
2006-04-20 11:30:00	MSFT	Stock	27.02	27.05	26.99	27.03	3188401.0
2006-04-20 12:00:00	MSFT	Stock	27.03	27.055	26.94	26.95	3460347.0
2006-04-20 12:30:00	MSFT	Stock	26.96	27.05	26.94	27.05	3091672.0
2006-04-20 13:00:00	MSFT	Stock	27.05	27.07	27.03	27.06	2131082.0
2006-04-20 13:30:00	MSFT	Stock	27.05	27.09	27.05	27.08	1472890.0
2006-04-20 14:00:00	MSFT	Stock	27.078	27.1	27.04	27.09	1623890.0
2006-04-20 14:30:00	MSFT	Stock	27.1	27.11	27.06	27.06	1729902.0
2006-04-20 15:00:00	MSFT	Stock	27.061	27.08	27.05	27.07	1271907.0
2006-04-20 15:30:00	MSFT	Stock	27.06	27.07	27.0	27.07	4803564.0
2006-04-20 16:00:00	MSFT	Stock	27.04	27.05	27.01	27.03	1780480.0
2006-04-20 16:30:00	MSFT	Stock	27.03	27.03	27.02	27.02	4348.0
2006-04-20 17:00:00	MSFT	Stock	27.03	27.03	27.03	27.03	800.0
2006-04-20 17:30:00	MSFT	Stock	27.05	27.05	27.02	27.02	304703.0
2006-04-20 18:00:00	MSFT	Stock	27.01	27.03	27.01	27.02	20196.0

> showing 50 of 48,131 rows — these rows as CSV

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