PREVIEW / stock_30min / 2010-03-15

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-15.parquet
  size:    1.3 MB
  rows:    72,795
  symbols: 3,465

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-03-15 05:00:00	AAPL	Stock	8.085	8.085	8.085	8.085	2800.0
2010-03-15 07:00:00	AAPL	Stock	8.0714	8.0714	8.0714	8.0714	5600.0
2010-03-15 07:30:00	AAPL	Stock	8.0714	8.0732	8.0679	8.0686	66584.0
2010-03-15 08:00:00	AAPL	Stock	8.0679	8.0682	8.0507	8.0507	565628.0
2010-03-15 08:30:00	AAPL	Stock	8.05	8.0539	8.0204	8.0461	1315440.0
2010-03-15 09:00:00	AAPL	Stock	8.0379	8.0532	8.0379	8.0468	339556.0
2010-03-15 09:30:00	AAPL	Stock	8.0493	8.0536	7.9768	7.9796	70845544.0
2010-03-15 10:00:00	AAPL	Stock	7.9804	7.9907	7.94	7.9834	58883384.0
2010-03-15 10:30:00	AAPL	Stock	7.9832	8.0015	7.9121	7.9286	43779316.0
2010-03-15 11:00:00	AAPL	Stock	7.9286	7.9439	7.8661	7.9007	64767388.0
2010-03-15 11:30:00	AAPL	Stock	7.9007	7.9286	7.8932	7.9214	29022000.0
2010-03-15 12:00:00	AAPL	Stock	7.9207	7.9396	7.9068	7.9316	23519888.0
2010-03-15 12:30:00	AAPL	Stock	7.9325	7.9493	7.9218	7.9314	25076576.0
2010-03-15 13:00:00	AAPL	Stock	7.9304	7.9354	7.9171	7.9218	13911240.0
2010-03-15 13:30:00	AAPL	Stock	7.9221	7.9357	7.9218	7.9309	10503808.0
2010-03-15 14:00:00	AAPL	Stock	7.9307	7.9329	7.9204	7.9261	13800864.0
2010-03-15 14:30:00	AAPL	Stock	7.9261	7.9557	7.9125	7.9471	27939352.0
2010-03-15 15:00:00	AAPL	Stock	7.9475	7.9725	7.9414	7.9721	33623576.0
2010-03-15 15:30:00	AAPL	Stock	7.9721	8.0032	7.9718	7.9964	53561144.0
2010-03-15 16:00:00	AAPL	Stock	7.9964	7.9971	7.9286	7.9946	12536944.0
2010-03-15 16:30:00	AAPL	Stock	7.9946	7.9982	7.9729	7.9968	461076.0
2010-03-15 17:00:00	AAPL	Stock	7.9964	7.9979	7.9957	7.9964	89488.0
2010-03-15 17:30:00	AAPL	Stock	7.9979	7.9979	7.9946	7.9957	75348.0
2010-03-15 18:00:00	AAPL	Stock	7.9961	7.9961	7.9643	7.9771	518168.0
2010-03-15 18:30:00	AAPL	Stock	7.975	7.9811	7.9686	7.9768	162820.0
2010-03-15 19:00:00	AAPL	Stock	7.9786	7.9786	7.9643	7.9643	193900.0
2010-03-15 19:30:00	AAPL	Stock	7.9643	7.9643	7.9532	7.9607	490476.0
2010-03-15 06:30:00	MSFT	Stock	29.15	29.15	29.1	29.1	340.0
2010-03-15 07:00:00	MSFT	Stock	29.21	29.21	29.21	29.21	100.0
2010-03-15 07:30:00	MSFT	Stock	29.2	29.24	29.2	29.24	525.0
2010-03-15 08:00:00	MSFT	Stock	29.22	29.23	29.15	29.2	8175.0
2010-03-15 08:30:00	MSFT	Stock	29.23	29.23	29.23	29.23	608.0
2010-03-15 09:00:00	MSFT	Stock	29.18	29.22	29.17	29.22	4700.0
2010-03-15 09:30:00	MSFT	Stock	29.2	29.37	29.17	29.25	4244541.0
2010-03-15 10:00:00	MSFT	Stock	29.25	29.26	29.13	29.25	3978985.0
2010-03-15 10:30:00	MSFT	Stock	29.25	29.3	29.16	29.16	3844898.0
2010-03-15 11:00:00	MSFT	Stock	29.16	29.21	29.07	29.19	3238025.0
2010-03-15 11:30:00	MSFT	Stock	29.19	29.19	29.06	29.08	2214320.0
2010-03-15 12:00:00	MSFT	Stock	29.085	29.1	29.01	29.06	2727430.0
2010-03-15 12:30:00	MSFT	Stock	29.06	29.17	29.03	29.15	1694358.0
2010-03-15 13:00:00	MSFT	Stock	29.14	29.17	29.08	29.09	1220436.0
2010-03-15 13:30:00	MSFT	Stock	29.095	29.14	29.09	29.12	1081894.0
2010-03-15 14:00:00	MSFT	Stock	29.12	29.13	29.07	29.11	1420796.0
2010-03-15 14:30:00	MSFT	Stock	29.115	29.17	29.065	29.17	1436831.0
2010-03-15 15:00:00	MSFT	Stock	29.17	29.3	29.16	29.29	3223284.0
2010-03-15 15:30:00	MSFT	Stock	29.295	29.33	29.24	29.3	4836198.0
2010-03-15 16:00:00	MSFT	Stock	29.29	29.32	29.157	29.31	1867415.0
2010-03-15 16:30:00	MSFT	Stock	29.3	29.31	29.28	29.31	1250.0
2010-03-15 17:00:00	MSFT	Stock	29.28	29.3	29.26	29.3	1200.0
2010-03-15 17:30:00	MSFT	Stock	29.29	29.29	29.29	29.29	3500.0

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

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