PREVIEW / stock_30min / 2007-03-09

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-03-09.parquet
  size:    1.0 MB
  rows:    55,934
  symbols: 2,516

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-09 04:30:00	AAPL	Stock	3.1561	3.1561	3.1561	3.1561	2800.0
2007-03-09 07:30:00	AAPL	Stock	3.1518	3.1518	3.1464	3.1518	176400.0
2007-03-09 08:00:00	AAPL	Stock	3.1514	3.1518	3.1446	3.145	458780.0
2007-03-09 08:30:00	AAPL	Stock	3.1461	3.1679	3.1461	3.1639	4114208.0
2007-03-09 09:00:00	AAPL	Stock	3.1639	3.1761	3.1614	3.1714	3869936.0
2007-03-09 09:30:00	AAPL	Stock	3.1714	3.1732	3.1346	3.14	83325368.0
2007-03-09 10:00:00	AAPL	Stock	3.1396	3.1704	3.1339	3.1489	62638240.0
2007-03-09 10:30:00	AAPL	Stock	3.1493	3.1536	3.1446	3.1496	31401412.0
2007-03-09 11:00:00	AAPL	Stock	3.1496	3.1518	3.1457	3.15	21530600.0
2007-03-09 11:30:00	AAPL	Stock	3.15	3.155	3.1479	3.1499	17915100.0
2007-03-09 12:00:00	AAPL	Stock	3.1504	3.1561	3.1493	3.1521	12391512.0
2007-03-09 12:30:00	AAPL	Stock	3.1518	3.1529	3.1464	3.15	16639560.0
2007-03-09 13:00:00	AAPL	Stock	3.15	3.1511	3.1407	3.1446	24146192.0
2007-03-09 13:30:00	AAPL	Stock	3.145	3.1464	3.1321	3.1329	26460168.0
2007-03-09 14:00:00	AAPL	Stock	3.1325	3.1346	3.1218	3.1257	37433424.0
2007-03-09 14:30:00	AAPL	Stock	3.1261	3.1371	3.1214	3.1354	31207148.0
2007-03-09 15:00:00	AAPL	Stock	3.1357	3.1389	3.1307	3.1382	23894920.0
2007-03-09 15:30:00	AAPL	Stock	3.1386	3.1464	3.1346	3.1418	42049896.0
2007-03-09 16:00:00	AAPL	Stock	3.1414	3.1468	3.1414	3.1457	5183584.0
2007-03-09 16:30:00	AAPL	Stock	3.1482	3.1482	3.1446	3.1471	1045016.0
2007-03-09 17:00:00	AAPL	Stock	3.1443	3.15	3.1443	3.15	267008.0
2007-03-09 17:30:00	AAPL	Stock	3.1475	3.1475	3.1418	3.1418	1161748.0
2007-03-09 18:30:00	AAPL	Stock	3.1457	3.1479	3.1457	3.1464	49280.0
2007-03-09 19:00:00	AAPL	Stock	3.1464	3.1521	3.1464	3.1521	215936.0
2007-03-09 19:30:00	AAPL	Stock	3.1454	3.1454	3.1454	3.1454	5600.0
2007-03-09 07:00:00	MSFT	Stock	27.31	27.31	27.31	27.31	3596.0
2007-03-09 08:00:00	MSFT	Stock	27.3	27.3	27.29	27.3	5010.0
2007-03-09 08:30:00	MSFT	Stock	27.3	27.46	27.3	27.4	42280.0
2007-03-09 09:00:00	MSFT	Stock	27.42	27.47	27.37	27.42	123650.0
2007-03-09 09:30:00	MSFT	Stock	27.42	27.48	27.21	27.23	8589659.0
2007-03-09 10:00:00	MSFT	Stock	27.23	27.35	27.03	27.24	7504529.0
2007-03-09 10:30:00	MSFT	Stock	27.23	27.31	27.21	27.29	3436341.0
2007-03-09 11:00:00	MSFT	Stock	27.28	27.32	27.24	27.29	3196002.0
2007-03-09 11:30:00	MSFT	Stock	27.28	27.32	27.26	27.28	2166328.0
2007-03-09 12:00:00	MSFT	Stock	27.29	27.32	27.26	27.27	2801268.0
2007-03-09 12:30:00	MSFT	Stock	27.27	27.28	27.17	27.22	2521418.0
2007-03-09 13:00:00	MSFT	Stock	27.21	27.29	27.19	27.24	3376392.0
2007-03-09 13:30:00	MSFT	Stock	27.24	27.26	27.19	27.19	2034778.0
2007-03-09 14:00:00	MSFT	Stock	27.19	27.26	27.15	27.16	4215382.0
2007-03-09 14:30:00	MSFT	Stock	27.17	27.24	27.11	27.23	3426575.0
2007-03-09 15:00:00	MSFT	Stock	27.23	27.3	27.18	27.3	4115175.0
2007-03-09 15:30:00	MSFT	Stock	27.29	27.4	27.25	27.29	7699794.0
2007-03-09 16:00:00	MSFT	Stock	27.29	27.38	27.23	27.3	521162.0
2007-03-09 16:30:00	MSFT	Stock	27.28	27.28	27.28	27.28	108896.0
2007-03-09 17:00:00	MSFT	Stock	27.28	27.28	27.28	27.28	2400.0
2007-03-09 17:30:00	MSFT	Stock	27.28	27.28	27.28	27.28	117408.0
2007-03-09 18:00:00	MSFT	Stock	27.28	27.29	27.28	27.29	10200.0
2007-03-09 18:30:00	MSFT	Stock	27.29	27.3	27.29	27.3	1100.0
2007-03-09 19:30:00	MSFT	Stock	27.29	27.29	27.29	27.29	3855.0
2007-03-09 08:00:00	NVDA	Stock	0.55	0.55	0.5183	0.5183	75000.0

> showing 50 of 55,934 rows — these rows as CSV

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