PREVIEW / stock_30min / 2007-03-27

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-03-27.parquet
  size:    1.0 MB
  rows:    55,497
  symbols: 2,556

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-03-27 06:00:00	AAPL	Stock	3.4107	3.4107	3.4107	3.4107	2800.0
2007-03-27 07:00:00	AAPL	Stock	3.4214	3.4321	3.4196	3.4321	243320.0
2007-03-27 07:30:00	AAPL	Stock	3.4286	3.4286	3.4243	3.4243	558320.0
2007-03-27 08:00:00	AAPL	Stock	3.4268	3.4268	3.4179	3.42	731808.0
2007-03-27 08:30:00	AAPL	Stock	3.4214	3.4232	3.4186	3.4214	698404.0
2007-03-27 09:00:00	AAPL	Stock	3.4218	3.4259	3.415	3.4182	1305332.0
2007-03-27 09:30:00	AAPL	Stock	3.4182	3.4232	3.3986	3.4057	96175380.0
2007-03-27 10:00:00	AAPL	Stock	3.4054	3.4179	3.3929	3.4046	72174564.0
2007-03-27 10:30:00	AAPL	Stock	3.4043	3.4196	3.4	3.4189	57379420.0
2007-03-27 11:00:00	AAPL	Stock	3.4189	3.4279	3.4129	3.4275	68046188.0
2007-03-27 11:30:00	AAPL	Stock	3.4275	3.4368	3.4193	3.435	76179936.0
2007-03-27 12:00:00	AAPL	Stock	3.435	3.4386	3.4236	3.4361	43448356.0
2007-03-27 12:30:00	AAPL	Stock	3.4364	3.4454	3.4336	3.4436	41529040.0
2007-03-27 13:00:00	AAPL	Stock	3.4432	3.4582	3.4429	3.4536	73544352.0
2007-03-27 13:30:00	AAPL	Stock	3.4536	3.4564	3.445	3.4471	59035088.0
2007-03-27 14:00:00	AAPL	Stock	3.4471	3.4536	3.4036	3.4136	100803416.0
2007-03-27 14:30:00	AAPL	Stock	3.4136	3.4214	3.4018	3.4168	89631724.0
2007-03-27 15:00:00	AAPL	Stock	3.4164	3.4275	3.4139	3.4204	63245140.0
2007-03-27 15:30:00	AAPL	Stock	3.4204	3.4275	3.4071	3.4086	68104596.0
2007-03-27 16:00:00	AAPL	Stock	3.4082	3.4179	3.3929	3.4039	4519088.0
2007-03-27 16:30:00	AAPL	Stock	3.4096	3.4096	3.4	3.4029	1857380.0
2007-03-27 17:00:00	AAPL	Stock	3.3986	3.3986	3.3925	3.3957	1125460.0
2007-03-27 17:30:00	AAPL	Stock	3.3996	3.4096	3.3961	3.4011	7002800.0
2007-03-27 18:00:00	AAPL	Stock	3.4032	3.4043	3.4	3.4043	476980.0
2007-03-27 18:30:00	AAPL	Stock	3.4	3.4036	3.4	3.4036	23660.0
2007-03-27 19:00:00	AAPL	Stock	3.4004	3.4004	3.3964	3.3982	120400.0
2007-03-27 19:30:00	AAPL	Stock	3.3982	3.3993	3.3932	3.3993	209048.0
2007-03-27 08:00:00	MSFT	Stock	28.19	28.19	28.19	28.19	3795.0
2007-03-27 08:30:00	MSFT	Stock	28.18	28.18	28.12	28.17	1400.0
2007-03-27 09:00:00	MSFT	Stock	28.15	28.17	27.99	28.05	70218.0
2007-03-27 09:30:00	MSFT	Stock	28.04	28.16	27.97	28.0	5273743.0
2007-03-27 10:00:00	MSFT	Stock	27.99	28.1	27.85	27.9	4540369.0
2007-03-27 10:30:00	MSFT	Stock	27.9	28.06	27.86	28.04	3551123.0
2007-03-27 11:00:00	MSFT	Stock	28.03	28.04	27.91	27.94	2359135.0
2007-03-27 11:30:00	MSFT	Stock	27.93	27.94	27.89	27.9	2605092.0
2007-03-27 12:00:00	MSFT	Stock	27.9	27.92	27.86	27.87	3973638.0
2007-03-27 12:30:00	MSFT	Stock	27.87	27.9	27.86	27.865	2203016.0
2007-03-27 13:00:00	MSFT	Stock	27.862	27.9	27.83	27.832	2865224.0
2007-03-27 13:30:00	MSFT	Stock	27.83	27.84	27.73	27.75	5722262.0
2007-03-27 14:00:00	MSFT	Stock	27.74	27.77	27.65	27.74	4932604.0
2007-03-27 14:30:00	MSFT	Stock	27.74	27.86	27.73	27.83	3393346.0
2007-03-27 15:00:00	MSFT	Stock	27.83	27.88	27.79	27.82	3396548.0
2007-03-27 15:30:00	MSFT	Stock	27.82	27.9	27.72	27.76	10554705.0
2007-03-27 16:00:00	MSFT	Stock	27.73	28.04	27.69	27.74	1084108.0
2007-03-27 16:30:00	MSFT	Stock	27.72	27.74	27.65	27.65	766150.0
2007-03-27 17:00:00	MSFT	Stock	27.7	27.72	27.64	27.64	14796.0
2007-03-27 17:30:00	MSFT	Stock	27.7	27.7	27.64	27.68	3700.0
2007-03-27 18:00:00	MSFT	Stock	27.7	27.71	27.7	27.7	1800.0
2007-03-27 19:00:00	MSFT	Stock	27.7	27.7	27.66	27.66	1000.0
2007-03-27 19:30:00	MSFT	Stock	27.72	27.72	27.72	27.72	500.0

> showing 50 of 55,497 rows — these rows as CSV

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