PREVIEW / stock_30min / 2007-12-28

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-12-28.parquet
  size:    1.3 MB
  rows:    74,452
  symbols: 3,263

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-12-28 05:00:00	AAPL	Stock	7.14	7.14	7.14	7.14	2800.0
2007-12-28 07:00:00	AAPL	Stock	7.1607	7.1779	7.1607	7.1771	439012.0
2007-12-28 07:30:00	AAPL	Stock	7.1625	7.175	7.1446	7.1707	634508.0
2007-12-28 08:00:00	AAPL	Stock	7.1679	7.1875	7.1536	7.1668	3784284.0
2007-12-28 08:30:00	AAPL	Stock	7.1679	7.1679	7.1429	7.15	1753024.0
2007-12-28 09:00:00	AAPL	Stock	7.1546	7.1643	7.1443	7.1611	2166892.0
2007-12-28 09:30:00	AAPL	Stock	7.1639	7.1986	7.1475	7.1739	91435512.0
2007-12-28 10:00:00	AAPL	Stock	7.1743	7.1825	7.1414	7.1754	64506176.0
2007-12-28 10:30:00	AAPL	Stock	7.1757	7.1764	7.1268	7.1407	53522560.0
2007-12-28 11:00:00	AAPL	Stock	7.1418	7.1568	7.1204	7.1518	38545500.0
2007-12-28 11:30:00	AAPL	Stock	7.1521	7.1636	7.1314	7.1411	28564592.0
2007-12-28 12:00:00	AAPL	Stock	7.1407	7.1454	7.0914	7.1011	44529464.0
2007-12-28 12:30:00	AAPL	Stock	7.1011	7.1179	7.0539	7.0604	51253748.0
2007-12-28 13:00:00	AAPL	Stock	7.0612	7.1014	7.0314	7.0956	59288628.0
2007-12-28 13:30:00	AAPL	Stock	7.0957	7.1221	7.0707	7.1175	44216004.0
2007-12-28 14:00:00	AAPL	Stock	7.1175	7.125	7.0989	7.1141	35621796.0
2007-12-28 14:30:00	AAPL	Stock	7.1139	7.1375	7.0893	7.1107	48268556.0
2007-12-28 15:00:00	AAPL	Stock	7.1107	7.1229	7.0761	7.1164	47042296.0
2007-12-28 15:30:00	AAPL	Stock	7.115	7.1414	7.1046	7.135	56984172.0
2007-12-28 16:00:00	AAPL	Stock	7.1382	7.1386	7.1136	7.135	11057760.0
2007-12-28 16:30:00	AAPL	Stock	7.1357	7.1398	7.1263	7.1361	8928248.0
2007-12-28 17:00:00	AAPL	Stock	7.1368	7.1414	7.1361	7.1414	284452.0
2007-12-28 17:30:00	AAPL	Stock	7.1621	7.1621	7.0918	7.1414	482944.0
2007-12-28 18:00:00	AAPL	Stock	7.1396	7.1411	7.1264	7.1375	6193768.0
2007-12-28 18:30:00	AAPL	Stock	7.1375	7.1432	7.1375	7.1429	66864.0
2007-12-28 19:00:00	AAPL	Stock	7.1393	7.1429	7.1393	7.1411	34832.0
2007-12-28 19:30:00	AAPL	Stock	7.1425	7.1432	7.1396	7.1429	216412.0
2007-12-28 08:00:00	MSFT	Stock	36.1	36.15	35.97	36.15	233023.0
2007-12-28 08:30:00	MSFT	Stock	36.16	36.16	36.15	36.15	1650.0
2007-12-28 09:00:00	MSFT	Stock	36.15	36.17	36.01	36.15	84096.0
2007-12-28 09:30:00	MSFT	Stock	36.1	36.19	36.0	36.07	2970449.0
2007-12-28 10:00:00	MSFT	Stock	36.07	36.16	35.968	36.09	2494611.0
2007-12-28 10:30:00	MSFT	Stock	36.082	36.15	36.05	36.062	1577604.0
2007-12-28 11:00:00	MSFT	Stock	36.07	36.08	35.97	36.005	1598078.0
2007-12-28 11:30:00	MSFT	Stock	36.0	36.08	36.0	36.06	1279422.0
2007-12-28 12:00:00	MSFT	Stock	36.06	36.07	35.88	35.9	1641929.0
2007-12-28 12:30:00	MSFT	Stock	35.9	35.92	35.69	35.71	2443256.0
2007-12-28 13:00:00	MSFT	Stock	35.72	35.85	35.67	35.85	1985967.0
2007-12-28 13:30:00	MSFT	Stock	35.85	36.13	35.85	36.12	2215473.0
2007-12-28 14:00:00	MSFT	Stock	36.113	36.13	36.04	36.13	2013745.0
2007-12-28 14:30:00	MSFT	Stock	36.12	36.23	36.02	36.03	2358108.0
2007-12-28 15:00:00	MSFT	Stock	36.027	36.1	35.92	36.02	3529631.0
2007-12-28 15:30:00	MSFT	Stock	36.02	36.14	35.992	36.1	4687199.0
2007-12-28 16:00:00	MSFT	Stock	36.11	36.12	35.907	36.019	1608219.0
2007-12-28 16:30:00	MSFT	Stock	36.019	36.12	35.976	35.976	78289.0
2007-12-28 17:00:00	MSFT	Stock	36.059	36.059	36.04	36.04	60200.0
2007-12-28 17:30:00	MSFT	Stock	36.09	36.09	36.022	36.022	24533.0
2007-12-28 18:00:00	MSFT	Stock	36.022	36.12	36.022	36.12	596295.0
2007-12-28 19:00:00	MSFT	Stock	36.1	36.1	36.1	36.1	345.0
2007-12-28 19:30:00	MSFT	Stock	36.09	36.09	36.09	36.09	200.0

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

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