PREVIEW / stock_30min / 2010-02-03

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-02-03.parquet
  size:    1.3 MB
  rows:    72,270
  symbols: 3,423

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-02-03 04:00:00	AAPL	Stock	7.0011	7.0011	7.0011	7.0011	5600.0
2010-02-03 05:30:00	AAPL	Stock	6.9857	6.9857	6.9857	6.9857	2800.0
2010-02-03 06:30:00	AAPL	Stock	6.9946	6.9946	6.9946	6.9946	2800.0
2010-02-03 07:00:00	AAPL	Stock	6.9946	6.9946	6.9857	6.9929	22708.0
2010-02-03 07:30:00	AAPL	Stock	6.9857	6.9857	6.9789	6.9857	11480.0
2010-02-03 08:00:00	AAPL	Stock	6.9821	6.9821	6.9518	6.9589	1061116.0
2010-02-03 08:30:00	AAPL	Stock	6.9586	6.975	6.9507	6.9571	609532.0
2010-02-03 09:00:00	AAPL	Stock	6.9575	6.9721	6.9543	6.9714	1395968.0
2010-02-03 09:30:00	AAPL	Stock	6.9718	7.0829	6.9436	7.0596	98573216.0
2010-02-03 10:00:00	AAPL	Stock	7.0596	7.0893	7.0443	7.0607	67509652.0
2010-02-03 10:30:00	AAPL	Stock	7.06	7.0754	7.0225	7.0611	47114900.0
2010-02-03 11:00:00	AAPL	Stock	7.063	7.125	7.0571	7.1054	65675148.0
2010-02-03 11:30:00	AAPL	Stock	7.1064	7.1132	7.0768	7.0836	34707204.0
2010-02-03 12:00:00	AAPL	Stock	7.0836	7.1225	7.08	7.1039	30775388.0
2010-02-03 12:30:00	AAPL	Stock	7.1036	7.1389	7.1032	7.1125	33959380.0
2010-02-03 13:00:00	AAPL	Stock	7.1135	7.1407	7.1107	7.1324	26076456.0
2010-02-03 13:30:00	AAPL	Stock	7.1324	7.15	7.1254	7.1354	35625072.0
2010-02-03 14:00:00	AAPL	Stock	7.1339	7.1354	7.1068	7.1151	35108248.0
2010-02-03 14:30:00	AAPL	Stock	7.115	7.1368	7.11	7.1318	24738924.0
2010-02-03 15:00:00	AAPL	Stock	7.1299	7.145	7.1136	7.1154	38048500.0
2010-02-03 15:30:00	AAPL	Stock	7.1155	7.1386	7.1107	7.115	56138012.0
2010-02-03 16:00:00	AAPL	Stock	7.1154	7.13	7.0639	7.1223	7741468.0
2010-02-03 16:30:00	AAPL	Stock	7.1162	7.1304	7.1162	7.1264	645736.0
2010-02-03 17:00:00	AAPL	Stock	7.1286	7.1411	7.1264	7.1314	546392.0
2010-02-03 17:30:00	AAPL	Stock	7.1318	7.1393	7.1318	7.1371	215404.0
2010-02-03 18:00:00	AAPL	Stock	7.1404	7.1429	7.115	7.1393	364056.0
2010-02-03 18:30:00	AAPL	Stock	7.1386	7.1429	7.1375	7.1429	207032.0
2010-02-03 19:00:00	AAPL	Stock	7.1429	7.1464	7.1393	7.1436	108612.0
2010-02-03 19:30:00	AAPL	Stock	7.1436	7.1464	7.1429	7.1429	266140.0
2010-02-03 06:00:00	MSFT	Stock	28.49	28.49	28.49	28.49	200.0
2010-02-03 07:00:00	MSFT	Stock	28.43	28.43	28.43	28.43	300.0
2010-02-03 07:30:00	MSFT	Stock	28.45	28.45	28.45	28.45	1000.0
2010-02-03 08:00:00	MSFT	Stock	28.48	28.48	28.36	28.38	17749.0
2010-02-03 08:30:00	MSFT	Stock	28.38	28.4	28.36	28.4	34570.0
2010-02-03 09:00:00	MSFT	Stock	28.4	28.49	28.26	28.26	52740.0
2010-02-03 09:30:00	MSFT	Stock	28.26	28.375	28.2	28.32	5066633.0
2010-02-03 10:00:00	MSFT	Stock	28.31	28.31	28.14	28.14	4800464.0
2010-02-03 10:30:00	MSFT	Stock	28.14	28.26	28.12	28.2	3568347.0
2010-02-03 11:00:00	MSFT	Stock	28.2	28.36	28.16	28.33	3978832.0
2010-02-03 11:30:00	MSFT	Stock	28.333	28.4	28.28	28.35	4843412.0
2010-02-03 12:00:00	MSFT	Stock	28.35	28.5	28.34	28.45	4141714.0
2010-02-03 12:30:00	MSFT	Stock	28.455	28.63	28.45	28.59	4106043.0
2010-02-03 13:00:00	MSFT	Stock	28.59	28.61	28.52	28.586	3639294.0
2010-02-03 13:30:00	MSFT	Stock	28.58	28.71	28.58	28.69	4725157.0
2010-02-03 14:00:00	MSFT	Stock	28.7	28.73	28.63	28.67	3191364.0
2010-02-03 14:30:00	MSFT	Stock	28.67	28.7	28.63	28.69	2356204.0
2010-02-03 15:00:00	MSFT	Stock	28.69	28.78	28.69	28.745	5038181.0
2010-02-03 15:30:00	MSFT	Stock	28.745	28.79	28.6	28.63	9699611.0
2010-02-03 16:00:00	MSFT	Stock	28.63	28.73	28.48	28.72	1193238.0
2010-02-03 16:30:00	MSFT	Stock	28.736	28.82	28.497	28.82	108344.0

> showing 50 of 72,270 rows — these rows as CSV

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