PREVIEW / stock_30min / 2007-01-11

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-01-11.parquet
  size:    983 KB
  rows:    52,795
  symbols: 2,503

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-11 04:00:00	AAPL	Stock	3.44	3.4475	3.44	3.4475	22400.0
2007-01-11 06:30:00	AAPL	Stock	3.4468	3.4468	3.4464	3.4464	11200.0
2007-01-11 07:00:00	AAPL	Stock	3.4496	3.4589	3.4464	3.4471	618380.0
2007-01-11 07:30:00	AAPL	Stock	3.4471	3.4536	3.4393	3.4393	744660.0
2007-01-11 08:00:00	AAPL	Stock	3.4425	3.4425	3.425	3.4296	9208556.0
2007-01-11 08:30:00	AAPL	Stock	3.4289	3.44	3.4286	3.4382	5402124.0
2007-01-11 09:00:00	AAPL	Stock	3.4389	3.4389	3.4186	3.4286	11846464.0
2007-01-11 09:30:00	AAPL	Stock	3.4264	3.4511	3.3968	3.4032	265627124.0
2007-01-11 10:00:00	AAPL	Stock	3.4032	3.4271	3.3964	3.4139	142009308.0
2007-01-11 10:30:00	AAPL	Stock	3.4139	3.4432	3.4104	3.4429	129901296.0
2007-01-11 11:00:00	AAPL	Stock	3.4436	3.4564	3.4371	3.4421	144228616.0
2007-01-11 11:30:00	AAPL	Stock	3.4418	3.4418	3.4289	3.4325	67868780.0
2007-01-11 12:00:00	AAPL	Stock	3.4332	3.4343	3.4118	3.4189	79070404.0
2007-01-11 12:30:00	AAPL	Stock	3.4193	3.4393	3.4182	3.4364	56747544.0
2007-01-11 13:00:00	AAPL	Stock	3.4364	3.4411	3.4257	3.4375	73482332.0
2007-01-11 13:30:00	AAPL	Stock	3.4375	3.4489	3.4354	3.4361	84214676.0
2007-01-11 14:00:00	AAPL	Stock	3.4357	3.4375	3.4214	3.4232	104112344.0
2007-01-11 14:30:00	AAPL	Stock	3.4232	3.4561	3.4129	3.4296	88660824.0
2007-01-11 15:00:00	AAPL	Stock	3.4293	3.4386	3.4154	3.4246	70565656.0
2007-01-11 15:30:00	AAPL	Stock	3.425	3.4286	3.4121	3.4236	85850492.0
2007-01-11 16:00:00	AAPL	Stock	3.4229	3.4246	3.4196	3.42	1811740.0
2007-01-11 16:30:00	AAPL	Stock	3.4214	3.4214	3.4196	3.4211	320096.0
2007-01-11 17:00:00	AAPL	Stock	3.4211	3.4229	3.4196	3.4214	490336.0
2007-01-11 17:30:00	AAPL	Stock	3.4214	3.4225	3.4214	3.4221	159040.0
2007-01-11 18:00:00	AAPL	Stock	3.4214	3.4214	3.4168	3.4182	401100.0
2007-01-11 18:30:00	AAPL	Stock	3.4179	3.4214	3.4111	3.4111	496832.0
2007-01-11 19:00:00	AAPL	Stock	3.4111	3.4125	3.4089	3.4107	306936.0
2007-01-11 19:30:00	AAPL	Stock	3.4139	3.4139	3.4061	3.4089	658476.0
2007-01-11 08:00:00	MSFT	Stock	29.67	29.7	29.66	29.7	4750.0
2007-01-11 08:30:00	MSFT	Stock	29.7	29.7	29.65	29.7	11871.0
2007-01-11 09:00:00	MSFT	Stock	29.7	29.8	29.66	29.77	63343.0
2007-01-11 09:30:00	MSFT	Stock	29.76	29.79	29.65	29.761	4318335.0
2007-01-11 10:00:00	MSFT	Stock	29.76	29.88	29.74	29.86	3324932.0
2007-01-11 10:30:00	MSFT	Stock	29.86	29.98	29.81	29.971	4379958.0
2007-01-11 11:00:00	MSFT	Stock	29.972	30.23	29.97	30.161	9967100.0
2007-01-11 11:30:00	MSFT	Stock	30.16	30.2	30.12	30.151	3482425.0
2007-01-11 12:00:00	MSFT	Stock	30.153	30.37	30.15	30.36	9017768.0
2007-01-11 12:30:00	MSFT	Stock	30.35	30.49	30.33	30.48	6282603.0
2007-01-11 13:00:00	MSFT	Stock	30.48	30.49	30.29	30.36	5875433.0
2007-01-11 13:30:00	MSFT	Stock	30.353	30.37	30.28	30.31	3655077.0
2007-01-11 14:00:00	MSFT	Stock	30.31	30.36	30.26	30.341	4545805.0
2007-01-11 14:30:00	MSFT	Stock	30.34	30.5	30.33	30.5	6710128.0
2007-01-11 15:00:00	MSFT	Stock	30.49	30.7	30.37	30.5	17663290.0
2007-01-11 15:30:00	MSFT	Stock	30.52	30.75	30.49	30.69	16798152.0
2007-01-11 16:00:00	MSFT	Stock	30.69	30.78	30.6	30.77	1430617.0
2007-01-11 16:30:00	MSFT	Stock	30.74	30.78	30.69	30.77	97237.0
2007-01-11 17:00:00	MSFT	Stock	30.76	30.77	30.75	30.77	2632.0
2007-01-11 17:30:00	MSFT	Stock	30.75	30.78	30.75	30.78	7538.0
2007-01-11 18:00:00	MSFT	Stock	30.75	30.79	30.7	30.7	12415.0
2007-01-11 18:30:00	MSFT	Stock	30.75	30.75	30.75	30.75	100.0

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

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