PREVIEW / stock_30min / 2009-11-30

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-11-30.parquet
  size:    1.4 MB
  rows:    76,183
  symbols: 3,436

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
2009-11-30 05:00:00	AAPL	Stock	7.1786	7.1786	7.1786	7.1786	27020.0
2009-11-30 06:00:00	AAPL	Stock	7.1786	7.1786	7.1786	7.1786	2800.0
2009-11-30 06:30:00	AAPL	Stock	7.1786	7.1786	7.1782	7.1782	30800.0
2009-11-30 07:00:00	AAPL	Stock	7.1643	7.1875	7.1639	7.1875	180180.0
2009-11-30 07:30:00	AAPL	Stock	7.1893	7.2054	7.1789	7.2054	130900.0
2009-11-30 08:00:00	AAPL	Stock	7.2039	7.2393	7.2039	7.2286	1393364.0
2009-11-30 08:30:00	AAPL	Stock	7.2268	7.23	7.1839	7.2143	989884.0
2009-11-30 09:00:00	AAPL	Stock	7.2207	7.2211	7.1825	7.1825	1867768.0
2009-11-30 09:30:00	AAPL	Stock	7.1854	7.2029	7.1489	7.1771	66543512.0
2009-11-30 10:00:00	AAPL	Stock	7.1782	7.2	7.1696	7.1761	35710192.0
2009-11-30 10:30:00	AAPL	Stock	7.1751	7.1854	7.1518	7.1536	28932652.0
2009-11-30 11:00:00	AAPL	Stock	7.1539	7.1543	7.1071	7.1096	45977792.0
2009-11-30 11:30:00	AAPL	Stock	7.1093	7.1211	7.0989	7.1054	31361792.0
2009-11-30 12:00:00	AAPL	Stock	7.1054	7.125	7.1036	7.1214	18261460.0
2009-11-30 12:30:00	AAPL	Stock	7.1211	7.1229	7.1039	7.1161	15644048.0
2009-11-30 13:00:00	AAPL	Stock	7.1145	7.1286	7.1125	7.1279	16820972.0
2009-11-30 13:30:00	AAPL	Stock	7.1268	7.1557	7.1143	7.1479	26541312.0
2009-11-30 14:00:00	AAPL	Stock	7.1471	7.1479	7.1143	7.1364	13029716.0
2009-11-30 14:30:00	AAPL	Stock	7.1364	7.1386	7.1221	7.1239	13165264.0
2009-11-30 15:00:00	AAPL	Stock	7.1239	7.1657	7.1229	7.1554	33251008.0
2009-11-30 15:30:00	AAPL	Stock	7.1554	7.1679	7.1318	7.1411	48393996.0
2009-11-30 16:00:00	AAPL	Stock	7.1407	7.1834	7.1286	7.1396	16982644.0
2009-11-30 16:30:00	AAPL	Stock	7.1404	7.1655	7.1357	7.1396	1042440.0
2009-11-30 17:00:00	AAPL	Stock	7.1429	7.15	7.1381	7.1425	711592.0
2009-11-30 17:30:00	AAPL	Stock	7.1425	7.1486	7.1425	7.1446	125384.0
2009-11-30 18:00:00	AAPL	Stock	7.1639	7.1639	7.1396	7.1429	269976.0
2009-11-30 18:30:00	AAPL	Stock	7.1429	7.1477	7.1396	7.1396	66556.0
2009-11-30 19:00:00	AAPL	Stock	7.1411	7.1411	7.1179	7.1254	386484.0
2009-11-30 19:30:00	AAPL	Stock	7.1275	7.1421	7.1275	7.1421	140336.0
2009-11-30 20:00:00	AAPL	Stock	7.1236	7.1236	7.1236	7.1236	6104.0
2009-11-30 04:30:00	MSFT	Stock	29.15	29.15	29.15	29.15	100.0
2009-11-30 08:30:00	MSFT	Stock	29.28	29.28	29.25	29.27	12440.0
2009-11-30 09:00:00	MSFT	Stock	29.27	29.27	29.13	29.15	39886.0
2009-11-30 09:30:00	MSFT	Stock	29.15	29.21	29.0	29.14	5205219.0
2009-11-30 10:00:00	MSFT	Stock	29.15	29.3	29.142	29.29	3352580.0
2009-11-30 10:30:00	MSFT	Stock	29.29	29.39	29.16	29.19	3018925.0
2009-11-30 11:00:00	MSFT	Stock	29.19	29.2	29.1	29.1	1880530.0
2009-11-30 11:30:00	MSFT	Stock	29.1	29.12	29.012	29.11	2862609.0
2009-11-30 12:00:00	MSFT	Stock	29.1	29.18	29.1	29.17	1576514.0
2009-11-30 12:30:00	MSFT	Stock	29.17	29.17	29.1	29.13	1639385.0
2009-11-30 13:00:00	MSFT	Stock	29.135	29.25	29.13	29.25	1674972.0
2009-11-30 13:30:00	MSFT	Stock	29.25	29.34	29.21	29.31	2549560.0
2009-11-30 14:00:00	MSFT	Stock	29.32	29.34	29.26	29.31	1517311.0
2009-11-30 14:30:00	MSFT	Stock	29.3	29.378	29.27	29.29	2932313.0
2009-11-30 15:00:00	MSFT	Stock	29.28	29.4	29.28	29.39	3149807.0
2009-11-30 15:30:00	MSFT	Stock	29.4	29.45	29.35	29.41	6645911.0
2009-11-30 16:00:00	MSFT	Stock	29.41	29.45	29.203	29.398	4235421.0
2009-11-30 16:30:00	MSFT	Stock	29.256	29.43	29.214	29.41	347113.0
2009-11-30 17:00:00	MSFT	Stock	29.41	29.416	29.404	29.41	421937.0
2009-11-30 17:30:00	MSFT	Stock	29.44	29.44	29.44	29.44	100.0

> showing 50 of 76,183 rows — these rows as CSV

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