PREVIEW / stock_30min / 2010-12-28

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-12-28.parquet
  size:    1.4 MB
  rows:    74,263
  symbols: 3,525

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
2010-12-28 04:00:00	AAPL	Stock	11.6686	11.6686	11.6686	11.6686	2800.0
2010-12-28 06:30:00	AAPL	Stock	11.6964	11.6982	11.67	11.67	28000.0
2010-12-28 07:00:00	AAPL	Stock	11.6579	11.6782	11.6571	11.6782	42000.0
2010-12-28 07:30:00	AAPL	Stock	11.6746	11.6757	11.6511	11.6511	109200.0
2010-12-28 08:00:00	AAPL	Stock	11.65	11.6539	11.6189	11.6304	909832.0
2010-12-28 08:30:00	AAPL	Stock	11.6357	11.6464	11.6311	11.6436	783440.0
2010-12-28 09:00:00	AAPL	Stock	11.6432	11.6571	11.6357	11.6414	1147944.0
2010-12-28 09:30:00	AAPL	Stock	11.6396	11.6664	11.6118	11.6371	38607800.0
2010-12-28 10:00:00	AAPL	Stock	11.6371	11.6482	11.6093	11.6364	23524564.0
2010-12-28 10:30:00	AAPL	Stock	11.6364	11.6414	11.6279	11.6354	11335044.0
2010-12-28 11:00:00	AAPL	Stock	11.6346	11.65	11.6329	11.6357	13719160.0
2010-12-28 11:30:00	AAPL	Stock	11.6361	11.6446	11.6218	11.6229	10235848.0
2010-12-28 12:00:00	AAPL	Stock	11.6236	11.6311	11.6107	11.6218	8301160.0
2010-12-28 12:30:00	AAPL	Stock	11.6221	11.6286	11.6186	11.6225	5148332.0
2010-12-28 13:00:00	AAPL	Stock	11.6225	11.6257	11.6114	11.6121	5473524.0
2010-12-28 13:30:00	AAPL	Stock	11.6129	11.6264	11.6114	11.6239	5740168.0
2010-12-28 14:00:00	AAPL	Stock	11.6239	11.6296	11.6179	11.6261	5821760.0
2010-12-28 14:30:00	AAPL	Stock	11.6257	11.6286	11.6186	11.6279	7691404.0
2010-12-28 15:00:00	AAPL	Stock	11.6279	11.635	11.625	11.6304	8632204.0
2010-12-28 15:30:00	AAPL	Stock	11.6307	11.6321	11.6125	11.6239	18771704.0
2010-12-28 16:00:00	AAPL	Stock	11.6239	11.6339	11.6204	11.6236	8483076.0
2010-12-28 16:30:00	AAPL	Stock	11.6214	11.6313	11.6211	11.6218	62440.0
2010-12-28 17:00:00	AAPL	Stock	11.6239	11.6304	11.6221	11.6304	75376.0
2010-12-28 18:00:00	AAPL	Stock	11.6282	11.6307	11.6239	11.6307	147476.0
2010-12-28 18:30:00	AAPL	Stock	11.6314	11.6314	11.6307	11.6307	30520.0
2010-12-28 19:00:00	AAPL	Stock	11.6271	11.6275	11.6271	11.6275	39480.0
2010-12-28 19:30:00	AAPL	Stock	11.6304	11.6321	11.6264	11.6321	112280.0
2010-12-28 04:30:00	MSFT	Stock	28.14	28.14	28.14	28.14	100.0
2010-12-28 06:00:00	MSFT	Stock	28.14	28.14	28.14	28.14	1000.0
2010-12-28 06:30:00	MSFT	Stock	28.23	28.23	28.23	28.23	300.0
2010-12-28 07:30:00	MSFT	Stock	28.13	28.13	28.13	28.13	550.0
2010-12-28 08:00:00	MSFT	Stock	28.14	28.15	28.1	28.1	3220.0
2010-12-28 08:30:00	MSFT	Stock	28.09	28.15	28.08	28.15	2995.0
2010-12-28 09:00:00	MSFT	Stock	28.13	28.18	27.98	27.98	110307.0
2010-12-28 09:30:00	MSFT	Stock	27.98	28.17	27.96	28.07	2992380.0
2010-12-28 10:00:00	MSFT	Stock	28.05	28.16	28.02	28.13	2164004.0
2010-12-28 10:30:00	MSFT	Stock	28.13	28.14	28.09	28.11	1259925.0
2010-12-28 11:00:00	MSFT	Stock	28.11	28.15	28.1	28.115	631113.0
2010-12-28 11:30:00	MSFT	Stock	28.119	28.13	28.01	28.06	1841370.0
2010-12-28 12:00:00	MSFT	Stock	28.06	28.069	28.03	28.04	902593.0
2010-12-28 12:30:00	MSFT	Stock	28.05	28.08	28.04	28.056	931587.0
2010-12-28 13:00:00	MSFT	Stock	28.051	28.06	28.01	28.021	1047343.0
2010-12-28 13:30:00	MSFT	Stock	28.02	28.05	28.0	28.05	1456587.0
2010-12-28 14:00:00	MSFT	Stock	28.05	28.05	28.005	28.01	1174947.0
2010-12-28 14:30:00	MSFT	Stock	28.011	28.08	27.99	28.071	1487343.0
2010-12-28 15:00:00	MSFT	Stock	28.079	28.11	28.04	28.07	1502496.0
2010-12-28 15:30:00	MSFT	Stock	28.07	28.08	28.01	28.02	2774375.0
2010-12-28 16:00:00	MSFT	Stock	28.02	28.054	28.01	28.04	1905565.0
2010-12-28 16:30:00	MSFT	Stock	28.05	28.07	28.04	28.07	9920.0
2010-12-28 17:30:00	MSFT	Stock	28.05	28.05	28.05	28.05	500.0

> showing 50 of 74,263 rows — these rows as CSV

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