PREVIEW / stock_30min / 2008-04-16

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-04-16.parquet
  size:    1.2 MB
  rows:    68,430
  symbols: 3,294

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-04-16 07:00:00	AAPL	Stock	5.3725	5.4107	5.3718	5.4107	364000.0
2008-04-16 07:30:00	AAPL	Stock	5.4107	5.4143	5.3964	5.4036	625268.0
2008-04-16 08:00:00	AAPL	Stock	5.4	5.4214	5.3864	5.4071	2517256.0
2008-04-16 08:30:00	AAPL	Stock	5.4071	5.4339	5.4025	5.4246	3749088.0
2008-04-16 09:00:00	AAPL	Stock	5.4229	5.4264	5.2993	5.4189	4886112.0
2008-04-16 09:30:00	AAPL	Stock	5.4189	5.4286	5.3793	5.3996	124642112.0
2008-04-16 10:00:00	AAPL	Stock	5.399	5.4557	5.3986	5.4515	87123064.0
2008-04-16 10:30:00	AAPL	Stock	5.4514	5.4639	5.4361	5.4589	66288572.0
2008-04-16 11:00:00	AAPL	Stock	5.4586	5.4669	5.4446	5.4593	50661968.0
2008-04-16 11:30:00	AAPL	Stock	5.4589	5.4729	5.4439	5.4557	48890408.0
2008-04-16 12:00:00	AAPL	Stock	5.4561	5.4896	5.4532	5.4814	41500256.0
2008-04-16 12:30:00	AAPL	Stock	5.4811	5.4875	5.4589	5.4782	37009532.0
2008-04-16 13:00:00	AAPL	Stock	5.4789	5.4854	5.4593	5.4793	33052460.0
2008-04-16 13:30:00	AAPL	Stock	5.4804	5.4818	5.4554	5.4629	30552928.0
2008-04-16 14:00:00	AAPL	Stock	5.4629	5.4771	5.4554	5.4704	39502316.0
2008-04-16 14:30:00	AAPL	Stock	5.4704	5.4911	5.4589	5.4836	46169144.0
2008-04-16 15:00:00	AAPL	Stock	5.4829	5.5	5.4825	5.4925	51822148.0
2008-04-16 15:30:00	AAPL	Stock	5.4925	5.5036	5.4821	5.4871	82708164.0
2008-04-16 16:00:00	AAPL	Stock	5.4861	5.5779	5.4518	5.5718	24044692.0
2008-04-16 16:30:00	AAPL	Stock	5.5718	5.5768	5.47	5.56	2424464.0
2008-04-16 17:00:00	AAPL	Stock	5.5557	5.5643	5.4328	5.4915	1416548.0
2008-04-16 17:30:00	AAPL	Stock	5.5518	5.5564	5.5357	5.5357	432264.0
2008-04-16 18:00:00	AAPL	Stock	5.5393	5.5436	5.5321	5.5429	179816.0
2008-04-16 18:30:00	AAPL	Stock	5.5436	5.5454	5.5393	5.5411	111916.0
2008-04-16 19:00:00	AAPL	Stock	5.5411	5.5446	5.5411	5.5411	128072.0
2008-04-16 19:30:00	AAPL	Stock	5.5411	5.5479	5.5364	5.5382	183456.0
2008-04-16 05:30:00	MSFT	Stock	28.6	29.0	27.0	27.0	650.0
2008-04-16 08:00:00	MSFT	Stock	28.4	28.59	28.4	28.59	3004.0
2008-04-16 08:30:00	MSFT	Stock	28.55	28.63	28.55	28.63	31590.0
2008-04-16 09:00:00	MSFT	Stock	28.62	28.63	28.5	28.53	303970.0
2008-04-16 09:30:00	MSFT	Stock	28.54	28.66	28.38	28.418	4478631.0
2008-04-16 10:00:00	MSFT	Stock	28.41	28.72	28.38	28.671	4426399.0
2008-04-16 10:30:00	MSFT	Stock	28.68	28.79	28.64	28.75	4412313.0
2008-04-16 11:00:00	MSFT	Stock	28.75	28.81	28.64	28.68	2920829.0
2008-04-16 11:30:00	MSFT	Stock	28.68	28.8	28.66	28.7	2938894.0
2008-04-16 12:00:00	MSFT	Stock	28.7	28.8	28.685	28.78	5609983.0
2008-04-16 12:30:00	MSFT	Stock	28.79	28.81	28.72	28.79	1733914.0
2008-04-16 13:00:00	MSFT	Stock	28.79	28.8	28.58	28.69	3435724.0
2008-04-16 13:30:00	MSFT	Stock	28.7	28.73	28.61	28.69	2127857.0
2008-04-16 14:00:00	MSFT	Stock	28.69	28.79	28.64	28.76	2557438.0
2008-04-16 14:30:00	MSFT	Stock	28.77	28.82	28.67	28.782	2354221.0
2008-04-16 15:00:00	MSFT	Stock	28.78	28.98	28.78	28.948	4460007.0
2008-04-16 15:30:00	MSFT	Stock	28.95	29.05	28.92	28.93	7945302.0
2008-04-16 16:00:00	MSFT	Stock	28.93	29.22	28.67	29.2	3332391.0
2008-04-16 16:30:00	MSFT	Stock	29.22	29.22	28.99	29.1	33801.0
2008-04-16 17:00:00	MSFT	Stock	28.99	29.24	28.99	29.18	59476.0
2008-04-16 17:30:00	MSFT	Stock	29.16	29.18	29.15	29.18	9650.0
2008-04-16 18:00:00	MSFT	Stock	29.18	29.2	29.18	29.18	7150.0
2008-04-16 18:30:00	MSFT	Stock	29.17	29.17	29.15	29.15	2791.0
2008-04-16 19:00:00	MSFT	Stock	29.15	29.22	29.15	29.22	10054.0

> showing 50 of 68,430 rows — these rows as CSV

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