PREVIEW / stock_30min / 2007-03-01

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-03-01.parquet
  size:    1006 KB
  rows:    53,634
  symbols: 2,513

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
2007-03-01 04:30:00	AAPL	Stock	3.0304	3.0304	3.0304	3.0304	2800.0
2007-03-01 07:00:00	AAPL	Stock	3.0354	3.0643	3.0257	3.0607	2477664.0
2007-03-01 07:30:00	AAPL	Stock	3.0621	3.0643	3.0304	3.0304	2245684.0
2007-03-01 08:00:00	AAPL	Stock	3.03	3.0325	3.0	3.0114	9517900.0
2007-03-01 08:30:00	AAPL	Stock	3.0121	3.0211	2.9964	3.0157	7111608.0
2007-03-01 09:00:00	AAPL	Stock	3.0157	3.0196	2.9964	3.0007	6187888.0
2007-03-01 09:30:00	AAPL	Stock	3.0011	3.0446	2.9911	3.0343	202307336.0
2007-03-01 10:00:00	AAPL	Stock	3.0346	3.0693	3.0346	3.0625	151923856.0
2007-03-01 10:30:00	AAPL	Stock	3.0625	3.0889	3.0579	3.0775	139486228.0
2007-03-01 11:00:00	AAPL	Stock	3.0775	3.1025	3.0711	3.0951	110388628.0
2007-03-01 11:30:00	AAPL	Stock	3.0954	3.1214	3.0925	3.1114	119171696.0
2007-03-01 12:00:00	AAPL	Stock	3.1114	3.1182	3.1036	3.1107	73257128.0
2007-03-01 12:30:00	AAPL	Stock	3.1107	3.1336	3.1086	3.1264	70746844.0
2007-03-01 13:00:00	AAPL	Stock	3.1264	3.1379	3.1196	3.1357	53404540.0
2007-03-01 13:30:00	AAPL	Stock	3.1361	3.1386	3.1232	3.1367	58041172.0
2007-03-01 14:00:00	AAPL	Stock	3.1368	3.1539	3.1329	3.1393	89409516.0
2007-03-01 14:30:00	AAPL	Stock	3.1396	3.1514	3.1368	3.1443	60654636.0
2007-03-01 15:00:00	AAPL	Stock	3.1439	3.1446	3.1143	3.1236	101129952.0
2007-03-01 15:30:00	AAPL	Stock	3.1235	3.1246	3.0989	3.1114	137689048.0
2007-03-01 16:00:00	AAPL	Stock	3.1107	3.1146	3.1089	3.1107	2207604.0
2007-03-01 16:30:00	AAPL	Stock	3.1107	3.1111	3.1093	3.1107	191268.0
2007-03-01 17:00:00	AAPL	Stock	3.1107	3.1125	3.1107	3.1107	135492.0
2007-03-01 17:30:00	AAPL	Stock	3.1104	3.1107	3.1082	3.1082	53900.0
2007-03-01 18:00:00	AAPL	Stock	3.1082	3.1107	3.1082	3.1096	48776.0
2007-03-01 18:30:00	AAPL	Stock	3.1089	3.1107	3.1089	3.1107	108724.0
2007-03-01 19:00:00	AAPL	Stock	3.1121	3.1139	3.1111	3.1118	72800.0
2007-03-01 19:30:00	AAPL	Stock	3.1136	3.1136	3.1096	3.1111	100800.0
2007-03-01 08:00:00	MSFT	Stock	28.0	28.17	27.82	27.86	88928.0
2007-03-01 08:30:00	MSFT	Stock	27.9	28.17	27.82	27.83	219268.0
2007-03-01 09:00:00	MSFT	Stock	27.83	27.85	27.79	27.81	561323.0
2007-03-01 09:30:00	MSFT	Stock	27.82	27.92	27.73	27.89	13479785.0
2007-03-01 10:00:00	MSFT	Stock	27.89	28.2	27.89	28.12	10645125.0
2007-03-01 10:30:00	MSFT	Stock	28.12	28.33	28.04	28.17	7000052.0
2007-03-01 11:00:00	MSFT	Stock	28.17	28.25	28.05	28.17	4888818.0
2007-03-01 11:30:00	MSFT	Stock	28.17	28.31	28.1	28.18	5482945.0
2007-03-01 12:00:00	MSFT	Stock	28.18	28.23	28.15	28.202	2653127.0
2007-03-01 12:30:00	MSFT	Stock	28.2	28.23	28.19	28.199	1727730.0
2007-03-01 13:00:00	MSFT	Stock	28.198	28.24	28.16	28.19	2201698.0
2007-03-01 13:30:00	MSFT	Stock	28.2	28.23	28.14	28.23	2683788.0
2007-03-01 14:00:00	MSFT	Stock	28.23	28.33	28.14	28.19	4589370.0
2007-03-01 14:30:00	MSFT	Stock	28.19	28.22	28.17	28.19	3219899.0
2007-03-01 15:00:00	MSFT	Stock	28.19	28.2	28.08	28.11	6681102.0
2007-03-01 15:30:00	MSFT	Stock	28.11	28.21	28.08	28.08	8614750.0
2007-03-01 16:00:00	MSFT	Stock	28.09	28.13	28.07	28.09	29776.0
2007-03-01 16:30:00	MSFT	Stock	28.1	28.1	28.07	28.07	1400.0
2007-03-01 17:00:00	MSFT	Stock	28.1	28.1	28.08	28.09	2620.0
2007-03-01 17:30:00	MSFT	Stock	28.09	28.09	28.09	28.09	700.0
2007-03-01 18:00:00	MSFT	Stock	28.08	28.08	28.07	28.07	450.0
2007-03-01 18:30:00	MSFT	Stock	28.09	28.09	28.07	28.07	1908.0
2007-03-01 19:00:00	MSFT	Stock	28.09	28.09	28.09	28.09	100.0

> showing 50 of 53,634 rows — these rows as CSV

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