PREVIEW / stock_30min / 2008-03-19

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-03-19.parquet
  size:    1.2 MB
  rows:    69,138
  symbols: 3,281

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-03-19 04:00:00	AAPL	Stock	4.7389	4.7389	4.7389	4.7389	2800.0
2008-03-19 05:30:00	AAPL	Stock	4.6875	4.6875	4.6875	4.6875	2800.0
2008-03-19 06:00:00	AAPL	Stock	4.6875	4.6875	4.6875	4.6875	5600.0
2008-03-19 06:30:00	AAPL	Stock	4.6875	4.7089	4.6782	4.6975	42000.0
2008-03-19 07:00:00	AAPL	Stock	4.7018	4.7107	4.6932	4.7057	154840.0
2008-03-19 07:30:00	AAPL	Stock	4.7161	4.725	4.7057	4.7139	461300.0
2008-03-19 08:00:00	AAPL	Stock	4.7196	4.7229	4.7079	4.7164	1195796.0
2008-03-19 08:30:00	AAPL	Stock	4.7179	4.7404	4.7179	4.7321	1700216.0
2008-03-19 09:00:00	AAPL	Stock	4.7314	4.7664	4.7311	4.75	4577748.0
2008-03-19 09:30:00	AAPL	Stock	4.75	4.7961	4.7232	4.725	148479184.0
2008-03-19 10:00:00	AAPL	Stock	4.7246	4.7586	4.7193	4.7346	91795844.0
2008-03-19 10:30:00	AAPL	Stock	4.7332	4.7371	4.6772	4.7068	92925280.0
2008-03-19 11:00:00	AAPL	Stock	4.7071	4.7321	4.6968	4.7143	61486152.0
2008-03-19 11:30:00	AAPL	Stock	4.7161	4.735	4.6821	4.7	55187664.0
2008-03-19 12:00:00	AAPL	Stock	4.7002	4.725	4.6961	4.7071	45049508.0
2008-03-19 12:30:00	AAPL	Stock	4.7079	4.7211	4.6821	4.6961	51732072.0
2008-03-19 13:00:00	AAPL	Stock	4.6971	4.7161	4.68	4.7046	42807240.0
2008-03-19 13:30:00	AAPL	Stock	4.7036	4.7114	4.6646	4.6754	64206520.0
2008-03-19 14:00:00	AAPL	Stock	4.6739	4.7011	4.6671	4.6936	51819684.0
2008-03-19 14:30:00	AAPL	Stock	4.6939	4.6979	4.6439	4.6664	72811900.0
2008-03-19 15:00:00	AAPL	Stock	4.6668	4.7143	4.6564	4.6836	83870360.0
2008-03-19 15:30:00	AAPL	Stock	4.6836	4.6914	4.6311	4.6357	90913816.0
2008-03-19 16:00:00	AAPL	Stock	4.6354	4.7164	4.6307	4.6411	29296792.0
2008-03-19 16:30:00	AAPL	Stock	4.6411	4.6411	4.6274	4.6382	396508.0
2008-03-19 17:00:00	AAPL	Stock	4.6311	4.6375	4.6289	4.6304	259644.0
2008-03-19 17:30:00	AAPL	Stock	4.6304	4.6321	4.6286	4.6321	74312.0
2008-03-19 18:00:00	AAPL	Stock	4.6321	4.6343	4.6293	4.6329	47684.0
2008-03-19 18:30:00	AAPL	Stock	4.635	4.635	4.6286	4.6286	34748.0
2008-03-19 19:00:00	AAPL	Stock	4.6318	4.635	4.6239	4.625	245784.0
2008-03-19 19:30:00	AAPL	Stock	4.625	4.625	4.6182	4.6225	66304.0
2008-03-19 08:00:00	MSFT	Stock	29.3	29.42	29.2	29.21	6783.0
2008-03-19 08:30:00	MSFT	Stock	29.25	29.34	29.25	29.3	6148.0
2008-03-19 09:00:00	MSFT	Stock	29.34	29.62	29.34	29.47	186703.0
2008-03-19 09:30:00	MSFT	Stock	29.38	29.49	29.2	29.37	6364103.0
2008-03-19 10:00:00	MSFT	Stock	29.38	29.43	29.24	29.29	4501284.0
2008-03-19 10:30:00	MSFT	Stock	29.282	29.29	29.11	29.2	4154527.0
2008-03-19 11:00:00	MSFT	Stock	29.2	29.5	29.17	29.48	4741272.0
2008-03-19 11:30:00	MSFT	Stock	29.47	29.59	29.4	29.45	4037359.0
2008-03-19 12:00:00	MSFT	Stock	29.45	29.49	29.28	29.31	3207464.0
2008-03-19 12:30:00	MSFT	Stock	29.31	29.34	29.16	29.21	2506527.0
2008-03-19 13:00:00	MSFT	Stock	29.22	29.31	29.13	29.19	3817952.0
2008-03-19 13:30:00	MSFT	Stock	29.18	29.27	29.092	29.12	2789468.0
2008-03-19 14:00:00	MSFT	Stock	29.12	29.19	29.0	29.13	3967219.0
2008-03-19 14:30:00	MSFT	Stock	29.14	29.16	28.93	29.13	3811814.0
2008-03-19 15:00:00	MSFT	Stock	29.14	29.21	28.88	28.93	3990501.0
2008-03-19 15:30:00	MSFT	Stock	28.93	29.06	28.62	28.62	8733544.0
2008-03-19 16:00:00	MSFT	Stock	28.62	29.41	28.62	28.74	2523032.0
2008-03-19 16:30:00	MSFT	Stock	28.65	29.123	28.597	28.597	86356.0
2008-03-19 17:00:00	MSFT	Stock	28.62	29.179	28.62	28.75	8772.0
2008-03-19 17:30:00	MSFT	Stock	28.72	28.73	28.66	28.73	627.0

> showing 50 of 69,138 rows — these rows as CSV

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